The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pbg.security_group_id
from per_business_groups pbg
, pqh_de_result_sets rss
-- , EDIT_HERE table_name(s) 333
where rss.result_set_id = p_result_set_id;
select pbg.legislation_code
from per_business_groups pbg
, pqh_de_result_sets rss
-- , EDIT_HERE table_name(s) 333
where rss.result_set_id = p_result_set_id;
Procedure chk_non_updateable_args
(p_effective_date in date
,p_rec in pqh_rss_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
Select Grade_id
from per_grades
Where Grade_id = p_rec.Grade_id;
SELECT
pg.NAME
FROM
per_gen_hierarchy pgh,
per_gen_hierarchy_versions pghv,
per_gen_hierarchy_nodes pghn,
PER_GEN_HIERARCHY_NODES pghn1 ,
PER_GEN_HIERARCHY_NODES pghn2 ,
PER_GEN_HIERARCHY_NODES pghn3 ,
PER_GEN_HIERARCHY_NODES pghn4 ,
PER_GEN_HIERARCHY_NODES pghn5 ,
PER_GEN_HIERARCHY_NODES pghn6 ,
PER_GRADES_VL pg
WHERE pgh.TYPE='REMUNERATION_REGULATION'
and pgh.HIERARCHY_ID=pghv.HIERARCHY_ID
and p_Effective_Date between pghv.Date_from and Nvl(pghv.Date_To,Trunc(Sysdate))
and pghv.HIERARCHY_VERSION_ID=pghn.HIERARCHY_VERSION_ID
and pghn.NODE_TYPE='PAY_GRADE'
and pghn.PARENT_HIERARCHY_NODE_ID = pghn1.HIERARCHY_NODE_ID
and pghn1.NODE_TYPE='TATIGKEIT'
and pghn1.PARENT_HIERARCHY_NODE_ID = pghn2.HIERARCHY_NODE_ID
and pghn2.PARENT_HIERARCHY_NODE_ID = pghn3.HIERARCHY_NODE_ID
and pghn3.PARENT_HIERARCHY_NODE_ID = pghn4.HIERARCHY_NODE_ID
and pghn4.PARENT_HIERARCHY_NODE_ID = pghn5.HIERARCHY_NODE_ID
and pghn5.PARENT_HIERARCHY_NODE_ID = pghn6.HIERARCHY_NODE_ID
and pghn6.ENTITY_ID = 'BE'
and pg.GRADE_ID = pghn.ENTITY_ID
union all
select pg.NAME
from
per_gen_hierarchy pgh,
per_gen_hierarchy_versions pghv,
per_gen_hierarchy_nodes pghn,
PER_GEN_HIERARCHY_NODES pghn1 ,
PER_GEN_HIERARCHY_NODES pghn2 ,
PER_GEN_HIERARCHY_NODES pghn3 ,
PER_GEN_HIERARCHY_NODES pghn4 ,
PER_GEN_HIERARCHY_NODES pghn5 ,
PER_GEN_HIERARCHY_NODES pghn6 ,
PER_GEN_HIERARCHY_NODES pghn7 ,
PER_GRADES_VL pg
where pgh.TYPE='REMUNERATION_REGULATION'
and pgh.HIERARCHY_ID=pghv.HIERARCHY_ID
and p_Effective_Date between pghv.Date_from and Nvl(pghv.Date_To,Trunc(Sysdate))
and pghv.HIERARCHY_VERSION_ID=pghn.HIERARCHY_VERSION_ID
and pghn.NODE_TYPE='PAY_GRADE'
and pghn.PARENT_HIERARCHY_NODE_ID = pghn1.HIERARCHY_NODE_ID
and pghn1.NODE_TYPE='TYPE_OF_SERVICE'
and pghn1.PARENT_HIERARCHY_NODE_ID = pghn2.HIERARCHY_NODE_ID
and pghn2.PARENT_HIERARCHY_NODE_ID = pghn3.HIERARCHY_NODE_ID
and pghn3.PARENT_HIERARCHY_NODE_ID = pghn4.HIERARCHY_NODE_ID
and pghn4.PARENT_HIERARCHY_NODE_ID = pghn5.HIERARCHY_NODE_ID
and pghn5.PARENT_HIERARCHY_NODE_ID = pghn6.HIERARCHY_NODE_ID
and pghn6.PARENT_HIERARCHY_NODE_ID = pghn7.HIERARCHY_NODE_ID
and pghn7.ENTITY_ID = 'BE';
Select '1'
from pqh_de_result_sets
Where (GRADUAL_VALUE_NUMBER_FROM = p_rec.GRADUAL_VALUE_NUMBER_FROM
or GRADUAL_VALUE_NUMBER_FROM = p_rec.GRADUAL_VALUE_NUMBER_to
or GRADUAL_VALUE_NUMBER_to = p_rec.GRADUAL_VALUE_NUMBER_FROM
or GRADUAL_VALUE_NUMBER_to = p_rec.GRADUAL_VALUE_NUMBER_to
or GRADUAL_VALUE_NUMBER_FROM between p_rec.GRADUAL_VALUE_NUMBER_FROM and p_rec.GRADUAL_VALUE_NUMBER_to
or GRADUAL_VALUE_NUMBER_to between p_rec.GRADUAL_VALUE_NUMBER_FROM and p_rec.GRADUAL_VALUE_NUMBER_to)
and result_set_id <> p_rec.result_set_id;
Procedure insert_validate
(p_effective_date in date
,p_rec in pqh_rss_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate
(p_effective_date in date
,p_rec in pqh_rss_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_validate';
chk_non_updateable_args
(p_effective_date => p_effective_date
,p_rec => p_rec
);
End update_validate;
Procedure delete_validate
(p_rec in pqh_rss_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;