APPS.AHL_FMP_PVT dependencies on AHL_MC_PATH_POSITIONS

Line 1563: FROM ahl_mr_headers_app_v MR, ahl_mc_path_positions mcp,

1559: --cir.object_id,
1560: cir.subject_id,
1561: --cir.position_reference,
1562: cir.depth
1563: FROM ahl_mr_headers_app_v MR, ahl_mc_path_positions mcp,
1564: --ahl_mc_headers_b hdr, ahl_mc_relationships rel,
1565: cir, ahl_mr_effectivities A
1566: WHERE A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1567: AND MR.mr_header_id = A.mr_header_id

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

1901: --cir.object_id,
1902: cir.subject_id,
1903: --cir.position_reference,
1904: cir.depth
1905: FROM ahl_mr_headers_app_v MR, ahl_mr_visit_types vis, ahl_mc_path_positions mcp,
1906: --ahl_mc_headers_b hdr, ahl_mc_relationships rel,
1907: cir, ahl_mr_effectivities A
1908: WHERE MR.mr_header_id = A.mr_header_id
1909: AND A.mr_header_id = vis.mr_header_id

Line 3259: l_inst_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;

3255: l_return_status VARCHAR2(1);
3256: l_msg_count NUMBER;
3257: l_msg_data VARCHAR2(2000);
3258: l_inst_path_pos_id NUMBER;
3259: l_inst_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
3260: l_input_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
3261: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
3262: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
3263: l_unit_csi_id NUMBER;

Line 3260: l_input_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;

3256: l_msg_count NUMBER;
3257: l_msg_data VARCHAR2(2000);
3258: l_inst_path_pos_id NUMBER;
3259: l_inst_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
3260: l_input_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
3261: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
3262: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
3263: l_unit_csi_id NUMBER;
3264: l_index NUMBER;

Line 3320: FROM AHL_MC_PATH_POSITIONS

3316: AND TRUNC(nvl(CIR.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate));
3317:
3318: CURSOR get_encoded_path_csr(c_path_position_id IN NUMBER) IS
3319: SELECT ENCODED_PATH_POSITION
3320: FROM AHL_MC_PATH_POSITIONS
3321: WHERE PATH_POSITION_ID = c_path_position_id;
3322:
3323: BEGIN
3324: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN