[Home] [Help]
View: PAY_HK_ASG_PAYMENT_METH_V
View Text
SELECT PAC.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, POP.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD
, HL.MEANING MEANING
, PEA.SEGMENT2 || DECODE(PEA.SEGMENT2
, NULL
, NULL
, '-') || PEA.SEGMENT3 BANK_ACCOUNT
, PEA.SEGMENT4 BANK_ACCOUNT_NAME
, POP.CURRENCY_CODE CURRENCY
, 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 HL
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 PPM.PERSONAL_PAYMENT_METHOD_ID = PPP.PERSONAL_PAYMENT_METHOD_ID
AND PEA.EXTERNAL_ACCOUNT_ID (+) = PPM.EXTERNAL_ACCOUNT_ID
AND PEA.SEGMENT1 = HL.LOOKUP_CODE (+)
AND HL.LOOKUP_TYPE(+) = 'HK_BANK' UNION SELECT PAC.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, POP.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD
, NULL MEANING
, NULL BANK_ACCOUNT
, NULL BANK_ACCOUNT_NAME
, POP.CURRENCY_CODE CURRENCY
, 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 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
Name |
ASSIGNMENT_ACTION_ID |
PAYMENT_METHOD |
MEANING |
BANK_ACCOUNT |
BANK_ACCOUNT_NAME |
CURRENCY |
PAYMENT_AMOUNT |