[Home] [Help]
387:
388: l_dup_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
389:
390: CURSOR l_party_id_cur is
391: select party_id, vendor_id from pos_supplier_mappings
392: where mapping_id = p_mapping_id;
393: l_vendor_id po_vendors.vendor_id%TYPE;
394:
395: l_itemtype wf_items.item_type%TYPE;
645: l_status iby_temp_ext_bank_accts.status%TYPE;
646: l_vendor_id po_vendors.vendor_id%TYPE;
647:
648: CURSOR l_party_id_cur is
649: select party_id, vendor_id from pos_supplier_mappings
650: where mapping_id = p_mapping_id;
651:
652: l_temp_ext_bank_account_id pos_acnt_gen_req.temp_ext_bank_acct_id%TYPE;
653: l_object_version_number pos_acnt_gen_req.object_version_number%TYPE;
1001:
1002: l_itemtype wf_items.item_type%TYPE;
1003: l_itemkey wf_items.item_key%TYPE;
1004: CURSOR l_vendor_cur is
1005: select vendor_id from pos_supplier_mappings where party_id = p_party_id;
1006: l_vendor_id po_vendors.vendor_id%TYPE;
1007:
1008: BEGIN
1009:
1246:
1247: l_itemtype wf_items.item_type%TYPE;
1248: l_itemkey wf_items.item_key%TYPE;
1249: CURSOR l_vendor_cur is
1250: select vendor_id from pos_supplier_mappings where party_id = p_party_id;
1251: l_vendor_id po_vendors.vendor_id%TYPE;
1252:
1253: BEGIN
1254:
1739: and rownum = 1
1740:
1741: UNION ALL
1742:
1743: select 1 from iby_pmt_instr_uses_all uses, iby_external_payees_all payee, pos_supplier_mappings pmap
1744: where uses.instrument_type = 'BANKACCOUNT'
1745: and payee.ext_payee_id = uses.ext_pmt_party_id
1746: and payee.org_id is null
1747: and payee.supplier_site_id is null
1866: cursor l_supplier_assign_cur is
1867:
1868: select uses.order_of_preference, uses.start_date, uses.end_date
1869: from iby_pmt_instr_uses_all uses, iby_external_payees_all payee,
1870: iby_ext_bank_accounts act, pos_supplier_mappings pmap
1871: where uses.instrument_type = 'BANKACCOUNT'
1872: and payee.ext_payee_id = uses.ext_pmt_party_id
1873: and payee.org_id is null
1874: and payee.supplier_site_id is null
1889: cursor l_address_assign_cur is
1890:
1891: select uses.order_of_preference, uses.start_date, uses.end_date
1892: from iby_pmt_instr_uses_all uses, iby_external_payees_all payee,
1893: iby_ext_bank_accounts act, pos_supplier_mappings pmap
1894: where uses.instrument_type = 'BANKACCOUNT'
1895: and payee.ext_payee_id = uses.ext_pmt_party_id
1896: and payee.org_id is null
1897: and payee.supplier_site_id is null
1921:
1922: cursor l_assign_iby_cur is
1923: select uses.order_of_preference, uses.start_date, uses.end_date, uses.instrument_id, req.account_request_id
1924: from iby_pmt_instr_uses_all uses, iby_external_payees_all payee,
1925: iby_ext_bank_accounts act, pos_supplier_mappings pmap, pos_acnt_gen_req req
1926: where uses.instrument_type = 'BANKACCOUNT'
1927: and payee.ext_payee_id = uses.ext_pmt_party_id
1928: and payee.org_id is null
1929: and ((payee.party_site_id = p_party_site_id
2232:
2233: cursor l_account_request_cur is
2234: select temp.status, req.object_version_number, req.temp_ext_bank_acct_id, pmap.vendor_id,
2235: temp.bank_account_num, temp.bank_name
2236: from pos_acnt_gen_req req, iby_temp_ext_bank_accts temp, pos_supplier_mappings pmap
2237: where req.account_request_id = p_account_request_id
2238: and temp.temp_ext_bank_acct_id = req.temp_ext_bank_acct_id
2239: and pmap.mapping_id = req.mapping_id;
2240: