APPS.AHL_RM_OPERATION_PVT dependencies on AHL_OPERATIONS_V

Line 529: FROM AHL_OPERATIONS_V

525: attribute12,
526: attribute13,
527: attribute14,
528: attribute15
529: FROM AHL_OPERATIONS_V
530: WHERE operation_id = c_operation_id;
531:
532: BEGIN
533: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 535: -- Get the old record from AHL_OPERATIONS_V.

531:
532: BEGIN
533: x_return_status := FND_API.G_RET_STS_SUCCESS;
534:
535: -- Get the old record from AHL_OPERATIONS_V.
536: OPEN get_old_rec( p_operation_id );
537:
538: FETCH get_old_rec INTO
539: x_operation_rec.object_version_number,

Line 1284: FROM ahl_operations_v

1280: l_start_date DATE;
1281:
1282: CURSOR check_previous_start_date(c_concatenated_segments VARCHAR2, c_revision_number NUMBER) IS
1283: SELECT start_date_active
1284: FROM ahl_operations_v
1285: WHERE concatenated_segments = c_concatenated_segments
1286: AND revision_number = c_revision_number - 1;
1287: /*
1288: CURSOR get_dup_rec( c_segment1 VARCHAR2, c_segment2 VARCHAR2, c_segment3 VARCHAR2,

Line 2219: FROM AHL_OPERATIONS_V

2215:
2216: CURSOR get_latest_revision( c_concatenated_segments VARCHAR2 )
2217: IS
2218: SELECT MAX( revision_number )
2219: FROM AHL_OPERATIONS_V
2220: WHERE concatenated_segments = c_concatenated_segments;
2221:
2222: CURSOR get_doc_associations( c_operation_id NUMBER )
2223: IS