APPS.AHL_VWP_COST_PVT dependencies on AHL_OSP_ORDER_LINES

Line 698: SELECT * FROM AHL_OSP_ORDER_LINES

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

Line 903: SELECT * FROM AHL_OSP_ORDER_LINES

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

Line 1089: SELECT * FROM AHL_OSP_ORDER_LINES

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

Line 1316: SELECT * FROM AHL_OSP_ORDER_LINES

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