DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 8329: pay_org_payment_methods_f popf,

8325: IS
8326: SELECT 'Y'
8327: FROM pay_pre_payments ppp,
8328: pay_payment_types ppt,
8329: pay_org_payment_methods_f popf,
8330: pay_personal_payment_methods_f pppf,
8331: pay_external_accounts Orgkey,
8332: pay_external_accounts deskey,
8333: PAY_ASSIGNMENT_ACTIONS PAA,

Line 8353: pay_org_payment_methods_f popmf,

8349: CURSOR csr_total_payment (c_prepay_asg_action_id NUMBER)
8350: IS
8351: select (sum(ppp.value) * 100) amount
8352: from pay_pre_payments ppp,
8353: pay_org_payment_methods_f popmf,
8354: pay_assignment_actions paa,
8355: pay_payroll_actions ppa
8356: where ppp.ASSIGNMENT_ACTION_ID = c_prepay_asg_action_id
8357: and popmf.ORG_PAYMENT_METHOD_ID = ppp.ORG_PAYMENT_METHOD_ID