APPS.OKS_SETUP_UTIL_PUB dependencies on HZ_CONTACT_POINTS

Line 3790: FROM HZ_CONTACT_POINTS

3786: --And pt.party_id2 = hz.id2;
3787:
3788: Cursor email_csr(p_email_id IN Number) is
3789: SELECT lower(email_address)
3790: FROM HZ_CONTACT_POINTS
3791: WHERE contact_point_id = p_email_id;
3792:
3793: Cursor phone_csr(p_phone_id IN Number) is
3794: SELECT DECODE(PHONE_AREA_CODE,NULL,NULL,PHONE_AREA_CODE||'-')

Line 3796: FROM HZ_CONTACT_POINTS

3792:
3793: Cursor phone_csr(p_phone_id IN Number) is
3794: SELECT DECODE(PHONE_AREA_CODE,NULL,NULL,PHONE_AREA_CODE||'-')
3795: ||PHONE_NUMBER phone_number
3796: FROM HZ_CONTACT_POINTS
3797: WHERE contact_point_id = p_phone_id;
3798:
3799: Cursor fax_csr(p_fax_id IN Number) is
3800: SELECT DECODE(PHONE_AREA_CODE, NULL,NULL,PHONE_AREA_CODE||'-')

Line 3802: FROM HZ_CONTACT_POINTS

3798:
3799: Cursor fax_csr(p_fax_id IN Number) is
3800: SELECT DECODE(PHONE_AREA_CODE, NULL,NULL,PHONE_AREA_CODE||'-')
3801: ||PHONE_NUMBER phone_number
3802: FROM HZ_CONTACT_POINTS
3803: WHERE contact_point_id = p_fax_id;
3804:
3805: Cursor party_csr(p_contact_id IN Number) is
3806: SELECT b.party_name

Line 3934: from hz_contact_points

3930: -- Primary e-mail address
3931: cursor email_cur_new is
3932: select contact_point_id
3933: -- from okx_contact_points_v
3934: from hz_contact_points
3935: where contact_point_type = 'EMAIL'
3936: and primary_flag = 'Y'
3937: and owner_table_id = p_contact_id;
3938:

Line 3942: from hz_contact_points

3938:
3939: -- Primary telephone number
3940: cursor phone_cur_new is
3941: select contact_point_id
3942: from hz_contact_points
3943: where contact_point_type = 'PHONE'
3944: and NVL(phone_line_type,'GEN') = 'GEN'
3945: and primary_flag = 'Y'
3946: and owner_table_id = p_contact_id;

Line 3951: from hz_contact_points

3947:
3948: -- Any one fax number
3949: cursor fax_cur_new is
3950: select contact_point_id
3951: from hz_contact_points
3952: where contact_point_type = 'PHONE'
3953: and phone_line_type = 'FAX'
3954: and owner_table_id = p_contact_id;
3955: