DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT dependencies on CS_INCIDENTS

Line 178: FROM CS_INCIDENTS

174: -- NR MR ER - start
175: CURSOR c_get_sr_details(p_incident_id NUMBER)
176: IS
177: SELECT object_version_number
178: FROM CS_INCIDENTS
179: WHERE incident_id = p_incident_id;
180: -- NR MR ER - end
181:
182: -- FP for ER 5716489 -- start

Line 2576: FROM CS_INCIDENTS

2572:
2573: CURSOR c_get_sr_details(p_incident_id NUMBER)
2574: IS
2575: SELECT object_version_number
2576: FROM CS_INCIDENTS
2577: WHERE incident_id = p_incident_id;
2578:
2579: --STHILAK, PIE, cursor to fetch Service Type corresponding to the NR.
2580: CURSOR c_get_nr_service_type_code (ue_id NUMBER)