APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 1415: FROM AHL_MC_PATH_POSITION_NODES

1411: x_pos_instance_id OUT NOCOPY NUMBER) IS
1412:
1413: CURSOR get_pos_path_dtls_csr IS
1414: SELECT position_key
1415: FROM AHL_MC_PATH_POSITION_NODES
1416: WHERE PATH_POSITION_ID = p_path_position_id AND
1417: SEQUENCE = (SELECT MAX(SEQUENCE) FROM AHL_MC_PATH_POSITION_NODES
1418: WHERE PATH_POSITION_ID = p_path_position_id);
1419:

Line 1417: SEQUENCE = (SELECT MAX(SEQUENCE) FROM AHL_MC_PATH_POSITION_NODES

1413: CURSOR get_pos_path_dtls_csr IS
1414: SELECT position_key
1415: FROM AHL_MC_PATH_POSITION_NODES
1416: WHERE PATH_POSITION_ID = p_path_position_id AND
1417: SEQUENCE = (SELECT MAX(SEQUENCE) FROM AHL_MC_PATH_POSITION_NODES
1418: WHERE PATH_POSITION_ID = p_path_position_id);
1419:
1420: CURSOR get_position_dtls_csr(c_pos_key IN NUMBER,
1421: c_mc_header_id IN NUMBER) IS

Line 1474: l_position_key AHL_MC_PATH_POSITION_NODES.POSITION_KEY%TYPE;

1470: l_installed_inst_id NUMBER;
1471: l_lowest_unit_inst_id NUMBER;
1472: l_lowest_mc_header_id NUMBER;
1473: l_mapping_status VARCHAR2(30);
1474: l_position_key AHL_MC_PATH_POSITION_NODES.POSITION_KEY%TYPE;
1475: l_last_instance_id NUMBER;
1476: l_requirement_date DATE := p_requirement_date;
1477:
1478: BEGIN