DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 547: pay_org_payment_methods_f org

543: CURSOR c_get_acc_num
544: IS
545: Select ext.segment2 --Acc Num
546: From pay_external_accounts ext,
547: pay_org_payment_methods_f org
548: Where org.org_payment_method_id = p_org_payment_method_id
549: and p_effective_date between org.effective_start_date and org.effective_end_date
550: and org.external_account_id = ext.external_account_id;
551:

Line 561: From pay_org_payment_methods_f

557:
558: CURSOR c_get_org_bat_desc
559: IS
560: Select pmeth_information2
561: From pay_org_payment_methods_f
562: Where org_payment_method_id = p_org_payment_method_id
563: and p_effective_date between effective_start_date and effective_end_date;
564:
565: l_business_grp_id NUMBER;