425: ( x_incident_id NUMBER
426: )
427: IS
428: SELECT party_id
429: FROM cs_hz_sr_contact_points contact
430: WHERE contact.incident_id = x_incident_id
431: AND contact.primary_flag = 'Y';
432:
433: CURSOR c_installed_at_party
1491: ( x_incident_id NUMBER
1492: )
1493: IS
1494: SELECT party_id
1495: FROM cs_hz_sr_contact_points contact
1496: WHERE contact.incident_id = x_incident_id
1497: AND contact.primary_flag = 'Y'
1498: AND EXISTS (SELECT incident_id
1499: FROM asg_incident_acc acc