APPS.PQH_CBR_ENGINE dependencies on PQH_RULES

Line 1454: select count(*) into l_rule_messages from pqh_rules where rule_set_id = l_rule_rec.rule_set_id;

1450: end if;
1451: for l_rule_rec in csr_rule_rec(p_rule_applicability => l_rule_applicability) loop
1452: hr_utility.set_location('finding rule '||l_rule_applicability,30);
1453: l_rule_valid := FALSE ; -- initializing the result variable
1454: select count(*) into l_rule_messages from pqh_rules where rule_set_id = l_rule_rec.rule_set_id;
1455: select count(*) into l_rule_conditions from pqh_rule_attributes where rule_set_id = l_rule_rec.rule_set_id;
1456: if l_rule_messages <> 1 or l_rule_conditions = 0 then
1457: hr_utility.set_location('Either message or condition is undefined',50);
1458: l_rule_valid := FALSE ;

Line 1463: from pqh_rules

1459: else
1460: l_rule_valid := TRUE ;
1461: select message_name
1462: into l_message_cd
1463: from pqh_rules
1464: where rule_set_id = l_rule_rec.rule_set_id
1465: and application_id = 8302;
1466: hr_utility.set_location('message is'||l_message_cd,55);
1467: end if;