APPS.CS_PARTIES_PKG dependencies on HZ_CONTACT_POINTS

Line 15: hz_contact_points

11: decode(phone_country_code,null,null,phone_country_code||'-')||
12: decode(phone_area_code,null,'( )','('||phone_Area_code||')')||
13: phone_number||decode(phone_extension,null,null,' x'||phone_extension) phone_number
14: from
15: hz_contact_points
16: where owner_table_name = 'HZ_PARTIES' and
17: owner_table_id = p_party_id and
18: contact_point_type = 'PHONE' and
19: phone_line_type = p_telephone_type

Line 27: hz_contact_points

23: CURSOR cur_party_phone_count IS
24: select
25: count(*)
26: from
27: hz_contact_points
28: where owner_table_name = 'HZ_PARTIES' and
29: owner_table_id = p_party_id and
30: contact_point_type = 'PHONE' and
31: phone_line_type = p_telephone_type

Line 41: hz_contact_points

37: decode(phone_country_code,null,null,phone_country_code||'-')||
38: decode(phone_area_code,null,'( )','('||phone_Area_code||')')||
39: phone_number||decode(phone_extension,null,null,' x'||phone_extension) phone_number
40: from
41: hz_contact_points
42: where owner_table_name = 'HZ_PARTIES' and
43: owner_table_id = p_party_id and
44: contact_point_type = 'PHONE' and
45: phone_line_type = p_telephone_type and

Line 100: select email_Address from hz_contact_points

96: )
97: RETURN VARCHAR2 IS
98: l_email varchar2(50);
99: CURSOR cur_email IS
100: select email_Address from hz_contact_points
101: where
102: owner_table_name = 'HZ_PARTIES' and
103: owner_table_id = p_party_id and contact_point_type = 'EMAIL'
104:

Line 127: hz_contact_points

123: decode(phone_country_code,null,null,phone_country_code||'-')||
124: decode(phone_area_code,null,'( )','('||phone_Area_code||')')||phone_number||
125: decode(phone_extension,null,null,' x'||phone_extension) phone_number
126: from
127: hz_contact_points
128: where owner_table_name = 'HZ_PARTIES' and
129: owner_table_id = p_party_id and
130: contact_point_type = 'PHONE'
131: and phone_line_type = 'FAX'