VIEW: APPS.PAY_HK_ASG_PAYMENT_METH_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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