APPS.CSI_PARTIES_PKG dependencies on HZ_CONTACT_POINTS

Line 16: hz_contact_points

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

Line 28: hz_contact_points

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

Line 42: hz_contact_points

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

Line 101: select email_Address from hz_contact_points

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

Line 128: hz_contact_points

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