Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_PDT_BATCH_LINES |
SELECT /* JOIN RESULT SET OF PREVIOUS VIEW TO HR_LOOKUPS. IN 4 CASES
, ** PAY_PDT_BATCH_LINES REQUIRES LOOKUP_CODE WHEREAS PAY_BATCH_LINES ** STORES MEANING. CONVERT 4 VARCHARS TO NUMBERS. COLUMN AMOUNT ** IS MAPPED TO THE FIRST NON-NULL VALUE
FROM 6 POSSIBLE INPUT ** VALUE NAMES. */ BL.BATCH_ID
, BL.LINE_ID
, BL.ASSIGNMENT_NUMBER
, BL.ADJUSTMENT_TYPE_CODE
, FND_NUMBER.CANONICAL_TO_NUMBER( NVL( BL.AMT_AMOUNT
, NVL( BL.AMT_PERCENTAGE
, NVL( BL.AMT_NET_AMOUNT
, NVL( BL.AMT_PAY_VALUE
, NVL( BL.AMT_REPLACE_AMT
, BL.AMT_ADDL_AMT ) ) ) ) ) ) AMOUNT
, BL.APPLY_THIS_PERIOD
, BL.COST_CENTER_CODE
, BL.ELEMENT_NAME
, BL.FROM_DATE
, FND_NUMBER.CANONICAL_TO_NUMBER( BL.HOURLY_RATE ) HOURLY_RATE
, FND_NUMBER.CANONICAL_TO_NUMBER( BL.HOURS_WORKED ) HOURS_WORKED
, H1.LOOKUP_CODE INC_ASC_BALANCE
, BL.LABOR_DIST_CODE
, BL.LINE_STATUS
, BL.LOCALITY_WORKED
, BL.NEW_SALARY
, BL.PAY_EFFECTIVE_DATE
, BL.PCNT_INCREASE
, BL.RATE_CODE
, FND_NUMBER.CANONICAL_TO_NUMBER( BL.RATE_MULTIPLE ) RATE_MULTIPLE
, BL.RATING_CODE
, H2.LOOKUP_CODE SEPARATE_CHECK_FLAG
, BL.SHIFT_TYPE
, BL.STATE_WORKED
, H3.LOOKUP_CODE TAX_SEPARATELY_FLAG
, BL.TO_DATE
, H4.LOOKUP_CODE VOL_DED_PROC_OVD
, BL.COST_ALLOCATION_KEYFLEX_ID
, BL.CONCATENATED_SEGMENTS
, 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
FROM PAY_PDT_BATCH_LINES_V3 BL
, HR_LOOKUPS H1
, HR_LOOKUPS H2
, HR_LOOKUPS H3
, HR_LOOKUPS H4
WHERE BL.INC_ASC_BALANCE = H1.MEANING(+)
AND H1.LOOKUP_TYPE(+) = 'YES_NO'
AND BL.SEPARATE_CHECK_FLAG = H2.MEANING(+)
AND H2.LOOKUP_TYPE(+) = 'YES_NO'
AND BL.TAX_SEPARATELY_FLAG = H3.MEANING(+)
AND H3.LOOKUP_TYPE(+) = 'YES_NO'
AND BL.VOL_DED_PROC_OVD = H4.MEANING(+)
AND H4.LOOKUP_TYPE(+) = 'US_DEDUCTION_PROCESSING'