APPS.POS_SBD_IBY_PKG dependencies on POS_SUPPLIER_MAPPINGS

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

803: l_msg_count number;
804: l_step number;
805:
806: cursor l_party_id_cur is
807: select party_id from pos_supplier_mappings where mapping_id = p_mapping_id;
808: l_party_id number;
809:
810: l_need_validation varchar2(1);
811:

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

1804: AND ((pos.account_request_id <> p_account_request_id and p_account_request_id is not null and
1805: pos.account_request_id is not null) OR (p_account_request_id is null));
1806:
1807: cursor dup_cur_act_cur is
1808: select count(*) from iby_ext_bank_accounts act, iby_account_owners o, pos_supplier_mappings pmap
1809: where o.ext_bank_account_id = act.ext_bank_account_id
1810: and (
1811: (act.currency_code = p_currency_code
1812: and act.currency_code is not null and p_currency_code is not null) OR