APPS.POS_SBD_IBY_PKG dependencies on POS_SUPPLIER_MAPPINGS

Line 808: select party_id from pos_supplier_mappings where mapping_id = p_mapping_id;

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;
810:
811: l_need_validation varchar2(1);
812:

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