APPS.AHL_MC_RULE_STMT_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 61: AHL_MC_PATH_POSITION_NODES pnodes, AHL_MC_RULES_B rule

57: -- by checking mc_id and version are the same.
58: CURSOR Check_position_id_csr (p_rule_id IN NUMBER, p_position_id IN NUMBER) IS
59: SELECT 'X'
60: FROM AHL_MC_HEADERS_B header,
61: AHL_MC_PATH_POSITION_NODES pnodes, AHL_MC_RULES_B rule
62: WHERE pnodes.path_position_id = p_position_id
63: AND rule.rule_id = p_rule_id
64: AND rule.mc_header_id = header.mc_header_id
65: AND pnodes.sequence = 0

Line 1341: AHL_MC_PATH_POSITION_NODES pnodes,

1337: */
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

Line 1344: AND pnodes.sequence = (select max(sequence) from AHL_MC_PATH_POSITION_NODES where path_position_id = p_position_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
1347: AND rels.mc_header_id = header.mc_header_id
1348: AND rels.position_key = pnodes.position_key;