APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_IMP_ADDRESSES_SG

Line 4444: hz_imp_addresses_sg addr_sg, hz_imp_batch_details bd

4440: ,ps.IDENTIFYING_ADDRESS_FLAG
4441: ,ps.STATUS
4442: ,l.ADDRESS1
4443: FROM hz_locations l, hz_party_sites ps,
4444: hz_imp_addresses_sg addr_sg, hz_imp_batch_details bd
4445: WHERE l.request_id = bd.main_conc_req_id
4446: AND bd.batch_id = addr_sg.batch_id
4447: AND l.location_id = ps.location_id
4448: AND addr_sg.batch_id = p_batch_id