APPS.PQH_RST_BUS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

cursor c1 is select rule_set_name
             from pqh_rule_sets_vl
             where rule_set_id = p_rule_set_id;

Line: 129

  select null
    from pqh_rule_sets_vl
   where rule_set_name = p_rule_set_name;

Line: 202

    select seeded_rule_flag,rule_set_name,rule_category
    from   pqh_rule_sets_vl
    where  rule_set_id = p_referenced_rule_set_id;

Line: 290

    select null
    from   per_business_groups a
    where  a.organization_id = p_business_group_id;

Line: 373

    select rule_set_id
    from   pqh_rule_sets
    where ((p_organization_id is null and organization_id is null) or
                         (organization_id = p_organization_id))
    and ((p_organization_structure_id is null and organization_structure_id is null) or
                         (organization_structure_id = p_organization_structure_id))
    and ((p_business_group_id is null and business_group_id is null) or
                         (business_group_id = p_business_group_id))
    and ((p_starting_organization_id is null and starting_organization_id is null) or
                         (starting_organization_id = p_starting_organization_id))
    and ((p_rule_category is null and rule_category is null) or
    			 (rule_category = p_rule_category))
    and ((p_referenced_rule_set_id is null and referenced_rule_set_id is null) or
    			 (referenced_rule_set_id = p_referenced_rule_set_id))
    and rule_set_id <> p_rule_set_id;

Line: 471

    SELECT rule_set_id
      FROM pqh_rule_sets
     WHERE rule_set_id                      <> NVL(p_rule_set_id,-1)
       AND NVL(business_group_id,-1)         = NVL(p_business_group_id,-1)
       AND NVL(organization_structure_id,-1) = NVL(p_organization_structure_id,-1)
       AND NVL(starting_organization_id,-1)  = NVL(p_starting_organization_id,-1)
       AND NVL(organization_id,-1)           = NVL(p_organization_id,-1)
       AND rule_category                     = p_rule_category
       AND referenced_rule_set_id            = p_referenced_rule_set_id
       AND NVL(seeded_rule_flag,'N')         = 'N'
       AND NVL(p_seeded_rule_flag,'N')       = 'N';

Line: 539

    select business_group_id
    from   hr_all_organization_units a
    where  a.organization_id = p_organization_id;

Line: 635

    select business_group_id
    from   per_organization_structures a
    where  a.organization_structure_id = p_organization_structure_id;

Line: 828

	select hr_general.decode_lookup('PQH_CBR_RULE_CATEGORY', p_rule_category)
	into l_rule_category_meaning from dual;

Line: 929

  Select org_structure_version_id
    From per_org_structure_versions
   Where organization_structure_id = p_org_structure_id
     AND version_number =
         (select max(version_number)
          From per_org_structure_versions
          Where organization_structure_id = p_org_structure_id);

Line: 959

  Select null
   FROM per_org_structure_elements a
   WHERE a.org_structure_version_id   = l_org_structure_version_id
   AND   a.organization_id_child      = p_starting_organization_id
  UNION
  Select null
   FROM per_org_structure_elements b
   WHERE b.org_structure_version_id   = l_org_structure_version_id
   AND   b.organization_id_parent     = p_starting_organization_id;

Line: 1059

 Select rule_set_name
   From pqh_rule_sets_tl
  Where rule_set_id = p_rule_set_id;

Line: 1084

Procedure insert_validate(p_rec in pqh_rst_shd.g_rec_type
                         ,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 1185

End insert_validate;

Line: 1190

Procedure update_validate(p_rec in pqh_rst_shd.g_rec_type
                         ,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 1291

End update_validate;

Line: 1296

Procedure delete_validate(p_rec in pqh_rst_shd.g_rec_type
                         ,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 1307

End delete_validate;

Line: 1320

    select a.legislation_code
    from   per_business_groups a,
           pqh_rule_sets b
    where b.rule_set_id      = p_rule_set_id
    and   a.business_group_id = b.business_group_id;