DBA Data[Home] [Help]

APPS.AHL_COMPLEX_MX_PVT dependencies on CS_INCIDENTS_ALL_B

Line 578: CS_INCIDENTS_ALL_B nr

574:
575: CURSOR get_removal_nr_due_date(c_instance_id NUMBER) IS
576: SELECT NVL(ue.earliest_due_date,ue.due_date)
577: FROM ahl_unit_effectivities_b ue,
578: CS_INCIDENTS_ALL_B nr
579: WHERE ue.csi_item_instance_id =c_instance_id
580: AND ue.cs_incident_id =nr.incident_id
581: AND nr.incident_type_id =fnd_profile.value('AHL_REMOVAL_NON_ROUTINE') -- Removal NR type Id
582: AND ue.object_type ='SR'