DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 8963: pay_org_payment_methods_f popf,

8959: IS
8960: SELECT 'Y'
8961: FROM pay_pre_payments ppp,
8962: pay_payment_types ppt,
8963: pay_org_payment_methods_f popf,
8964: pay_personal_payment_methods_f pppf,
8965: pay_external_accounts Orgkey,
8966: pay_external_accounts deskey,
8967: PAY_ASSIGNMENT_ACTIONS PAA,

Line 8987: pay_org_payment_methods_f popmf,

8983: CURSOR csr_total_payment (c_prepay_asg_action_id NUMBER)
8984: IS
8985: select (sum(ppp.value) * 100) amount
8986: from pay_pre_payments ppp,
8987: pay_org_payment_methods_f popmf,
8988: pay_assignment_actions paa,
8989: pay_payroll_actions ppa
8990: where ppp.ASSIGNMENT_ACTION_ID = c_prepay_asg_action_id
8991: and popmf.ORG_PAYMENT_METHOD_ID = ppp.ORG_PAYMENT_METHOD_ID