APPS.IBY_FIPAYMENTS_PKG dependencies on IBY_EXT_BANK_ACCOUNTS

Line 11: procedure checkInstrId(i_instrid in iby_ext_bank_accounts_v.ext_bank_account_id%TYPE)

7: * Purpose: raise exception if instrid doesn't exist
8: *
9: *
10: */
11: procedure checkInstrId(i_instrid in iby_ext_bank_accounts_v.ext_bank_account_id%TYPE)
12: is
13: l_instrid iby_ext_bank_accounts_v.ext_bank_account_id%TYPE;
14:
15: cursor c_bk(ci_instrid iby_ext_bank_accounts_v.ext_bank_account_id%TYPE)

Line 13: l_instrid iby_ext_bank_accounts_v.ext_bank_account_id%TYPE;

9: *
10: */
11: procedure checkInstrId(i_instrid in iby_ext_bank_accounts_v.ext_bank_account_id%TYPE)
12: is
13: l_instrid iby_ext_bank_accounts_v.ext_bank_account_id%TYPE;
14:
15: cursor c_bk(ci_instrid iby_ext_bank_accounts_v.ext_bank_account_id%TYPE)
16: is
17: SELECT ext_bank_account_id

Line 15: cursor c_bk(ci_instrid iby_ext_bank_accounts_v.ext_bank_account_id%TYPE)

11: procedure checkInstrId(i_instrid in iby_ext_bank_accounts_v.ext_bank_account_id%TYPE)
12: is
13: l_instrid iby_ext_bank_accounts_v.ext_bank_account_id%TYPE;
14:
15: cursor c_bk(ci_instrid iby_ext_bank_accounts_v.ext_bank_account_id%TYPE)
16: is
17: SELECT ext_bank_account_id
18: FROM iby_ext_bank_accounts
19: WHERE ext_bank_account_id = ci_instrid;

Line 18: FROM iby_ext_bank_accounts

14:
15: cursor c_bk(ci_instrid iby_ext_bank_accounts_v.ext_bank_account_id%TYPE)
16: is
17: SELECT ext_bank_account_id
18: FROM iby_ext_bank_accounts
19: WHERE ext_bank_account_id = ci_instrid;
20:
21: begin
22: if ( c_bk%isopen) then