APPS.JA_CN_COA_EXP_PKG dependencies on HZ_CONTACT_POINTS

Line 1674: FROM HZ_CONTACT_POINTS HCP

1670: || NVL(HCP.PHONE_AREA_CODE,'')
1671: || DECODE(NVL(HCP.PHONE_AREA_CODE,''),'','','-')
1672: || HCP.PHONE_NUMBER cust_phone
1673: BULK COLLECT INTO l_all_cust_phone
1674: FROM HZ_CONTACT_POINTS HCP
1675: ,HZ_PARTY_SITES HPS
1676: WHERE HCP.OWNER_TABLE_ID(+)=HPS.PARTY_SITE_ID
1677: AND HCP.OWNER_TABLE_NAME='HZ_PARTY_SITES'
1678: AND NVL(HCP.PRIMARY_FLAG,'')='Y'