View: PAY_AU_ASG_PAYMENTS_V

Product:	PAY - Payroll
Description:	Australian localisation view.
Implementation/DBA Data:	APPS.PAY_AU_ASG_PAYMENTS_V

View Text

SELECT PAC.ROWID ROW_ID
, PAC.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, POP.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD
, PEA.SEGMENT1 BANK
, PEA.SEGMENT2 BANK_ACCOUNT_NAME
, PEA.SEGMENT3 BANK_ACCOUNT
, PPP.VALUE PAYMENT_AMOUNT
FROM PAY_EXTERNAL_ACCOUNTS PEA
, PAY_PERSONAL_PAYMENT_METHODS_F PPM
, PAY_PRE_PAYMENTS PPP
, PAY_ASSIGNMENT_ACTIONS PAC
, PAY_PAYROLL_ACTIONS PPA
, PAY_ORG_PAYMENT_METHODS_F POP
, HR_LOOKUPS
WHERE PPA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('P'
, 'U')
AND PAC.ASSIGNMENT_ACTION_ID = PPP.ASSIGNMENT_ACTION_ID
AND POP.ORG_PAYMENT_METHOD_ID = PPM.ORG_PAYMENT_METHOD_ID
AND PPA.EFFECTIVE_DATE BETWEEN PPM.EFFECTIVE_START_DATE
AND PPM.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN POP.EFFECTIVE_START_DATE
AND POP.EFFECTIVE_END_DATE
AND PPM.PERSONAL_PAYMENT_METHOD_ID = PPP.PERSONAL_PAYMENT_METHOD_ID
AND PEA.EXTERNAL_ACCOUNT_ID (+) = PPM.EXTERNAL_ACCOUNT_ID
AND PEA.SEGMENT1 = HR_LOOKUPS.LOOKUP_CODE (+)
AND HR_LOOKUPS.LOOKUP_TYPE(+) = 'AU_BANK' UNION ALL SELECT PAC.ROWID ROW_ID
, PAC.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, POP.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD
, NULL BANK
, NULL BANK_ACCOUNT_NAME
, NULL BANK_ACCOUNT
, PPP.VALUE PAYMENT_AMOUNT
FROM PAY_PRE_PAYMENTS PPP
, PAY_ASSIGNMENT_ACTIONS PAC
, PAY_PAYROLL_ACTIONS PPA
, PAY_ORG_PAYMENT_METHODS_F POP
WHERE PPA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('P'
, 'U')
AND PPA.EFFECTIVE_DATE BETWEEN POP.EFFECTIVE_START_DATE
AND POP.EFFECTIVE_END_DATE
AND PAC.ASSIGNMENT_ACTION_ID = PPP.ASSIGNMENT_ACTION_ID
AND POP.ORG_PAYMENT_METHOD_ID = PPP.ORG_PAYMENT_METHOD_ID
AND PPP.PERSONAL_PAYMENT_METHOD_ID IS NULL

Columns