APPS.ASO_PAYMENT_INT dependencies on IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 259: from iby_fndcpt_payer_assgn_instr_v

255: l_payment_ref_number varchar2(240);
256:
257: Cursor c_get_payer_id ( p_assignment_id NUMBER) is
258: select party_id
259: from iby_fndcpt_payer_assgn_instr_v
260: where instr_assignment_id = p_assignment_id;
261:
262: Cursor c_get_payment_id is
263: SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;

Line 685: from iby_fndcpt_payer_assgn_instr_v

681:
682:
683: Cursor c_get_payer_id ( p_assignment_id NUMBER) is
684: select party_id
685: from iby_fndcpt_payer_assgn_instr_v
686: where instr_assignment_id = p_assignment_id;
687:
688: Cursor c_get_payer_from_trxn(p_trxn_extension_id number) is
689: select a.party_id

Line 690: from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b

686: where instr_assignment_id = p_assignment_id;
687:
688: Cursor c_get_payer_from_trxn(p_trxn_extension_id number) is
689: select a.party_id
690: from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b
691: where a.instr_assignment_id = b.instr_assignment_id
692: and b.trxn_extension_id = p_trxn_extension_id;
693:
694: Begin

Line 1503: from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b

1499:
1500:
1501: Cursor c_get_payer_from_trxn(p_trxn_extension_id number) is
1502: select a.party_id
1503: from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b
1504: where a.instr_assignment_id = b.instr_assignment_id
1505: and b.trxn_extension_id = p_trxn_extension_id;
1506:
1507: Begin