[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
pai.locked_action_id bal_adj_assact
from
pay_action_interlocks pai,
pay_assignment_actions paa,
pay_payroll_actions ppa
where
pai.locking_action_id = p_assignment_action_id
and paa.assignment_action_id = pai.locked_action_id
and paa.action_status = 'C'
and paa.payroll_action_id = ppa.payroll_action_id
and ppa.action_type = 'B'
and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null)
= 'YEA' ;
select
paa2.assignment_action_id,
ppa2.effective_date
from pay_payroll_actions ppa2,
pay_assignment_actions paa2,
pay_payroll_actions ppa,
pay_assignment_actions paa
where paa.assignment_action_id = p_bal_adj_assact
and ppa.payroll_action_id = paa.payroll_action_id
and paa2.assignment_id = paa.assignment_id
and paa2.action_sequence < paa.action_sequence
and paa2.source_action_id is null
and ppa2.payroll_action_id = paa2.payroll_action_id
and ( ppa2.action_type in ('I', 'R', 'Q', 'V') or ( ppa2.action_type ='B' and nvl(pay_core_utils.get_parameter('REPORT_TYPE',ppa2.legislative_parameters),'XYZ') <> 'YEA'))
and trunc(ppa2.effective_date, 'YYYY') = trunc(ppa.effective_date, 'YYYY')
order by paa2.action_sequence desc;
select
u.creator_id
into l_defined_balance_id
from ff_user_entities u,
ff_database_items d
where d.user_name = p_user_name
and u.user_entity_id = d.user_entity_id
and u.legislation_code = 'KR'
and u.business_group_id is null
and u.creator_type = 'B';