View: PAY_KR_ASG_PAYMENTS_V

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

View Text

SELECT PPAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, POPM.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD_NAME
, HL.MEANING BANK
, PEA.SEGMENT3 ACCOUNT_NUMBER
, PPP.VALUE AMOUNT FROM PAY_PAYROLL_ACTIONS PPPA
, PAY_ASSIGNMENT_ACTIONS PPAA
, PAY_PRE_PAYMENTS PPP
, PAY_PERSONAL_PAYMENT_METHODS_F PPPM
, PAY_ORG_PAYMENT_METHODS_F POPM
, PAY_EXTERNAL_ACCOUNTS PEA
, HR_LOOKUPS HL
WHERE PPPA.PAYROLL_ACTION_ID = PPAA.PAYROLL_ACTION_ID AND PPPA.ACTION_TYPE IN ('P'
, 'U') AND PPPA.ACTION_STATUS = 'C' AND PPP.ASSIGNMENT_ACTION_ID = PPAA.ASSIGNMENT_ACTION_ID AND PPP.PERSONAL_PAYMENT_METHOD_ID = PPPM.PERSONAL_PAYMENT_METHOD_ID AND PPPM.ORG_PAYMENT_METHOD_ID = POPM.ORG_PAYMENT_METHOD_ID AND POPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID AND PEA.SEGMENT1 = HL.LOOKUP_CODE AND HL.LOOKUP_TYPE = 'KR_BANK' AND PPPA.EFFECTIVE_DATE BETWEEN PPPM.EFFECTIVE_START_DATE AND PPPM.EFFECTIVE_END_DATE
AND PPPM.EFFECTIVE_START_DATE >= POPM.EFFECTIVE_START_DATE
AND PPPM.EFFECTIVE_END_DATE <= POPM.EFFECTIVE_END_DATE UNION ALL SELECT PPAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, POPM.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD_NAME
, NULL BANK
, NULL ACCOUNT_NUMBER
, PPP.VALUE AMOUNT FROM PAY_PAYROLL_ACTIONS PPPA
, PAY_ASSIGNMENT_ACTIONS PPAA
, PAY_PRE_PAYMENTS PPP
, PAY_ORG_PAYMENT_METHODS_F POPM WHERE PPPA.PAYROLL_ACTION_ID = PPAA.PAYROLL_ACTION_ID AND PPPA.ACTION_TYPE IN ('P'
, 'U')
AND PPPA.ACTION_STATUS = 'C' AND PPP.ASSIGNMENT_ACTION_ID = PPAA.ASSIGNMENT_ACTION_ID AND PPP.PERSONAL_PAYMENT_METHOD_ID IS NULL AND PPP.ORG_PAYMENT_METHOD_ID = POPM.ORG_PAYMENT_METHOD_ID AND PPPA.EFFECTIVE_DATE BETWEEN POPM.EFFECTIVE_START_DATE AND POPM.EFFECTIVE_END_DATE

Columns