APPS.AHL_MC_RULE_PVT dependencies on AHL_MC_RULE_STATEMENTS_S

Line 50: FROM ahl_mc_rule_statements stmt

46: IS
47: --
48: CURSOR ahl_rule_stmt_csr (p_rule_id IN NUMBER) IS
49: SELECT rule_statement_id
50: FROM ahl_mc_rule_statements stmt
51: WHERE rule_id = p_rule_id
52: AND top_rule_stmt_flag = 'T';
53: --
54: l_api_version CONSTANT NUMBER := 1.0;

Line 212: l_subject_id AHL_MC_RULE_STATEMENTS.SUBJECT_ID%TYPE;

208: --
209: l_operator AHL_MC_RULE_STATEMENTS.OPERATOR%TYPE;
210: l_obj_ver_num NUMBER;
211: l_oper_meaning VARCHAR2(80);
212: l_subject_id AHL_MC_RULE_STATEMENTS.SUBJECT_ID%TYPE;
213: l_object_id AHL_MC_RULE_STATEMENTS.OBJECT_ID%TYPE;
214: l_subject_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type;
215: l_object_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type;
216: l_max NUMBER;

Line 466: SELECT ahl_mc_rule_statements_s.nextval FROM DUAL;

462: x_rule_stmt_id OUT NOCOPY NUMBER)
463: IS
464: --
465: CURSOR next_rule_stmt_id_csr IS
466: SELECT ahl_mc_rule_statements_s.nextval FROM DUAL;
467:
468: --
469: l_stmt_rec AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type;
470: l_ui_stmt_rec AHL_MC_RULE_PVT.UI_Rule_Stmt_Rec_Type;