APPS.AHL_RM_OPERATION_PVT dependencies on AHL_OPERATIONS_V

Line 506: FROM AHL_OPERATIONS_V

502: attribute12,
503: attribute13,
504: attribute14,
505: attribute15
506: FROM AHL_OPERATIONS_V
507: WHERE operation_id = c_operation_id;
508:
509: BEGIN
510: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

508:
509: BEGIN
510: x_return_status := FND_API.G_RET_STS_SUCCESS;
511:
512: -- Get the old record from AHL_OPERATIONS_V.
513: OPEN get_old_rec( p_operation_id );
514:
515: FETCH get_old_rec INTO
516: x_operation_rec.object_version_number,

Line 1159: FROM ahl_operations_v

1155: l_start_date DATE;
1156:
1157: CURSOR check_previous_start_date(c_concatenated_segments VARCHAR2, c_revision_number NUMBER) IS
1158: SELECT start_date_active
1159: FROM ahl_operations_v
1160: WHERE concatenated_segments = c_concatenated_segments
1161: AND revision_number = c_revision_number - 1;
1162: /*
1163: CURSOR get_dup_rec( c_segment1 VARCHAR2, c_segment2 VARCHAR2, c_segment3 VARCHAR2,

Line 2015: FROM AHL_OPERATIONS_V

2011:
2012: CURSOR get_latest_revision( c_concatenated_segments VARCHAR2 )
2013: IS
2014: SELECT MAX( revision_number )
2015: FROM AHL_OPERATIONS_V
2016: WHERE concatenated_segments = c_concatenated_segments;
2017:
2018: CURSOR get_doc_associations( c_operation_id NUMBER )
2019: IS