View: PAY_BATCH_BAL_ADJ_CE_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_BATCH_BAL_ADJ_CE_V

View Text

SELECT PBBH.BATCH_ID
, PBBH.BATCH_NAME
, ETTL.ELEMENT_NAME
, PBBH.BUSINESS_GROUP_ID
, PABG.BATCH_GROUP_ID
, PABL.BATCH_LINE_ID
, PABL.BATCH_LINE_STATUS
, ET.ELEMENT_TYPE_ID
, NULL
, PABG.EFFECTIVE_DATE
, PPF.FULL_NAME
, PAF.ASSIGNMENT_NUMBER
, PP.PAYROLL_NAME
, PCS.CONSOLIDATION_SET_NAME
, DECODE(PABL.TAX_UNIT_ID
, NULL
, NULL
, (SELECT NAME
FROM HR_ALL_ORGANIZATION_UNITS_TL
WHERE LANGUAGE = USERENV('LANG')
AND ORGANIZATION_ID = PABL.TAX_UNIT_ID)) GRE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PABG.PREPAY_FLAG) PREPAY_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PABL.BALANCE_ADJ_COST_FLAG) COSTING_FLAG
, PABL.COST_ALLOCATION_KEYFLEX_ID
, CAK.CONCATENATED_SEGMENTS
, CAK.SEGMENT1
, CAK.SEGMENT2
, CAK.SEGMENT3
, CAK.SEGMENT4
, CAK.SEGMENT5
, CAK.SEGMENT6
, CAK.SEGMENT7
, CAK.SEGMENT8
, CAK.SEGMENT9
, CAK.SEGMENT10
, CAK.SEGMENT11
, CAK.SEGMENT12
, CAK.SEGMENT13
, CAK.SEGMENT14
, CAK.SEGMENT15
, CAK.SEGMENT16
, CAK.SEGMENT17
, CAK.SEGMENT18
, CAK.SEGMENT19
, CAK.SEGMENT20
, CAK.SEGMENT21
, CAK.SEGMENT22
, CAK.SEGMENT23
, CAK.SEGMENT24
, CAK.SEGMENT25
, CAK.SEGMENT26
, CAK.SEGMENT27
, CAK.SEGMENT28
, CAK.SEGMENT29
, CAK.SEGMENT30
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE1
, 1
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL1
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE2
, 2
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL2
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE3
, 3
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL3
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE4
, 4
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL4
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE5
, 5
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL5
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE6
, 6
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL6
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE7
, 7
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL7
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE8
, 8
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL8
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE9
, 9
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL9
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE10
, 10
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL10
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE11
, 11
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL11
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE12
, 12
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL12
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE13
, 13
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL13
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE14
, 14
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL14
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE15
, 15
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL15
, DECODE(PABL.BATCH_LINE_STATUS
, 'E'
, (SELECT LINE_TEXT
FROM PAY_MESSAGE_LINES
WHERE SOURCE_TYPE='L'
AND SOURCE_ID = PABL.BATCH_LINE_ID)
, NULL) ERROR_MESSAGE
FROM PAY_ADJUST_BATCH_LINES PABL
, PAY_ADJUST_BATCH_GROUPS PABG
, PAY_BALANCE_BATCH_HEADERS PBBH
, PAY_ELEMENT_TYPES_F_TL ETTL
, PAY_ELEMENT_TYPES_F ET
, PER_ALL_PEOPLE_F PPF
, PER_ALL_ASSIGNMENTS_F PAF
, PAY_ALL_PAYROLLS_F PP
, PAY_CONSOLIDATION_SETS PCS
, PAY_COST_ALLOCATION_KEYFLEX CAK
WHERE PABG.BATCH_ID = PBBH.BATCH_ID
AND PABL.BATCH_ID = PBBH.BATCH_ID
AND PABG.BATCH_GROUP_STATUS NOT IN ('L'
, 'T')
AND PABL.BATCH_GROUP_ID = PABG.BATCH_GROUP_ID
AND PABL.BATCH_LINE_STATUS != 'T'
AND ET.ELEMENT_TYPE_ID = PABL.ELEMENT_TYPE_ID
AND PABG.EFFECTIVE_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE
AND ETTL.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID
AND ETTL.LANGUAGE = USERENV('LANG')
AND PAF.ASSIGNMENT_ID = PABL.ASSIGNMENT_ID
AND PABG.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PAF.PERSON_ID = PPF.PERSON_ID
AND PABG.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PABG.PAYROLL_ID = PP.PAYROLL_ID
AND PABG.EFFECTIVE_DATE BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE
AND PABG.CONSOLIDATION_SET_ID = PCS.CONSOLIDATION_SET_ID
AND CAK.COST_ALLOCATION_KEYFLEX_ID(+) = PABL.COST_ALLOCATION_KEYFLEX_ID

Columns