APPS.JA_CN_COA_EXP_PKG dependencies on HZ_CONTACT_POINTS

Line 1672: FROM HZ_CONTACT_POINTS HCP

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