DBA Data[Home] [Help]

APPS.AHL_VWP_TIMES_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 1355: FROM ahl_rt_oper_resources

1351: RETURN NUMBER IS
1352:
1353: CURSOR c_get_route_level_res_reqs (c_route_id IN NUMBER) IS
1354: SELECT COST_BASIS_ID, DURATION, RT_OPER_RESOURCE_ID
1355: FROM ahl_rt_oper_resources
1356: WHERE OBJECT_ID = c_route_id
1357: AND NVL(SCHEDULED_TYPE_ID,1) <> 2
1358: AND ASSOCIATION_TYPE_CODE = G_ASSOC_TYPE_ROUTE;
1359:

Line 1364: FROM ahl_rt_oper_resources

1360: get_route_level_res_reqs_rec c_get_route_level_res_reqs%ROWTYPE;
1361:
1362: CURSOR c_get_op_level_res_reqs (c_oprn_id IN NUMBER) IS
1363: SELECT COST_BASIS_ID, DURATION, RT_OPER_RESOURCE_ID
1364: FROM ahl_rt_oper_resources
1365: WHERE OBJECT_ID = c_oprn_id
1366: AND NVL(SCHEDULED_TYPE_ID,1) <> 2
1367: AND ASSOCIATION_TYPE_CODE = G_ASSOC_TYPE_OPERATION;
1368: