View: PAY_JP_MAGTAPE_PAYMENTS_V

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

View Text

SELECT V.PAYROLL_ACTION_ID
, PEA.SEGMENT1
, V.EXTERNAL_ACCOUNT_ID
, V.PERSON_ID
, DECODE(GROUPING(V.PERSON_ID)
, 0
, MIN(V.MIN_EFFECTIVE_DATE)
, NULL)
, COUNT(*)
, SUM(V.PAYMENT) FROM PAY_EXTERNAL_ACCOUNTS PEA
, ( SELECT PPA.PAYROLL_ACTION_ID
, PPM.EXTERNAL_ACCOUNT_ID
, PA.PERSON_ID
, MIN(PPA2.EFFECTIVE_DATE) MIN_EFFECTIVE_DATE
, SUM(PPP.VALUE) PAYMENT FROM PER_ALL_ASSIGNMENTS_F PA
, PAY_PERSONAL_PAYMENT_METHODS_F PPM
, PAY_PAYROLL_ACTIONS PPA2
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_PRE_PAYMENTS PPP
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA WHERE PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PPP.PRE_PAYMENT_ID = PAA.PRE_PAYMENT_ID AND PAA2.ASSIGNMENT_ACTION_ID = PPP.ASSIGNMENT_ACTION_ID AND PPA2.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID AND PPM.PERSONAL_PAYMENT_METHOD_ID = PPP.PERSONAL_PAYMENT_METHOD_ID AND PPA2.EFFECTIVE_DATE BETWEEN PPM.EFFECTIVE_START_DATE
AND PPM.EFFECTIVE_END_DATE AND PA.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID AND PPA.EFFECTIVE_DATE BETWEEN PA.EFFECTIVE_START_DATE
AND PA.EFFECTIVE_END_DATE GROUP BY PPA.PAYROLL_ACTION_ID
, PA.PERSON_ID
, PPM.EXTERNAL_ACCOUNT_ID HAVING SUM(PPP.VALUE) > 0 ) V WHERE PEA.EXTERNAL_ACCOUNT_ID = V.EXTERNAL_ACCOUNT_ID GROUP BY V.PAYROLL_ACTION_ID
, ROLLUP(PEA.SEGMENT1
, V.EXTERNAL_ACCOUNT_ID
, V.PERSON_ID) HAVING NOT (GROUPING(V.EXTERNAL_ACCOUNT_ID) + GROUPING(V.PERSON_ID) = 1)

Columns