APPS.AHL_MC_RULE_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 1887: AHL_MC_PATH_POSITION_NODES where path_position_id=pst.path_position_id)

1883: WHERE rst.subject_type = 'POSITION'
1884: AND rst.subject_id = pst.path_position_id
1885: AND p_encoded_path LIKE pst.encoded_path_position
1886: AND p_size = (select COUNT(path_position_node_id) FROM
1887: AHL_MC_PATH_POSITION_NODES where path_position_id=pst.path_position_id)
1888: UNION ALL
1889: SELECT rst.rule_id
1890: FROM AHL_MC_RULE_STATEMENTS rst, AHL_MC_PATH_POSITIONS pst
1891: WHERE (rst.object_type = 'ITEM_AS_POSITION'

Line 1896: AHL_MC_PATH_POSITION_NODES where path_position_id=pst.path_position_id));

1892: OR rst.object_type = 'CONFIG_AS_POSITION')
1893: AND rst.object_id = pst.path_position_id
1894: AND p_encoded_path LIKE pst.encoded_path_position
1895: AND p_size = (select COUNT(path_position_node_id) FROM
1896: AHL_MC_PATH_POSITION_NODES where path_position_id=pst.path_position_id));
1897: --
1898: l_api_version CONSTANT NUMBER := 1.0;
1899: l_api_name CONSTANT VARCHAR2(30) := 'Get_Rules_For_Position';
1900: l_get_rule_rec get_rule_vo_csr%ROWTYPE;