APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_OPERATIONS_B_KFV

Line 11: p_concatenated_segments IN AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE,

7: PROCEDURE validate_operation
8: (
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_concatenated_segments IN AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE,
12: p_x_operation_id IN OUT NOCOPY AHL_OPERATIONS_B.operation_id%TYPE
13: )
14: IS
15:

Line 18: CURSOR get_rec_from_value ( c_concatenated_segments AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE )

14: IS
15:
16: l_operation_id AHL_OPERATIONS_B.operation_id%TYPE;
17:
18: CURSOR get_rec_from_value ( c_concatenated_segments AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE )
19: IS
20: SELECT DISTINCT operation_id
21: FROM AHL_OPERATIONS_B_KFV
22: WHERE concatenated_segments = c_concatenated_segments;

Line 21: FROM AHL_OPERATIONS_B_KFV

17:
18: CURSOR get_rec_from_value ( c_concatenated_segments AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE )
19: IS
20: SELECT DISTINCT operation_id
21: FROM AHL_OPERATIONS_B_KFV
22: WHERE concatenated_segments = c_concatenated_segments;
23:
24: CURSOR get_rec_from_id ( c_operation_id AHL_OPERATIONS_B.operation_id%TYPE )
25: IS

Line 3803: FROM AHL_OPERATIONS_B_KFV A, AHL_OPERATIONS_B_KFV B

3799:
3800: CURSOR get_op_latest_start_date( c_operation_id NUMBER )
3801: IS
3802: SELECT MAX( A.start_date_active )
3803: FROM AHL_OPERATIONS_B_KFV A, AHL_OPERATIONS_B_KFV B
3804: WHERE A.concatenated_segments = B.concatenated_segments
3805: AND A.operation_id <> c_operation_id
3806: AND B.operation_id = c_operation_id;
3807: