APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on DUAL

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

2219:
2220: END IF;
2221:
2222: -- get a snapshot number for ahl_snapshot_number_s for the whole set
2223: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_number FROM DUAL;
2224:
2225: FOR other_tasks_rec IN other_tasks_snapshot_csr(p_visit_id) LOOP
2226:
2227: IF(other_tasks_rec.actual_price IS NULL OR other_tasks_rec.estimated_price IS NULL)THEN

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

2243:
2244: ELSE
2245:
2246: --get sequence
2247: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_id FROM DUAL;
2248:
2249: -- take snapshot now
2250: AHL_SNAPSHOTS_PKG.INSERT_ROW
2251: (

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

2495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2496: END IF;
2497:
2498: -- get a snapshot number for ahl_snapshot_number_s for the whole set
2499: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_number FROM DUAL;
2500:
2501: -- call calculate workorder cost
2502: AHL_VWP_COST_PVT.Estimate_WO_Cost
2503: (

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

2551: EXIT;
2552: END IF;
2553:
2554: --get sequence
2555: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_id FROM DUAL;
2556:
2557: -- take snapshot now
2558: AHL_SNAPSHOTS_PKG.INSERT_ROW
2559: (

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

2618: EXIT;
2619: END IF;
2620:
2621: --get sequence
2622: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_id FROM DUAL;
2623:
2624: -- take snapshot now
2625: AHL_SNAPSHOTS_PKG.INSERT_ROW
2626: (