VIEW: APPS.PAY_AC_EMP_EARN_ACTION_INFO_V

Source

View Text - Preformatted

SELECT PAI.ACTION_CONTEXT_ID, PAI.TAX_UNIT_ID, PAI.EFFECTIVE_DATE, PAI.ACTION_INFORMATION1 ELEMENT_CLASSIFICATION, PAI.ACTION_INFORMATION2 ELEMENT_TYPE_ID, PAI.ACTION_INFORMATION10 REPORTING_NAME, PAI.ACTION_INFORMATION6 PRIMARY_BALANCE, PAI.ACTION_INFORMATION7 PROCESSING_PRIORITY, FND_NUMBER.CANONICAL_TO_NUMBER (PAI.ACTION_INFORMATION13) RATE, FND_NUMBER.CANONICAL_TO_NUMBER (PAI.ACTION_INFORMATION22) RATE_MUL, to_number(DECODE(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION11)), 0, NULL, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION11)))) CURRENT_HOURS, SUM(FND_NUMBER.CANONICAL_TO_NUMBER (PAI.ACTION_INFORMATION8)) CURRENT_AMOUNT, to_number(DECODE(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION12)), 0, NULL, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION12)))) YTD_HOURS, SUM(FND_NUMBER.CANONICAL_TO_NUMBER (PAI.ACTION_INFORMATION9)) YTD_AMOUNT, fnd_date.canonical_to_date(PAI.ACTION_INFORMATION17) DATE_EARNED, fnd_date.canonical_to_date(PAI.ACTION_INFORMATION18) START_DATE, fnd_date.canonical_to_date(PAI.ACTION_INFORMATION19) END_DATE, PAI.ACTION_INFORMATION20 ELEMENT_CATEGORY, PAI.ACTION_INFORMATION21 JURISDICTION_CODE FROM PAY_ACTION_INFORMATION PAI , PER_ASSIGNMENTS_F PAF WHERE PAI.ACTION_CONTEXT_TYPE = 'AAP' AND PAI.ACTION_INFORMATION_CATEGORY = 'AC EARNINGS' AND (PAI.ACTION_INFORMATION9 <> '0' OR PAI.ACTION_INFORMATION8 <> '0' ) AND PAF.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID AND PAI.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE GROUP BY PAF.BUSINESS_GROUP_ID, PAI.ACTION_CONTEXT_ID, PAI.TAX_UNIT_ID, PAI.EFFECTIVE_DATE, PAI.ACTION_INFORMATION1, PAI.ACTION_INFORMATION7, PAI.ACTION_INFORMATION2, PAI.ACTION_INFORMATION6, PAI.ACTION_INFORMATION10, PAI.ACTION_INFORMATION13, PAI.ACTION_INFORMATION22, PAI.ACTION_INFORMATION17, PAI.ACTION_INFORMATION18, PAI.ACTION_INFORMATION19, PAI.ACTION_INFORMATION20, PAI.ACTION_INFORMATION21

View Text - HTML Formatted

SELECT PAI.ACTION_CONTEXT_ID
, PAI.TAX_UNIT_ID
, PAI.EFFECTIVE_DATE
, PAI.ACTION_INFORMATION1 ELEMENT_CLASSIFICATION
, PAI.ACTION_INFORMATION2 ELEMENT_TYPE_ID
, PAI.ACTION_INFORMATION10 REPORTING_NAME
, PAI.ACTION_INFORMATION6 PRIMARY_BALANCE
, PAI.ACTION_INFORMATION7 PROCESSING_PRIORITY
, FND_NUMBER.CANONICAL_TO_NUMBER (PAI.ACTION_INFORMATION13) RATE
, FND_NUMBER.CANONICAL_TO_NUMBER (PAI.ACTION_INFORMATION22) RATE_MUL
, TO_NUMBER(DECODE(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION11))
, 0
, NULL
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION11)))) CURRENT_HOURS
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER (PAI.ACTION_INFORMATION8)) CURRENT_AMOUNT
, TO_NUMBER(DECODE(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION12))
, 0
, NULL
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION12)))) YTD_HOURS
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER (PAI.ACTION_INFORMATION9)) YTD_AMOUNT
, FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION17) DATE_EARNED
, FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION18) START_DATE
, FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION19) END_DATE
, PAI.ACTION_INFORMATION20 ELEMENT_CATEGORY
, PAI.ACTION_INFORMATION21 JURISDICTION_CODE
FROM PAY_ACTION_INFORMATION PAI
, PER_ASSIGNMENTS_F PAF
WHERE PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI.ACTION_INFORMATION_CATEGORY = 'AC EARNINGS'
AND (PAI.ACTION_INFORMATION9 <> '0' OR PAI.ACTION_INFORMATION8 <> '0' )
AND PAF.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID
AND PAI.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE GROUP BY PAF.BUSINESS_GROUP_ID
, PAI.ACTION_CONTEXT_ID
, PAI.TAX_UNIT_ID
, PAI.EFFECTIVE_DATE
, PAI.ACTION_INFORMATION1
, PAI.ACTION_INFORMATION7
, PAI.ACTION_INFORMATION2
, PAI.ACTION_INFORMATION6
, PAI.ACTION_INFORMATION10
, PAI.ACTION_INFORMATION13
, PAI.ACTION_INFORMATION22
, PAI.ACTION_INFORMATION17
, PAI.ACTION_INFORMATION18
, PAI.ACTION_INFORMATION19
, PAI.ACTION_INFORMATION20
, PAI.ACTION_INFORMATION21