DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 507: pay_personal_payment_methods_f ppp

503:
504: cursor get_per_org_account_no is
505: select pea.segment6
506: from pay_external_accounts pea,
507: pay_personal_payment_methods_f ppp
508: where
509: ppp.personal_payment_method_id=p_per_pay_method_id
510: and ppp.external_account_id=pea.external_account_id
511: and p_date_earned between ppp.effective_start_date and ppp.effective_end_date;

Line 747: pay_personal_payment_methods_f ppp

743:
744: cursor get_per_org_account_no is
745: select pea.segment6
746: from pay_external_accounts pea,
747: pay_personal_payment_methods_f ppp
748: where
749: ppp.personal_payment_method_id=p_per_pay_method_id
750: and ppp.external_account_id=pea.external_account_id
751: and p_date_earned between ppp.effective_start_date and ppp.effective_end_date;