APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_CONTACT_POINTS

Line 1505: from hz_contact_points

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