DBA Data[Home] [Help]

APPS.CSM_SR_EVENT_PKG dependencies on CS_HZ_SR_CONTACT_POINTS

Line 312: FROM cs_hz_sr_contact_points

308: SELECT sr_contact_point_id,
309: contact_point_id,
310: contact_type,
311: party_id
312: FROM cs_hz_sr_contact_points
313: WHERE incident_id = p_incident_id
314: AND sr_contact_point_id = NVL(p_sr_contact_point_id, sr_contact_point_id);
315:
316: CURSOR l_emp_resource_csr (p_party_id hz_parties.party_id%TYPE)

Line 579: FROM cs_hz_sr_contact_points

575: SELECT sr_contact_point_id,
576: contact_point_id,
577: contact_type,
578: party_id
579: FROM cs_hz_sr_contact_points
580: WHERE incident_id = p_incident_id
581: AND sr_contact_point_id = NVL(p_sr_contact_point_id, sr_contact_point_id);
582:
583: CURSOR l_emp_resource_csr (p_party_id hz_parties.party_id%TYPE)