APPS.AHL_UMP_NONROUTINES_PVT dependencies on CS_SR_CONTACT_POINTS_V

Line 3383: from cs_sr_contact_points_v

3379: -- get primary contact if exists.
3380: cursor prim_contact_csr (p_cs_incident_id IN NUMBER)
3381: is
3382: select party_id, contact_type
3383: from cs_sr_contact_points_v
3384: where incident_id = p_cs_incident_id
3385: and primary_flag = 'Y';
3386:
3387: -- get ue details for SR created.