DBA Data[Home] [Help]

APPS.POS_SBD_PKG dependencies on IBY_EXT_BANK_ACCOUNTS

Line 1870: iby_ext_bank_accounts act, pos_supplier_mappings pmap

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

Line 1893: iby_ext_bank_accounts act, pos_supplier_mappings pmap

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

Line 1925: iby_ext_bank_accounts act, pos_supplier_mappings pmap, pos_acnt_gen_req req

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