APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on AHL_VWP_STAGES_B

Line 1674: FROM ahl_vwp_stages_b OldStage, ahl_vwp_stages_b NewStage

1670:
1671: -- To find the coresponding Stage id in the new visit
1672: CURSOR c_new_stage_id(c_old_stage_id IN NUMBER, c_new_visit_id IN NUMBER) IS
1673: SELECT NewStage.Stage_Id
1674: FROM ahl_vwp_stages_b OldStage, ahl_vwp_stages_b NewStage
1675: WHERE OldStage.Stage_Id = c_old_stage_id
1676: AND NewStage.visit_id = c_new_visit_id
1677: AND NewStage.Stage_Num = OldStage.Stage_Num;
1678:

Line 1948: SELECT Ahl_vwp_stages_B_S.NEXTVAL into l_stage_id

1944: AHL_DEBUG_PUB.debug( 'inside loop stage num:'||l_stage_rec.stage_num);
1945: END IF;
1946: -- Get visit task id
1947: /* Have to Confirm with the Stages API */
1948: SELECT Ahl_vwp_stages_B_S.NEXTVAL into l_stage_id
1949: FROM dual;
1950: --
1951: IF G_DEBUG='Y' THEN
1952: AHL_DEBUG_PUB.debug( 'visit call insert stage:'||l_stage_id);