DBA Data[Home] [Help]

APPS.PQH_CBR_ENGINE dependencies on PQH_RULE_SETS

Line 330: from pqh_rule_sets

326: hr_utility.set_Location('check_rule_existence p_rule_category'||p_rule_category,40);
327: hr_utility.set_Location('check_rule_existence p_rule_applicability'||p_rule_applicability,40);
328: select rule_set_id
329: into l_rule_set_id
330: from pqh_rule_sets
331: where business_group_id = p_business_group_id
332: and organization_structure_id = p_organization_structure_id
333: and starting_organization_id = p_starting_organization_id
334: and rule_category =p_rule_category

Line 1401: from pqh_rule_sets

1397:
1398: CURSOR csr_rule_rec(p_rule_applicability in varchar2) is
1399: select rule_set_id,organization_structure_id,starting_organization_id,organization_id,
1400: rule_set_name,rule_level_cd,rule_applicability
1401: from pqh_rule_sets
1402: where business_group_id = p_business_group_id
1403: and rule_category = p_rule_category
1404: and rule_applicability = p_rule_applicability
1405: and rule_level_cd <> 'I' ;