APPS.POS_PARTY_MERGE_PKG dependencies on POS_ACNT_ADDR_REQ

Line 82: from pos_acnt_addr_req req, pos_supplier_mappings pmap, hz_party_sites hps

78:
79: UNION
80:
81: select 1
82: from pos_acnt_addr_req req, pos_supplier_mappings pmap, hz_party_sites hps
83: where req.request_status = 'PENDING'
84: and req.request_type = 'ADDRESS'
85: and req.mapping_id = pmap.mapping_id
86: and hps.party_site_id = req.party_site_id

Line 94: from pos_acnt_addr_req req, pos_supplier_mappings pmap

90:
91: UNION
92:
93: select 1
94: from pos_acnt_addr_req req, pos_supplier_mappings pmap
95: where req.request_status = 'PENDING'
96: and req.request_type = 'SUPPLIER'
97: and req.mapping_id = pmap.mapping_id
98: and req.party_site_id is null