DBA Data[Home] [Help]

APPS.CSF_ACCESS_PKG dependencies on CS_HZ_SR_CONTACT_POINTS

Line 429: FROM cs_hz_sr_contact_points contact

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

Line 1495: FROM cs_hz_sr_contact_points contact

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