Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_PDT_BATCH_LINES_V1 |
SELECT /* FIRST CREATE A VIEW THAT SHOWS AN ELEMENTS INPUT VALUES IN THE SAME ORDER ** AS THEY ARE HELD IN PAY_BATCH_LINES. IE VALUE_1 TO VALUE_15 */ ROWNUM-B.MIN_ROWNUM+1 IV_SEQ
, A.NAME
, A.BUSINESS_GROUP_ID
, A.LEGISLATION_CODE
, A.BATCH_LINE_ID
, A.COST_ALLOCATION_KEYFLEX_ID
, A.ELEMENT_TYPE_ID
, A.ASSIGNMENT_ID
, A.BATCH_ID
, A.BATCH_LINE_STATUS
, A.ASSIGNMENT_NUMBER
, A.BATCH_SEQUENCE
, A.CONCATENATED_SEGMENTS
, A.EFFECTIVE_DATE
, A.ELEMENT_NAME
, A.ENTRY_TYPE
, A.REASON
, A.SEGMENT1
, A.SEGMENT2
, A.SEGMENT3
, A.SEGMENT4
, A.SEGMENT5
, A.SEGMENT6
, A.SEGMENT7
, A.SEGMENT8
, A.SEGMENT9
, A.SEGMENT10
, A.SEGMENT11
, A.SEGMENT12
, A.SEGMENT13
, A.SEGMENT14
, A.SEGMENT15
, A.SEGMENT16
, A.SEGMENT17
, A.SEGMENT18
, A.SEGMENT19
, A.SEGMENT20
, A.SEGMENT21
, A.SEGMENT22
, A.SEGMENT23
, A.SEGMENT24
, A.SEGMENT25
, A.SEGMENT26
, A.SEGMENT27
, A.SEGMENT28
, A.SEGMENT29
, A.SEGMENT30
, A.VALUE_1
, A.VALUE_2
, A.VALUE_3
, A.VALUE_4
, A.VALUE_5
, A.VALUE_6
, A.VALUE_7
, A.VALUE_8
, A.VALUE_9
, A.VALUE_10
, A.VALUE_11
, A.VALUE_12
, A.VALUE_13
, A.VALUE_14
, A.VALUE_15
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE16
, A.ATTRIBUTE17
, A.ATTRIBUTE18
, A.ATTRIBUTE19
, A.ATTRIBUTE20
FROM ( SELECT ET.ELEMENT_NAME
, ET.ELEMENT_TYPE_ID
, IV.NAME
, BH.BUSINESS_GROUP_ID
, ET.LEGISLATION_CODE
, BL.BATCH_LINE_ID
, BL.COST_ALLOCATION_KEYFLEX_ID
, BL.ASSIGNMENT_ID
, BL.BATCH_ID
, BL.BATCH_LINE_STATUS
, BL.ASSIGNMENT_NUMBER
, BL.BATCH_SEQUENCE
, BL.CONCATENATED_SEGMENTS
, BL.EFFECTIVE_DATE
, BL.ENTRY_TYPE
, BL.REASON
, BL.SEGMENT1
, BL.SEGMENT2
, BL.SEGMENT3
, BL.SEGMENT4
, BL.SEGMENT5
, BL.SEGMENT6
, BL.SEGMENT7
, BL.SEGMENT8
, BL.SEGMENT9
, BL.SEGMENT10
, BL.SEGMENT11
, BL.SEGMENT12
, BL.SEGMENT13
, BL.SEGMENT14
, BL.SEGMENT15
, BL.SEGMENT16
, BL.SEGMENT17
, BL.SEGMENT18
, BL.SEGMENT19
, BL.SEGMENT20
, BL.SEGMENT21
, BL.SEGMENT22
, BL.SEGMENT23
, BL.SEGMENT24
, BL.SEGMENT25
, BL.SEGMENT26
, BL.SEGMENT27
, BL.SEGMENT28
, BL.SEGMENT29
, BL.SEGMENT30
, BL.VALUE_1
, BL.VALUE_2
, BL.VALUE_3
, BL.VALUE_4
, BL.VALUE_5
, BL.VALUE_6
, BL.VALUE_7
, BL.VALUE_8
, BL.VALUE_9
, BL.VALUE_10
, BL.VALUE_11
, BL.VALUE_12
, BL.VALUE_13
, BL.VALUE_14
, BL.VALUE_15
, BL.ATTRIBUTE_CATEGORY
, BL.ATTRIBUTE1
, BL.ATTRIBUTE2
, BL.ATTRIBUTE3
, BL.ATTRIBUTE4
, BL.ATTRIBUTE5
, BL.ATTRIBUTE6
, BL.ATTRIBUTE7
, BL.ATTRIBUTE8
, BL.ATTRIBUTE9
, BL.ATTRIBUTE10
, BL.ATTRIBUTE11
, BL.ATTRIBUTE12
, BL.ATTRIBUTE13
, BL.ATTRIBUTE14
, BL.ATTRIBUTE15
, BL.ATTRIBUTE16
, BL.ATTRIBUTE17
, BL.ATTRIBUTE18
, BL.ATTRIBUTE19
, BL.ATTRIBUTE20
FROM PAY_ELEMENT_TYPES_F ET
, PAY_INPUT_VALUES_F IV
, PAY_BATCH_LINES BL
, PAY_BATCH_HEADERS BH
, PER_BUSINESS_GROUPS BG
WHERE ET.ELEMENT_TYPE_ID = IV.ELEMENT_TYPE_ID
AND ( ((BL.ELEMENT_TYPE_ID IS NOT NULL)
AND ( ET.ELEMENT_TYPE_ID = BL.ELEMENT_TYPE_ID)) OR ((BL.ELEMENT_NAME IS NOT NULL)
AND ( ET.ELEMENT_NAME = BL.ELEMENT_NAME )) )
AND BH.BATCH_ID = BL.BATCH_ID
AND BG.BUSINESS_GROUP_ID = BH.BUSINESS_GROUP_ID
AND BL.EFFECTIVE_DATE BETWEEN IV.EFFECTIVE_START_DATE
AND IV.EFFECTIVE_END_DATE
AND BL.EFFECTIVE_DATE BETWEEN IV.EFFECTIVE_START_DATE
AND IV.EFFECTIVE_END_DATE
AND ( ( IV.BUSINESS_GROUP_ID IS NULL
AND IV.LEGISLATION_CODE = BG.LEGISLATION_CODE ) OR IV.BUSINESS_GROUP_ID = BH.BUSINESS_GROUP_ID )
AND BH.BATCH_NAME = 'BATCH '||TO_CHAR( BH.BATCH_ID ) ORDER BY BL.BATCH_LINE_ID
, ET.ELEMENT_TYPE_ID
, IV.DISPLAY_SEQUENCE
, IV.NAME ) A
, ( SELECT MIN( ROWNUM ) MIN_ROWNUM
, ELEMENT_TYPE_ID
, BATCH_LINE_ID
FROM ( SELECT ET.ELEMENT_TYPE_ID
, IV.NAME
, BL.BATCH_LINE_ID
FROM PAY_ELEMENT_TYPES_F ET
, PAY_INPUT_VALUES_F IV
, PAY_BATCH_LINES BL
, PAY_BATCH_HEADERS BH
, PER_BUSINESS_GROUPS BG
WHERE ET.ELEMENT_TYPE_ID = IV.ELEMENT_TYPE_ID
AND ( ((BL.ELEMENT_TYPE_ID IS NOT NULL)
AND ( ET.ELEMENT_TYPE_ID = BL.ELEMENT_TYPE_ID)) OR ((BL.ELEMENT_NAME IS NOT NULL)
AND ( ET.ELEMENT_NAME = BL.ELEMENT_NAME )) )
AND BH.BATCH_ID = BL.BATCH_ID
AND BG.BUSINESS_GROUP_ID = BH.BUSINESS_GROUP_ID
AND BL.EFFECTIVE_DATE BETWEEN IV.EFFECTIVE_START_DATE
AND IV.EFFECTIVE_END_DATE
AND BL.EFFECTIVE_DATE BETWEEN IV.EFFECTIVE_START_DATE
AND IV.EFFECTIVE_END_DATE
AND ( ( IV.BUSINESS_GROUP_ID IS NULL
AND IV.LEGISLATION_CODE = BG.LEGISLATION_CODE ) OR IV.BUSINESS_GROUP_ID = BH.BUSINESS_GROUP_ID )
AND BH.BATCH_NAME = 'BATCH '||TO_CHAR( BH.BATCH_ID ) ORDER BY BL.BATCH_LINE_ID
, ET.ELEMENT_TYPE_ID
, IV.DISPLAY_SEQUENCE
, IV.NAME ) GROUP BY ELEMENT_TYPE_ID
, BATCH_LINE_ID ) B
WHERE A.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID
AND A.BATCH_LINE_ID = B.BATCH_LINE_ID