APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_VWP_STAGES_B

Line 595: and STAGE_ID IN (SELECT STAGE_ID FROM AHL_VWP_STAGES_B WHERE stage_num > C_STAGE_NUM

591: select 'x' from ahl_workorders_v
592: where visit_task_id in
593: (select DISTINCT VISIT_TASK_ID from AHL_VISIT_TASKS_B
594: where visit_id = C_VISIT_ID
595: and STAGE_ID IN (SELECT STAGE_ID FROM AHL_VWP_STAGES_B WHERE stage_num > C_STAGE_NUM
596: AND VISIT_ID = C_VISIT_ID))
597: and ( job_status_code =3 or firm_planned_flag = 1 );
598: */
599:

Line 940: in (select stage_id from ahl_vwp_stages_b

936: -- directly delete as we need to delete all stages for the visit
937:
938: delete from AHL_VWP_STAGES_TL
939: where stage_id
940: in (select stage_id from ahl_vwp_stages_b
941: where visit_id = p_visit_id);
942:
943: delete from AHL_VWP_STAGES_B
944: where visit_id = p_visit_id;

Line 943: delete from AHL_VWP_STAGES_B

939: where stage_id
940: in (select stage_id from ahl_vwp_stages_b
941: where visit_id = p_visit_id);
942:
943: delete from AHL_VWP_STAGES_B
944: where visit_id = p_visit_id;
945:
946: -- directly delete as we need to delete all stages for the visit
947:

Line 1190: SELECT Ahl_vwp_stages_B_S.NEXTVAL

1186: IS
1187:
1188: -- To find the next id value from visit sequence
1189: CURSOR c_seq IS
1190: SELECT Ahl_vwp_stages_B_S.NEXTVAL
1191: FROM dual;
1192:
1193: -- To find whether id already exists
1194: CURSOR c_id_exists (x_id IN NUMBER) IS

Line 1196: FROM Ahl_vwp_stages_b

1192:
1193: -- To find whether id already exists
1194: CURSOR c_id_exists (x_id IN NUMBER) IS
1195: SELECT 1
1196: FROM Ahl_vwp_stages_b
1197: WHERE stage_id = x_id;
1198:
1199: x_stage_Id NUMBER;
1200: l_dummy NUMBER;

Line 1267: ahl_vwp_stages_b s,

1263: FROM
1264: ( SELECT
1265: nvl(max(stage_num),1) max_parent_stage_num
1266: FROM
1267: ahl_vwp_stages_b s,
1268: AHL_VISIT_TASKS_b t
1269: WHERE
1270: s.stage_id = t.stage_id and
1271: t.VISIT_task_id IN

Line 1276: ahl_vwp_stages_b s,

1272: ( SELECT PARENT_TASK_ID FROM AHL_TASK_LINKS WHERE VISIT_TASK_ID = P_VISIT_TASK_ID )) ,
1273: ( SELECT
1274: nvl(min(stage_num),l_max_stage_num) min_child_stage_num
1275: FROM
1276: ahl_vwp_stages_b s,
1277: AHL_VISIT_TASKS_b t
1278: WHERE
1279: s.stage_id = t.stage_id and
1280: t.VISIT_task_id IN