DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_UTIL_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 1910: FROM AHL_MC_RELATIONSHIPS rel, AHL_MC_HEADERS_B mc, AHL_MC_PATH_POSITION_NODES node

1906:
1907:
1908: CURSOR get_relnship_id_csr (p_path_position_id IN NUMBER) IS
1909: SELECT rel.relationship_id
1910: FROM AHL_MC_RELATIONSHIPS rel, AHL_MC_HEADERS_B mc, AHL_MC_PATH_POSITION_NODES node
1911: WHERE rel.mc_header_id = mc.mc_header_id
1912: AND node.position_key = rel.position_key
1913: AND node.mc_id = mc.mc_id
1914: AND nvl(node.version_number, mc.version_number) = mc.version_number

Line 1917: from AHL_MC_PATH_POSITION_NODES

1913: AND node.mc_id = mc.mc_id
1914: AND nvl(node.version_number, mc.version_number) = mc.version_number
1915: AND node.path_position_id = p_path_position_id
1916: AND node.sequence = (select max(sequence)
1917: from AHL_MC_PATH_POSITION_NODES
1918: WHERE path_position_id = p_path_position_id)
1919: ORDER by mc.version_number desc;
1920:
1921: --