DBA Data[Home] [Help]

APPS.POS_PARTY_MERGE_PKG dependencies on POS_ACNT_GEN_REQ

Line 72: from POS_ACNT_GEN_REQ req, IBY_TEMP_EXT_BANK_ACCTS temp, POS_SUPPLIER_MAPPINGS pmap

68:
69: CURSOR l_acnt_cur IS
70:
71: SELECT 1
72: from POS_ACNT_GEN_REQ req, IBY_TEMP_EXT_BANK_ACCTS temp, POS_SUPPLIER_MAPPINGS pmap
73: where req.mapping_id = pmap.mapping_id
74: and pmap.party_id = p_party_id
75: and temp.status in ('CORRECTED', 'NEW', 'IN_VERIFICATION', 'CHANGE_PENDING')
76: and req.temp_ext_bank_acct_id = temp.temp_ext_bank_acct_id