APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on AHL_VWP_STAGES_B

Line 1658: FROM ahl_vwp_stages_b OldStage, ahl_vwp_stages_b NewStage

1654:
1655: -- To find the coresponding Stage id in the new visit
1656: CURSOR c_new_stage_id(c_old_stage_id IN NUMBER, c_new_visit_id IN NUMBER) IS
1657: SELECT NewStage.Stage_Id
1658: FROM ahl_vwp_stages_b OldStage, ahl_vwp_stages_b NewStage
1659: WHERE OldStage.Stage_Id = c_old_stage_id
1660: AND NewStage.visit_id = c_new_visit_id
1661: AND NewStage.Stage_Num = OldStage.Stage_Num;
1662:

Line 1922: SELECT Ahl_vwp_stages_B_S.NEXTVAL into l_stage_id

1918: AHL_DEBUG_PUB.debug( 'inside loop stage num:'||l_stage_rec.stage_num);
1919: END IF;
1920: -- Get visit task id
1921: /* Have to Confirm with the Stages API */
1922: SELECT Ahl_vwp_stages_B_S.NEXTVAL into l_stage_id
1923: FROM dual;
1924: --
1925: IF G_DEBUG='Y' THEN
1926: AHL_DEBUG_PUB.debug( 'visit call insert stage:'||l_stage_id);