APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_CONTACT_POINTS

Line 1502: from hz_contact_points

1498: CURSOR c_contact_details(lc_cntct_prtyId number) IS
1499: select contact_point_type, primary_flag,phone_line_type,
1500: IBE_UTIL.format_phone(phone_country_code,phone_area_code,phone_number,phone_extension)phone_number,
1501: email_address
1502: from hz_contact_points
1503: where contact_point_type in ('PHONE','EMAIL') and
1504: NVL(status, 'A') = 'A' and owner_table_name = 'HZ_PARTIES'
1505: and owner_table_id = lc_cntct_prtyId
1506: and primary_flag='Y';