APPS.POS_SBD_IBY_PKG dependencies on IBY_EXT_BANK_ACCOUNTS

Line 805: l_temp_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;

801: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
802: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
803: l_msg_count number;
804: l_step number;
805: l_temp_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
806:
807: cursor l_party_id_cur is
808: select party_id from pos_supplier_mappings where mapping_id = p_mapping_id;
809: l_party_id number;

Line 921: IBY_EXT_BANK_ACCOUNTS

917: IF p_EXT_BANK_ACCOUNT_ID IS NOT NULL THEN
918:
919: SELECT BANK_ACCOUNT_NUM INTO l_temp_bank_account_num
920: FROM
921: IBY_EXT_BANK_ACCOUNTS
922: WHERE
923: EXT_BANK_ACCOUNT_ID=p_EXT_BANK_ACCOUNT_ID;
924:
925: l_ext_bank_acct_rec.bank_account_num := l_temp_bank_account_num;

Line 1027: iby_ext_bank_accounts act, ap_supplier_sites_all pvsa

1023:
1024: cursor l_max_p_cur is
1025: select max(uses.order_of_preference)
1026: from iby_pmt_instr_uses_all uses, iby_external_payees_all payee,
1027: iby_ext_bank_accounts act, ap_supplier_sites_all pvsa
1028: where uses.instrument_type = 'BANKACCOUNT'
1029: AND sysdate between NVL(act.start_date,sysdate) AND NVL(act.end_date,sysdate)
1030: and payee.ext_payee_id = uses.ext_pmt_party_id
1031: and payee.org_id = pvsa.org_id

Line 1247: l_temp_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;

1243:
1244: l_msg_count number;
1245: l_step number;
1246:
1247: l_temp_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
1248: l_record_type IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1249: l_end_date DATE;
1250: l_start_date DATE;
1251: l_count NUMBER;

Line 1297: from iby_ext_bank_accounts act, iby_account_owners ow

1293: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
1294:
1295: cursor l_cur_act_cur is
1296: select act.object_version_number, ow.account_owner_party_id
1297: from iby_ext_bank_accounts act, iby_account_owners ow
1298: where ow.ext_bank_account_id = act.ext_bank_account_id
1299: and act.ext_bank_account_id = l_ext_bank_account_id
1300: and ow.primary_flag = 'Y'
1301: and NVL(ow.end_date,SYSDATE+10)>SYSDATE

Line 1666: IBY_EXT_BANK_ACCOUNTS

1662: IF l_ext_bank_account_id IS NOT NULL THEN
1663:
1664: SELECT BANK_ACCOUNT_NUM INTO l_temp_bank_account_num
1665: FROM
1666: IBY_EXT_BANK_ACCOUNTS
1667: WHERE
1668: EXT_BANK_ACCOUNT_ID=l_ext_bank_account_id;
1669:
1670: l_ext_bank_acct_rec.bank_account_num := l_temp_bank_account_num;

Line 1843: select count(*) from iby_ext_bank_accounts act, iby_account_owners o, pos_supplier_mappings pmap

1839: AND ((pos.account_request_id <> p_account_request_id and p_account_request_id is not null and
1840: pos.account_request_id is not null) OR (p_account_request_id is null));
1841:
1842: cursor dup_cur_act_cur is
1843: select count(*) from iby_ext_bank_accounts act, iby_account_owners o, pos_supplier_mappings pmap
1844: where o.ext_bank_account_id = act.ext_bank_account_id
1845: and (
1846: (act.currency_code = p_currency_code
1847: and act.currency_code is not null and p_currency_code is not null) OR