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 587: FROM cs_hz_sr_contact_points

583: SELECT sr_contact_point_id,
584: contact_point_id,
585: contact_type,
586: party_id
587: FROM cs_hz_sr_contact_points
588: WHERE incident_id = p_incident_id
589: AND sr_contact_point_id = NVL(p_sr_contact_point_id, sr_contact_point_id);
590:
591: CURSOR l_emp_resource_csr (p_party_id hz_parties.party_id%TYPE)