APPS.CSC_SERVICE_KEY_PVT dependencies on CS_HZ_SR_CONTACT_POINTS

Line 37: FROM cs_hz_sr_contact_points

33:
34: -- Querying Contact Information using Incident Id
35: CURSOR SR_Contact_Cur IS
36: SELECT party_id, contact_point_id, contact_point_type, contact_type
37: FROM cs_hz_sr_contact_points
38: WHERE primary_flag = 'Y' AND
39: --contact_type <> 'EMPLOYEE' AND
40: incident_id = l_incident_id;
41:

Line 45: FROM cs_hz_sr_contact_points

41:
42: -- Querying secondary contact point for a contact
43: CURSOR SR_sec_cont_pt_cur IS
44: SELECT contact_point_id, contact_point_type
45: FROM cs_hz_sr_contact_points
46: WHERE incident_id = l_incident_id AND
47: party_id = l_party_id AND
48: contact_point_type = l_contact_point_type AND
49: rownum < 2;