APPS.PAY_FI_ARCHIVE_MTRA dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 356: Cursor csr_account_number ( csr_v_payment_method_id pay_org_payment_methods_f.org_payment_method_id%TYPE)

352: AND hoi2.ORG_INFORMATION_CONTEXT='FI_THIRD_PARTY_PAYMENT';
353:
354: rg_Tax_Office_Details csr_Tax_Office_Details%rowtype;
355:
356: Cursor csr_account_number ( csr_v_payment_method_id pay_org_payment_methods_f.org_payment_method_id%TYPE)
357: IS
358: SELECT b.segment3
359: FROM pay_org_payment_methods_f a , pay_external_accounts b
360: WHERE a.org_payment_method_id = csr_v_payment_method_id

Line 359: FROM pay_org_payment_methods_f a , pay_external_accounts b

355:
356: Cursor csr_account_number ( csr_v_payment_method_id pay_org_payment_methods_f.org_payment_method_id%TYPE)
357: IS
358: SELECT b.segment3
359: FROM pay_org_payment_methods_f a , pay_external_accounts b
360: WHERE a.org_payment_method_id = csr_v_payment_method_id
361: AND a.external_account_id = b.external_account_id
362: AND a.business_group_id=l_business_group_id
363: AND a.pmeth_information_category ='FI Third Party Payment';