APPS.AHL_MC_RULE_STMT_PVT dependencies on AHL_MC_RULES_B

Line 48: SELECT rule_type_code FROM ahl_mc_rules_b

44: p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type)
45: IS
46: --
47: CURSOR Check_rule_type_csr (p_rule_id IN NUMBER) IS
48: SELECT rule_type_code FROM ahl_mc_rules_b
49: WHERE rule_id = p_rule_id;
50: --
51: CURSOR Check_rule_statement_csr (p_rule_stmt_id IN NUMBER) IS
52: SELECT 'X'

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 87: l_rule_type AHL_MC_RULES_B.RULE_TYPE_CODE%TYPE;

83: --
84: l_api_version CONSTANT NUMBER := 1.0;
85: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Rule_Stmt';
86: l_junk VARCHAR2(1);
87: l_rule_type AHL_MC_RULES_B.RULE_TYPE_CODE%TYPE;
88: --
89: BEGIN
90: -- Initialize Procedure return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1538: FROM ahl_mc_rules_b rul, ahl_mc_rule_statements ruls

1534: ruls.subject_type,
1535: ruls.operator,
1536: ruls.object_type,
1537: ruls.OBJECT_ATTRIBUTE1
1538: FROM ahl_mc_rules_b rul, ahl_mc_rule_statements ruls
1539: WHERE rul.rule_id = ruls.rule_id
1540: AND rul.mc_header_id = p_mc_header_id
1541: AND ruls.object_type = 'TOT_CHILD_QUANTITY'
1542: AND TRUNC(nvl(rul.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)