APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_VWP_STAGES_B_S

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 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