APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on DUAL

Line 2304: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_number FROM DUAL;

2300:
2301: END IF;
2302:
2303: -- get a snapshot number for ahl_snapshot_number_s for the whole set
2304: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_number FROM DUAL;
2305:
2306: FOR other_tasks_rec IN other_tasks_snapshot_csr(p_visit_id) LOOP
2307:
2308: IF(other_tasks_rec.actual_price IS NULL OR other_tasks_rec.estimated_price IS NULL)THEN

Line 2328: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_id FROM DUAL;

2324:
2325: ELSE
2326:
2327: --get sequence
2328: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_id FROM DUAL;
2329:
2330: -- take snapshot now
2331: AHL_SNAPSHOTS_PKG.INSERT_ROW
2332: (

Line 2580: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_number FROM DUAL;

2576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2577: END IF;
2578:
2579: -- get a snapshot number for ahl_snapshot_number_s for the whole set
2580: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_number FROM DUAL;
2581:
2582: -- call calculate workorder cost
2583: AHL_VWP_COST_PVT.Estimate_WO_Cost
2584: (

Line 2636: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_id FROM DUAL;

2632: EXIT;
2633: END IF;
2634:
2635: --get sequence
2636: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_id FROM DUAL;
2637:
2638: -- take snapshot now
2639: AHL_SNAPSHOTS_PKG.INSERT_ROW
2640: (

Line 2703: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_id FROM DUAL;

2699: EXIT;
2700: END IF;
2701:
2702: --get sequence
2703: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_id FROM DUAL;
2704:
2705: -- take snapshot now
2706: AHL_SNAPSHOTS_PKG.INSERT_ROW
2707: (