APPS.AHL_ROUTE_APPROVAL_PVT dependencies on AHL_ROUTES_APP_V

Line 32: From ahl_routes_app_v

28: Select route_id,
29: route_no,
30: Start_date_active,
31: end_date_Active
32: From ahl_routes_app_v
33: Where route_id=c_route_id;
34:
35: l_route_rec GetRouteDet%rowtype;
36:

Line 262: from ahl_routes_app_v

258:
259: cursor GetRouteDet(c_route_id number)
260: is
261: select route_id,route_no,Start_date_active,end_date_Active
262: from ahl_routes_app_v
263: where route_id=c_route_id;
264:
265: l_route_rec GetRouteDet%rowtype;
266:

Line 379: from ahl_routes_app_v

375:
376: cursor GetRouteDet(c_route_id number)
377: is
378: select route_id,route_no,Start_date_active,end_date_active
379: from ahl_routes_app_v
380: where route_id=c_route_id;
381:
382: l_route_rec GetRouteDet%rowtype;
383:

Line 490: from ahl_routes_app_v

486:
487: cursor GetRouteDet(c_route_id number)
488: is
489: select route_id,route_no,Start_date_active,End_date_active
490: from ahl_routes_app_v
491: where route_id=c_route_id;
492:
493: l_route_rec GetRouteDet%rowtype;
494:

Line 607: from ahl_routes_app_v

603:
604: cursor GetRouteDet(c_route_id number)
605: is
606: select route_id,route_no,Start_date_active,end_date_active
607: from ahl_routes_app_v
608: where route_id=c_route_id;
609:
610: l_route_rec GetRouteDet%rowtype;
611: BEGIN

Line 724: from ahl_routes_app_v

720: l_error_msg VARCHAR2(2000);
721: cursor GetRouteDet(c_route_id number)
722: is
723: select route_id,route_no,Start_date_active,end_date_active
724: from ahl_routes_app_v
725: where route_id=c_route_id;
726:
727: l_route_rec GetRouteDet%rowtype;
728: BEGIN

Line 847: from ahl_routes_app_v

843:
844: cursor GetRouteDet(c_route_id number)
845: is
846: select route_id,route_no,Start_date_Active,end_date_active
847: from ahl_routes_app_v
848: where route_id=c_route_id;
849:
850: l_route_rec GetRouteDet%rowtype;
851: BEGIN

Line 973: from ahl_routes_app_v

969:
970: cursor GetRouteDet(c_route_id number)
971: is
972: select route_id,route_no,Start_date_active,end_date_active
973: from ahl_routes_app_v
974: where route_id=c_route_id;
975:
976: l_route_rec GetRouteDet%rowtype;
977: BEGIN

Line 1110: from ahl_routes_app_v

1106:
1107: cursor GetRouteDet(c_route_id number)
1108: is
1109: select route_id,route_no,Start_date_active,end_date_active,revision_status_code
1110: from ahl_routes_app_v
1111: where route_id=c_route_id;
1112: l_route_rec GetRouteDet%rowtype;
1113: BEGIN
1114: IF G_DEBUG='Y' THEN

Line 1288: from ahl_routes_app_v

1284: l_msg_data VARCHAR2(4000);
1285: cursor GetRouteDet(c_route_id number)
1286: is
1287: select route_id,route_no,Start_date_active,end_date_active,revision_status_code
1288: from ahl_routes_app_v
1289: where route_id=c_route_id;
1290: l_route_rec GetRouteDet%rowtype;
1291: l_return_status VARCHAR2(1);
1292: