APPS.AHL_MC_RULE_STMT_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 1342: AHL_MC_RELATIONSHIPS rels

1338: CURSOR get_relationships_csr (p_position_id IN NUMBER) IS
1339: SELECT header.mc_header_id, header.name, header.revision, rels.position_key, rels.relationship_id
1340: FROM AHL_MC_HEADERS_B header,
1341: AHL_MC_PATH_POSITION_NODES pnodes,
1342: AHL_MC_RELATIONSHIPS rels
1343: WHERE pnodes.path_position_id = p_position_id
1344: AND pnodes.sequence = (select max(sequence) from AHL_MC_PATH_POSITION_NODES where path_position_id = p_position_id)
1345: AND pnodes.mc_id = header.mc_id
1346: AND nvl(pnodes.version_number,header.version_number) = header.version_number

Line 1352: FROM AHL_MC_RELATIONSHIPS

1348: AND rels.position_key = pnodes.position_key;
1349:
1350: CURSOR get_child_rels_csr(p_relationship_id IN NUMBER) IS
1351: SELECT relationship_id
1352: FROM AHL_MC_RELATIONSHIPS
1353: WHERE parent_relationship_id = p_relationship_id;
1354:
1355: CURSOR is_rel_nonleaf_node(p_relationship_id IN NUMBER) IS
1356: SELECT 1

Line 1357: FROM AHL_MC_RELATIONSHIPS

1353: WHERE parent_relationship_id = p_relationship_id;
1354:
1355: CURSOR is_rel_nonleaf_node(p_relationship_id IN NUMBER) IS
1356: SELECT 1
1357: FROM AHL_MC_RELATIONSHIPS
1358: WHERE parent_relationship_id = p_relationship_id
1359: AND rownum = 1;
1360:
1361: CURSOR is_rel_subconfig_csr(p_relationship_id IN NUMBER) IS