The following lines contain the word 'select', 'insert', 'update' or 'delete':
cursor c1 is select rule_set_name
from pqh_rule_sets_vl
where rule_set_id = p_rule_set_id;
select null
from pqh_rule_sets_vl
where rule_set_name = p_rule_set_name;
select seeded_rule_flag,rule_set_name,rule_category
from pqh_rule_sets_vl
where rule_set_id = p_referenced_rule_set_id;
select null
from per_business_groups a
where a.organization_id = p_business_group_id;
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;
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';
select business_group_id
from hr_all_organization_units a
where a.organization_id = p_organization_id;
select business_group_id
from per_organization_structures a
where a.organization_structure_id = p_organization_structure_id;
select hr_general.decode_lookup('PQH_CBR_RULE_CATEGORY', p_rule_category)
into l_rule_category_meaning from dual;
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);
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;
Select rule_set_name
From pqh_rule_sets_tl
Where rule_set_id = p_rule_set_id;
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';
End insert_validate;
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';
End update_validate;
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';
End delete_validate;
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;