DBA Data[Home] [Help]

APPS.AHL_MC_RULE_PVT dependencies on AHL_MC_PATH_POSITIONS

Line 1882: FROM AHL_MC_RULE_STATEMENTS rst, AHL_MC_PATH_POSITIONS pst

1878: AND lookup.lookup_type = 'AHL_MC_RULE_TYPES'
1879: AND rul.mc_header_id = p_mc_header_id
1880: AND rul.rule_id IN (
1881: SELECT rst.rule_id
1882: FROM AHL_MC_RULE_STATEMENTS rst, AHL_MC_PATH_POSITIONS pst
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

Line 1890: FROM AHL_MC_RULE_STATEMENTS rst, AHL_MC_PATH_POSITIONS pst

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'
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