DBA Data[Home] [Help]

APPS.ASO_PAYMENT_INT dependencies on IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 267: from iby_fndcpt_payer_assgn_instr_v

263: l_payment_ref_number varchar2(240);
264:
265: Cursor c_get_payer_id ( p_assignment_id NUMBER) is
266: select party_id
267: from iby_fndcpt_payer_assgn_instr_v
268: where instr_assignment_id = p_assignment_id;
269:
270: Cursor c_get_payment_id is
271: SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;

Line 697: from iby_fndcpt_payer_assgn_instr_v

693:
694:
695: Cursor c_get_payer_id ( p_assignment_id NUMBER) is
696: select party_id
697: from iby_fndcpt_payer_assgn_instr_v
698: where instr_assignment_id = p_assignment_id;
699:
700: /*** Commented this for Bug 9751000 ***/
701: /*

Line 704: from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b

700: /*** Commented this for Bug 9751000 ***/
701: /*
702: Cursor c_get_payer_from_trxn(p_trxn_extension_id number) is
703: select a.party_id
704: from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b
705: where a.instr_assignment_id = b.instr_assignment_id
706: and b.trxn_extension_id = p_trxn_extension_id;
707: */
708:

Line 1601: from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b

1597:
1598:
1599: Cursor c_get_payer_from_trxn(p_trxn_extension_id number) is
1600: select a.party_id
1601: from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b
1602: where a.instr_assignment_id = b.instr_assignment_id
1603: and b.trxn_extension_id = p_trxn_extension_id;
1604:
1605: Begin