APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_IMP_CONTACTPTS_SG

Line 4535: FROM hz_contact_points cp, hz_imp_contactpts_sg cps, hz_imp_batch_details bd

4531: ,translate(phone_country_code|| ' ' || phone_area_code||' ' || phone_number,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz!"#$%&()''*+,-./:;<=>?@[\]^_`{|}~ ','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
4532: ,cp.PHONE_LINE_TYPE
4533: ,cp.STATUS
4534: ,cp.CONTACT_POINT_PURPOSE
4535: FROM hz_contact_points cp, hz_imp_contactpts_sg cps, hz_imp_batch_details bd
4536: WHERE cp.request_id = bd.main_conc_req_id
4537: AND bd.batch_id = cps.batch_id
4538: AND cp.contact_point_id = cps.contact_point_id
4539: AND cps.batch_id = p_batch_id