APPS.AHL_FMP_PVT dependencies on AHL_MC_PATH_POSITIONS

Line 1303: FROM ahl_mr_headers_app_v MR, ahl_mc_path_positions mcp,

1299: --cir.object_id,
1300: cir.subject_id,
1301: --cir.position_reference,
1302: cir.depth
1303: FROM ahl_mr_headers_app_v MR, ahl_mc_path_positions mcp,
1304: --ahl_mc_headers_b hdr, ahl_mc_relationships rel,
1305: cir, ahl_mr_effectivities A
1306: WHERE A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1307: AND MR.mr_header_id = A.mr_header_id

Line 1515: FROM ahl_mr_headers_app_v MR, ahl_mr_visit_types vis, ahl_mc_path_positions mcp,

1511: --cir.object_id,
1512: cir.subject_id,
1513: --cir.position_reference,
1514: cir.depth
1515: FROM ahl_mr_headers_app_v MR, ahl_mr_visit_types vis, ahl_mc_path_positions mcp,
1516: --ahl_mc_headers_b hdr, ahl_mc_relationships rel,
1517: cir, ahl_mr_effectivities A
1518: WHERE MR.mr_header_id = A.mr_header_id
1519: AND A.mr_header_id = vis.mr_header_id

Line 2516: l_inst_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;

2512: l_return_status VARCHAR2(1);
2513: l_msg_count NUMBER;
2514: l_msg_data VARCHAR2(2000);
2515: l_inst_path_pos_id NUMBER;
2516: l_inst_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2517: l_input_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2518: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
2519: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
2520: l_unit_csi_id NUMBER;

Line 2517: l_input_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;

2513: l_msg_count NUMBER;
2514: l_msg_data VARCHAR2(2000);
2515: l_inst_path_pos_id NUMBER;
2516: l_inst_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2517: l_input_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2518: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
2519: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
2520: l_unit_csi_id NUMBER;
2521: l_index NUMBER;

Line 2577: FROM AHL_MC_PATH_POSITIONS

2573: AND TRUNC(nvl(CIR.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate));
2574:
2575: CURSOR get_encoded_path_csr(c_path_position_id IN NUMBER) IS
2576: SELECT ENCODED_PATH_POSITION
2577: FROM AHL_MC_PATH_POSITIONS
2578: WHERE PATH_POSITION_ID = c_path_position_id;
2579:
2580: BEGIN
2581: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN