APPS.AHL_UMP_NONROUTINES_PVT dependencies on CS_SR_CONTACT_POINTS_V

Line 3225: from cs_sr_contact_points_v

3221: -- get primary contact if exists.
3222: cursor prim_contact_csr (p_cs_incident_id IN NUMBER)
3223: is
3224: select party_id, contact_type
3225: from cs_sr_contact_points_v
3226: where incident_id = p_cs_incident_id
3227: and primary_flag = 'Y';
3228:
3229: -- get ue details for SR created.