APPS.IBY_MERGE dependencies on IBY_EXTERNAL_PAYERS_ALL

Line 11: (account_id iby_external_payers_all.cust_account_id%TYPE,

7: process_mode VARCHAR2
8: );
9:
10: CURSOR CUR_GET_EXT_PAYER_ID
11: (account_id iby_external_payers_all.cust_account_id%TYPE,
12: account_site_use_id iby_external_payers_all.acct_site_use_id%TYPE ) IS
13: SELECT ext_payer_id
14: FROM iby_external_payers_all
15: WHERE cust_account_id = account_id

Line 12: account_site_use_id iby_external_payers_all.acct_site_use_id%TYPE ) IS

8: );
9:
10: CURSOR CUR_GET_EXT_PAYER_ID
11: (account_id iby_external_payers_all.cust_account_id%TYPE,
12: account_site_use_id iby_external_payers_all.acct_site_use_id%TYPE ) IS
13: SELECT ext_payer_id
14: FROM iby_external_payers_all
15: WHERE cust_account_id = account_id
16: AND NVL(acct_site_use_id,0) = NVL(account_site_use_id,0);

Line 14: FROM iby_external_payers_all

10: CURSOR CUR_GET_EXT_PAYER_ID
11: (account_id iby_external_payers_all.cust_account_id%TYPE,
12: account_site_use_id iby_external_payers_all.acct_site_use_id%TYPE ) IS
13: SELECT ext_payer_id
14: FROM iby_external_payers_all
15: WHERE cust_account_id = account_id
16: AND NVL(acct_site_use_id,0) = NVL(account_site_use_id,0);
17:
18: TYPE ext_payer_id_list_type IS TABLE OF

Line 19: iby_external_payers_all.ext_payer_id%TYPE

15: WHERE cust_account_id = account_id
16: AND NVL(acct_site_use_id,0) = NVL(account_site_use_id,0);
17:
18: TYPE ext_payer_id_list_type IS TABLE OF
19: iby_external_payers_all.ext_payer_id%TYPE
20: INDEX BY BINARY_INTEGER;
21:
22: END IBY_MERGE;