APPS.AHL_MC_RULE_STMT_PVT dependencies on AHL_MC_HEADERS_B

Line 60: FROM AHL_MC_HEADERS_B header,

56: --Checks that position_id is valid and that position_id maps to the rule's mc
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

Line 79: FROM AHL_MC_HEADERS_B

75: --Check that mc_id plus version number is valid configuration
76: CURSOR Check_mc_id_csr (p_mc_id IN NUMBER,
77: p_ver_number IN NUMBER) IS
78: SELECT 'X'
79: FROM AHL_MC_HEADERS_B
80: WHERE mc_id = p_mc_id
81: AND version_number = nvl(p_ver_number, version_number);
82:
83: --

Line 1340: FROM AHL_MC_HEADERS_B header,

1336: else we will get as many records as the versions of the MC, unless the user deleted the relation in one of the versions.
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)