APPS.AHL_VWP_COST_PVT dependencies on AHL_OSP_ORDER_LINES

Line 701: SELECT * FROM AHL_OSP_ORDER_LINES

697:
698:
699: -- To find out if jobs is an internal job or an OSP job
700: CURSOR c_OSP_Job (x_id IN NUMBER) IS
701: SELECT * FROM AHL_OSP_ORDER_LINES
702: WHERE WORKORDER_ID = x_id;
703: c_OSP_Job_rec c_OSP_Job%ROWTYPE;
704:
705: BEGIN

Line 906: SELECT * FROM AHL_OSP_ORDER_LINES

902:
903:
904: -- To find out if jobs is an internal job or an OSP job
905: CURSOR c_OSP_Job (x_id IN NUMBER) IS
906: SELECT * FROM AHL_OSP_ORDER_LINES
907: WHERE WORKORDER_ID = x_id;
908: c_OSP_Job_rec c_OSP_Job%ROWTYPE;
909:
910: BEGIN

Line 1092: SELECT * FROM AHL_OSP_ORDER_LINES

1088: c_WO_tasks_rec c_WO_tasks%ROWTYPE;
1089:
1090: -- To find out if jobs is an internal job or an OSP job
1091: CURSOR c_OSP_Job (x_id IN NUMBER) IS
1092: SELECT * FROM AHL_OSP_ORDER_LINES
1093: WHERE WORKORDER_ID = x_id;
1094: c_OSP_Job_rec c_OSP_Job%ROWTYPE;
1095:
1096: -- To find out all tasks using the given task as cost parent

Line 1319: SELECT * FROM AHL_OSP_ORDER_LINES

1315: -- yazhou 27-Jun-2006 ends
1316:
1317: -- To find out if jobs is an internal job or an OSP job
1318: CURSOR c_OSP_Job (x_id IN NUMBER) IS
1319: SELECT * FROM AHL_OSP_ORDER_LINES
1320: WHERE WORKORDER_ID = x_id;
1321: c_OSP_Job_rec c_OSP_Job%ROWTYPE;
1322:
1323: BEGIN