APPS.OKS_SETUP_UTIL_PUB dependencies on HZ_CONTACT_POINTS

Line 3799: FROM HZ_CONTACT_POINTS

3795: --And pt.party_id2 = hz.id2;
3796:
3797: Cursor email_csr(p_email_id IN Number) is
3798: SELECT lower(email_address)
3799: FROM HZ_CONTACT_POINTS
3800: WHERE contact_point_id = p_email_id;
3801:
3802: Cursor phone_csr(p_phone_id IN Number) is
3803: SELECT DECODE(PHONE_AREA_CODE,NULL,NULL,PHONE_AREA_CODE||'-')

Line 3805: FROM HZ_CONTACT_POINTS

3801:
3802: Cursor phone_csr(p_phone_id IN Number) is
3803: SELECT DECODE(PHONE_AREA_CODE,NULL,NULL,PHONE_AREA_CODE||'-')
3804: ||PHONE_NUMBER phone_number
3805: FROM HZ_CONTACT_POINTS
3806: WHERE contact_point_id = p_phone_id;
3807:
3808: Cursor fax_csr(p_fax_id IN Number) is
3809: SELECT DECODE(PHONE_AREA_CODE, NULL,NULL,PHONE_AREA_CODE||'-')

Line 3811: FROM HZ_CONTACT_POINTS

3807:
3808: Cursor fax_csr(p_fax_id IN Number) is
3809: SELECT DECODE(PHONE_AREA_CODE, NULL,NULL,PHONE_AREA_CODE||'-')
3810: ||PHONE_NUMBER phone_number
3811: FROM HZ_CONTACT_POINTS
3812: WHERE contact_point_id = p_fax_id;
3813:
3814: Cursor party_csr(p_contact_id IN Number) is
3815: SELECT b.party_name

Line 3943: from hz_contact_points

3939: -- Primary e-mail address
3940: cursor email_cur_new is
3941: select contact_point_id
3942: -- from okx_contact_points_v
3943: from hz_contact_points
3944: where contact_point_type = 'EMAIL'
3945: and primary_flag = 'Y'
3946: and owner_table_id = p_contact_id;
3947:

Line 3951: from hz_contact_points

3947:
3948: -- Primary telephone number
3949: cursor phone_cur_new is
3950: select contact_point_id
3951: from hz_contact_points
3952: where contact_point_type = 'PHONE'
3953: and NVL(phone_line_type,'GEN') = 'GEN'
3954: and primary_flag = 'Y'
3955: and owner_table_id = p_contact_id;

Line 3960: from hz_contact_points

3956:
3957: -- Any one fax number
3958: cursor fax_cur_new is
3959: select contact_point_id
3960: from hz_contact_points
3961: where contact_point_type = 'PHONE'
3962: and phone_line_type = 'FAX'
3963: and owner_table_id = p_contact_id;
3964: