APPS.CS_SR_STATUS_PROPAGATION_PKG dependencies on CSD_REPAIRS

Line 389: FROM csd_repairs

385: AND nvl(tasks.open_flag,'Y') = 'Y';
386:
387: CURSOR c_depot_orders IS
388: SELECT REPAIR_LINE_ID
389: FROM csd_repairs
390: WHERE incident_id = p_service_request_id;
391:
392: CURSOR c_eam_orders IS
393: SELECT wip_entity_id