DBA Data[Home] [Help]

APPS.AHL_VWP_TIMES_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 1445: FROM ahl_rt_oper_resources

1441: RETURN NUMBER IS
1442:
1443: CURSOR c_get_route_level_res_reqs (c_route_id IN NUMBER) IS
1444: SELECT COST_BASIS_ID, DURATION, RT_OPER_RESOURCE_ID
1445: FROM ahl_rt_oper_resources
1446: WHERE OBJECT_ID = c_route_id
1447: AND NVL(SCHEDULED_TYPE_ID,1) <> 2
1448: AND ASSOCIATION_TYPE_CODE = G_ASSOC_TYPE_ROUTE;
1449:

Line 1454: FROM ahl_rt_oper_resources

1450: get_route_level_res_reqs_rec c_get_route_level_res_reqs%ROWTYPE;
1451:
1452: CURSOR c_get_op_level_res_reqs (c_oprn_id IN NUMBER) IS
1453: SELECT COST_BASIS_ID, DURATION, RT_OPER_RESOURCE_ID
1454: FROM ahl_rt_oper_resources
1455: WHERE OBJECT_ID = c_oprn_id
1456: AND NVL(SCHEDULED_TYPE_ID,1) <> 2
1457: AND ASSOCIATION_TYPE_CODE = G_ASSOC_TYPE_OPERATION;
1458: