[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'ok'
from pay_au_processes p
where p.process_id = p_process_id
and ((p.business_group_id is null
and p.legislation_code is null)
or (p.business_group_id = p_business_group_id)
or (p.legislation_code = p_legislation_code)) ;
select 'ok'
from fnd_sessions
where session_id = userenv('sessionid') ;
select pp.internal_name
, pp.data_type
from pay_au_process_parameters pp
where pp.process_id = p_process_id
and pp.enabled_flag = 'Y' ;
select legislation_code
from per_business_groups
where business_group_id = p_business_group_id ;
select m.name module_name
, mt.name module_type
, m.package_name
, m.procedure_function_name
, m.formula_name
, m.module_id
from pay_au_process_modules pm
, pay_au_modules m
, pay_au_module_types mt
where pm.process_id = p_process_id
and pm.enabled_flag = 'Y'
and m.module_id = pm.module_id
and m.enabled_flag = 'Y'
and mt.module_type_id = m.module_type_id
and mt.enabled_flag = 'Y'
order by
pm.process_sequence ;
select f.formula_id
from ff_formulas_f f
where f.formula_name = p_formula_name
and ((f.business_group_id is null
and f.legislation_code is null)
or (f.business_group_id = p_business_group_id)
or (f.legislation_code = p_legislation_code)) ;
select ue.user_entity_id
from ff_database_items dbi
, ff_user_entities ue
where dbi.user_name = p_database_item_name
and ue.user_entity_id = dbi.user_entity_id
and ue.legislation_code = p_legislation_code ;
select c.context_name
, decode(c.data_type
,'N', 'NUMBER'
,'T', 'TEXT'
,null) data_type
from ff_contexts c
, ff_route_context_usages rcu
, ff_routes r
, ff_user_entities ue
, ff_database_items dbi
where dbi.user_name = p_database_item_name
and ue.user_entity_id = dbi.user_entity_id
and ue.legislation_code = p_legislation_code
and r.route_id = ue.route_id
and rcu.route_id = r.route_id
and c.context_id = rcu.context_id
order by
rcu.sequence_no ;
select mp.internal_name
, mp.data_type
, mp.input_flag
, mp.context_flag
, mp.output_flag
, mp.result_flag
, mp.error_message_flag
, mp.function_return_flag
, mp.external_name
, mp.database_item_name
, mp.constant_value
from pay_au_module_parameters mp
where mp.module_id = p_module_id
and mp.enabled_flag = 'Y' ;