PAY_ELEMENT_BATCH

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
BATCH_ID BATCH_LINE_ID BATCH_LINE_STATUS TEMPLATE_NAME ELEMENT_NAME REPORTING_NAME DESCRIPTION EFFECTIVE_DATE ONCE_PER_PERIOD PROCESS_PERIOD PRORATION_GROUP PRORATION_GROUP_ID RATE_PAY_SOURCE RECURRING_OR_NONRECURRING REDUCE_REGULAR ROTH_401K EXCLUSIONRULECN SECONDARYCLASSIFICATIONNAMECN SECONDARYCLASSIFICATIONN_ID USERENTERABLEFLAGCN AMOUNT_CALCULATION_SOURCE AMOUNT_PAY_SOURCE AMOUNT_USER_ROW AMOUNT_USER_TABLE CLASSIFICATIONNAME CLASSIFICATIONNAME_ID MULTIPLE_ENTRIES OUTPUTCURRENCY PROCESSING_ASG_LEVEL PROCESSING_TERM_LEVEL RATE_CALCULATION_SOURCE RATE_USER_ROW TOTAL_REACHED ENTRYLEVEL2 CATCHUP_PROCESSING_401K FREQUENCY_401K MULTIPLE_ALLOWED_401K MULTIPLE_ENTRIES_401K RECURRING_RULE_401K AVAILABILITY_RULE ITERATIVEPRIORITY PROCESSING_LEVEL2TIER PRORATIONFORMULA PRORATIONFORMULA_ID AMOUNT_RULE_401K START_401K PRIMARYCLASSIFICATIONNAMECN PRIMARYCLASSIFICATIONCN_ID EARNINGS_USER_COLUMN ITERATIVEFORMULA ITERATIVEFORMULA_ID TERMINATE_PROCESS TERMINATE_PROCESS_ID PARTIAL_DEDUCTION_401K STOP_RULE_401K ARREAR_PARTIAL_DEDN CALCULATIONRULE EARNING_PAY_SOURCE EARNINGS_USER_ROW PROCESSING_LEVEL PROCESSING_REL_LEVEL PRORATION RETROGROUP RETROGROUP_ID SECCLASSIFICATIONNAME SECCLASSIFICATIONNAME_ID ITERATIVEINFORMATION ENTRYLEVEL1 ARRERAGE_DEDUCTION_401K ELGIBILITY_RULE_401K AMOUNT_USER_COLUMN DEDUCTION_START EARNINGS_USER_TABLE PRIMARYCLASSNAME PRIMARYCLASSNAME_ID RATE_USER_COLUMN RATE_USER_TABLE PROCESSING_TYPE_401K CALCULATION_SOURCE_BAL CALCULATIONRULEDEDN HIRE_PROCESS HIRE_PROCESS_ID RETRO SECONDARYCLASSNAME SECONDARYCLASSNAME_ID SPECCURRENCY TERMINATION_RULE_401K USERRA_PROCESSING_401K ELEMENT_TYPE_ID

Name

BATCH_ID

BATCH_LINE_ID

BATCH_LINE_STATUS

TEMPLATE_NAME

ELEMENT_NAME

REPORTING_NAME

DESCRIPTION

EFFECTIVE_DATE

ONCE_PER_PERIOD

PROCESS_PERIOD

PRORATION_GROUP

PRORATION_GROUP_ID

RATE_PAY_SOURCE

RECURRING_OR_NONRECURRING

REDUCE_REGULAR

ROTH_401K

EXCLUSIONRULECN

SECONDARYCLASSIFICATIONNAMECN

SECONDARYCLASSIFICATIONN_ID

USERENTERABLEFLAGCN

AMOUNT_CALCULATION_SOURCE

AMOUNT_PAY_SOURCE

AMOUNT_USER_ROW

AMOUNT_USER_TABLE

CLASSIFICATIONNAME

CLASSIFICATIONNAME_ID

MULTIPLE_ENTRIES

OUTPUTCURRENCY

PROCESSING_ASG_LEVEL

PROCESSING_TERM_LEVEL

RATE_CALCULATION_SOURCE

RATE_USER_ROW

TOTAL_REACHED

ENTRYLEVEL2

CATCHUP_PROCESSING_401K

FREQUENCY_401K

MULTIPLE_ALLOWED_401K

MULTIPLE_ENTRIES_401K

RECURRING_RULE_401K

AVAILABILITY_RULE

ITERATIVEPRIORITY

PROCESSING_LEVEL2TIER

PRORATIONFORMULA

PRORATIONFORMULA_ID

AMOUNT_RULE_401K

START_401K

PRIMARYCLASSIFICATIONNAMECN

PRIMARYCLASSIFICATIONCN_ID

EARNINGS_USER_COLUMN

ITERATIVEFORMULA

ITERATIVEFORMULA_ID

TERMINATE_PROCESS

TERMINATE_PROCESS_ID

PARTIAL_DEDUCTION_401K

STOP_RULE_401K

ARREAR_PARTIAL_DEDN

CALCULATIONRULE

EARNING_PAY_SOURCE

EARNINGS_USER_ROW

PROCESSING_LEVEL

PROCESSING_REL_LEVEL

PRORATION

RETROGROUP

RETROGROUP_ID

SECCLASSIFICATIONNAME

SECCLASSIFICATIONNAME_ID

ITERATIVEINFORMATION

ENTRYLEVEL1

ARRERAGE_DEDUCTION_401K

ELGIBILITY_RULE_401K

AMOUNT_USER_COLUMN

DEDUCTION_START

EARNINGS_USER_TABLE

PRIMARYCLASSNAME

PRIMARYCLASSNAME_ID

RATE_USER_COLUMN

RATE_USER_TABLE

PROCESSING_TYPE_401K

CALCULATION_SOURCE_BAL

CALCULATIONRULEDEDN

HIRE_PROCESS

HIRE_PROCESS_ID

RETRO

SECONDARYCLASSNAME

SECONDARYCLASSNAME_ID

SPECCURRENCY

TERMINATION_RULE_401K

USERRA_PROCESSING_401K

ELEMENT_TYPE_ID

Query

SQL_Statement
SELECT pbl.BATCH_ID, pbl.BATCH_LINE_ID, pbl.BATCH_LINE_STATUS, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','TEMPLATENAME'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS TEMPLATE_NAME, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','BNAME'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ELEMENT_NAME, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RNAME'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS REPORTING_NAME, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','DESCRIPTION'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS DESCRIPTION, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','EFFECTIVESTARTDATE'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS EFFECTIVE_DATE, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE1'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ONCE_PER_PERIOD, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE2'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESS_PERIOD, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE3'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('EVENT',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS PRORATION_GROUP, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE3'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PRORATION_GROUP_ID, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE4'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RATE_PAY_SOURCE, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE5'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RECURRING_OR_NONRECURRING, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE6'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS REDUCE_REGULAR, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE7'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ROTH_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE8'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS EXCLUSIONRULECN, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE9'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('CLASS',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS SECONDARYCLASSIFICATIONNAMECN, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE9'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS SECONDARYCLASSIFICATIONN_ID, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE10'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS USERENTERABLEFLAGCN, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE11'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AMOUNT_CALCULATION_SOURCE, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE12'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AMOUNT_PAY_SOURCE, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE13'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AMOUNT_USER_ROW, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE14'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AMOUNT_USER_TABLE, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE15'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('CLASS',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS CLASSIFICATIONNAME, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE15'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS CLASSIFICATIONNAME_ID, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE16'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS MULTIPLE_ENTRIES, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE17'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS OUTPUTCURRENCY, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE18'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESSING_ASG_LEVEL, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE19'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESSING_TERM_LEVEL, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE20'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RATE_CALCULATION_SOURCE, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE21'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RATE_USER_ROW, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE22'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS TOTAL_REACHED, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE23'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ENTRYLEVEL2, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE24'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS CATCHUP_PROCESSING_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE25'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS FREQUENCY_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE26'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS MULTIPLE_ALLOWED_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE27'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS MULTIPLE_ENTRIES_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE28'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RECURRING_RULE_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE29'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AVAILABILITY_RULE, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE30'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ITERATIVEPRIORITY, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE31'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESSING_LEVEL2TIER, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE32'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('FORMULA',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS PRORATIONFORMULA, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE32'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PRORATIONFORMULA_ID, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE33'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AMOUNT_RULE_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE34'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS START_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE35'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('CLASS',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS PRIMARYCLASSIFICATIONNAMECN, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE35'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PRIMARYCLASSIFICATIONCN_ID, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE36'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS EARNINGS_USER_COLUMN, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE37'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('FORMULA',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS ITERATIVEFORMULA, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE37'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ITERATIVEFORMULA_ID, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE38'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('TIME',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS TERMINATE_PROCESS, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE38'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS TERMINATE_PROCESS_ID, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE39'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PARTIAL_DEDUCTION_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE40'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS STOP_RULE_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE41'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ARREAR_PARTIAL_DEDN, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE42'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS CALCULATIONRULE, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE43'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS EARNING_PAY_SOURCE, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE44'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS EARNINGS_USER_ROW, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE45'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESSING_LEVEL, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE46'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESSING_REL_LEVEL, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE47'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PRORATION, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE48'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('EVENT',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS RETROGROUP, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE48'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RETROGROUP_ID, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE49'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('CLASS',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS SECCLASSIFICATIONNAME, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE49'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS SECCLASSIFICATIONNAME_ID, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE50'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ITERATIVEINFORMATION, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE51'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ENTRYLEVEL1, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE52'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ARRERAGE_DEDUCTION_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE53'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ELGIBILITY_RULE_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE54'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AMOUNT_USER_COLUMN, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE55'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS DEDUCTION_START, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE56'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS EARNINGS_USER_TABLE, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE57'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('CLASS',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS PRIMARYCLASSNAME, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE57'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PRIMARYCLASSNAME_ID, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE58'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RATE_USER_COLUMN, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE59'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RATE_USER_TABLE, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE60'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESSING_TYPE_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE61'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS CALCULATION_SOURCE_BAL, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE62'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS CALCULATIONRULEDEDN, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE63'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('TIME',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS HIRE_PROCESS, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE63'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS HIRE_PROCESS_ID, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE64'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RETRO, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE65'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('CLASS',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS SECONDARYCLASSNAME, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE65'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS SECONDARYCLASSNAME_ID, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE66'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS SPECCURRENCY, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE67'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS TERMINATION_RULE_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE68'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS USERRA_PROCESSING_401K, MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','BNAME'), (select distinct element_type_id from pay_element_types_f pet where pet.base_element_name = pblv.ACTION_PARAMETER_VALUE and pet.legislative_data_group_id = pbh.legislative_data_group_id), NULL)) AS Element_Type_Id FROM PAY_BATCH_LINES pbl, PAY_BATCH_LINE_VALUES pblv, pay_batch_headers pbh WHERE pbl.BATCH_LINE_ID = pblv.BATCH_LINE_ID AND pbh.batch_id=pbl.batch_id GROUP BY pbl.BATCH_ID, pbl.BATCH_LINE_ID, pbl.BATCH_LINE_STATUS

SQL_Statement

SELECT pbl.BATCH_ID,

pbl.BATCH_LINE_ID,

pbl.BATCH_LINE_STATUS,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','TEMPLATENAME'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS TEMPLATE_NAME,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','BNAME'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ELEMENT_NAME,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RNAME'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS REPORTING_NAME,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','DESCRIPTION'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS DESCRIPTION,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','EFFECTIVESTARTDATE'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS EFFECTIVE_DATE,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE1'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ONCE_PER_PERIOD,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE2'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESS_PERIOD,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE3'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('EVENT',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS PRORATION_GROUP,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE3'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PRORATION_GROUP_ID,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE4'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RATE_PAY_SOURCE,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE5'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RECURRING_OR_NONRECURRING,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE6'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS REDUCE_REGULAR,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE7'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ROTH_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE8'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS EXCLUSIONRULECN,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE9'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('CLASS',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS SECONDARYCLASSIFICATIONNAMECN,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE9'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS SECONDARYCLASSIFICATIONN_ID,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE10'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS USERENTERABLEFLAGCN,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE11'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AMOUNT_CALCULATION_SOURCE,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE12'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AMOUNT_PAY_SOURCE,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE13'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AMOUNT_USER_ROW,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE14'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AMOUNT_USER_TABLE,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE15'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('CLASS',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS CLASSIFICATIONNAME,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE15'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS CLASSIFICATIONNAME_ID,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE16'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS MULTIPLE_ENTRIES,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE17'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS OUTPUTCURRENCY,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE18'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESSING_ASG_LEVEL,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE19'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESSING_TERM_LEVEL,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE20'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RATE_CALCULATION_SOURCE,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE21'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RATE_USER_ROW,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE22'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS TOTAL_REACHED,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE23'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ENTRYLEVEL2,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE24'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS CATCHUP_PROCESSING_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE25'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS FREQUENCY_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE26'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS MULTIPLE_ALLOWED_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE27'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS MULTIPLE_ENTRIES_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE28'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RECURRING_RULE_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE29'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AVAILABILITY_RULE,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE30'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ITERATIVEPRIORITY,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE31'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESSING_LEVEL2TIER,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE32'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('FORMULA',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS PRORATIONFORMULA,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE32'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PRORATIONFORMULA_ID,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE33'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AMOUNT_RULE_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE34'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS START_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE35'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('CLASS',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS PRIMARYCLASSIFICATIONNAMECN,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE35'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PRIMARYCLASSIFICATIONCN_ID,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE36'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS EARNINGS_USER_COLUMN,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE37'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('FORMULA',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS ITERATIVEFORMULA,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE37'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ITERATIVEFORMULA_ID,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE38'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('TIME',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS TERMINATE_PROCESS,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE38'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS TERMINATE_PROCESS_ID,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE39'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PARTIAL_DEDUCTION_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE40'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS STOP_RULE_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE41'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ARREAR_PARTIAL_DEDN,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE42'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS CALCULATIONRULE,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE43'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS EARNING_PAY_SOURCE,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE44'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS EARNINGS_USER_ROW,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE45'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESSING_LEVEL,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE46'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESSING_REL_LEVEL,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE47'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PRORATION,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE48'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('EVENT',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS RETROGROUP,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE48'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RETROGROUP_ID,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE49'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('CLASS',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS SECCLASSIFICATIONNAME,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE49'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS SECCLASSIFICATIONNAME_ID,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE50'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ITERATIVEINFORMATION,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE51'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ENTRYLEVEL1,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE52'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ARRERAGE_DEDUCTION_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE53'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS ELGIBILITY_RULE_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE54'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS AMOUNT_USER_COLUMN,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE55'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS DEDUCTION_START,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE56'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS EARNINGS_USER_TABLE,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE57'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('CLASS',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS PRIMARYCLASSNAME,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE57'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PRIMARYCLASSNAME_ID,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE58'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RATE_USER_COLUMN,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE59'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RATE_USER_TABLE,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE60'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS PROCESSING_TYPE_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE61'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS CALCULATION_SOURCE_BAL,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE62'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS CALCULATIONRULEDEDN,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE63'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('TIME',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS HIRE_PROCESS,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE63'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS HIRE_PROCESS_ID,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE64'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS RETRO,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE65'), (PAY_ELEMENT_BATCH_LINES_PKG.get_name('CLASS',pblv.ACTION_PARAMETER_VALUE)), NULL)) AS SECONDARYCLASSNAME,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE65'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS SECONDARYCLASSNAME_ID,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE66'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS SPECCURRENCY,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE67'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS TERMINATION_RULE_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','RULE68'), (pblv.ACTION_PARAMETER_VALUE), NULL)) AS USERRA_PROCESSING_401K,

MAX(DECODE(pblv.ACTION_PARAMETER_ID, PAY_BATCH_LDR_PKG.get_param_id(pbh.legislative_data_group_id,'ELEMENT','CREATE','BNAME'), (select distinct element_type_id from

pay_element_types_f pet where pet.base_element_name = pblv.ACTION_PARAMETER_VALUE and pet.legislative_data_group_id = pbh.legislative_data_group_id), NULL)) AS Element_Type_Id

FROM PAY_BATCH_LINES pbl,

PAY_BATCH_LINE_VALUES pblv,

pay_batch_headers pbh

WHERE pbl.BATCH_LINE_ID = pblv.BATCH_LINE_ID

AND pbh.batch_id=pbl.batch_id

GROUP BY pbl.BATCH_ID, pbl.BATCH_LINE_ID, pbl.BATCH_LINE_STATUS