[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_sql := 'select distinct p.person_id ' ||
'from per_people_f p ' ||
',pay_payroll_actions pa ' ||
',per_assignments_f a ' ||
',pay_element_entries_f ee ' ||
',pay_element_links_f el ' ||
',pay_accrual_plans ap ' ||
'where pa.payroll_action_id = :payroll_action_id ' ||
'and p.business_group_id = pa.business_group_id ' ||
'and a.person_id = p.person_id ' ||
'and a.payroll_id is not null ' ||
'and ee.assignment_id = a.assignment_id ' ||
'and el.element_link_id = ee.element_link_id ' ||
'and ap.accrual_plan_element_type_id = el.element_type_id ' ||
'and ap.accrual_category = ''NZAL'' ' ||
'and pa.effective_date between p.effective_start_date ' ||
'and p.effective_end_date ' ||
'and pa.effective_date between a.effective_start_date ' ||
'and a.effective_end_date ' ||
'and pa.effective_date between ee.effective_start_date ' ||
'and ee.effective_end_date ' ||
'and pa.effective_date between el.effective_start_date ' ||
'and el.effective_end_date ' ||
'order by ' ||
'p.person_id ' ;
select distinct a.assignment_id
from pay_payroll_actions pa
, per_assignments_f a
, pay_element_entries_f ee
, pay_element_links_f el
, pay_accrual_plans ap
where pa.payroll_action_id = p_payroll_action_id
and a.business_group_id = pa.business_group_id
and a.person_id between p_start_person_id
and p_end_person_id
and a.payroll_id is not null
and ee.assignment_id = a.assignment_id
and el.element_link_id = ee.element_link_id
and ap.accrual_plan_element_type_id = el.element_type_id
and ap.accrual_category = 'NZAL'
and pa.effective_date between a.effective_start_date
and a.effective_end_date
and pa.effective_date between ee.effective_start_date
and ee.effective_end_date
and pa.effective_date between el.effective_start_date
and el.effective_end_date ;
select pay_assignment_actions_s.nextval
from dual ;
select p.process_id
from pay_au_processes p
where p.short_name = p_short_name
and p.legislation_code = 'NZ' ;
select pa.business_group_id
, pa.payroll_action_id
, aa.assignment_id
from pay_assignment_actions aa
, pay_payroll_actions pa
where aa.assignment_action_id = p_assignment_action_id
and pa.payroll_action_id = aa.payroll_action_id ;
select ap.accrual_plan_id
, a.payroll_id
from pay_assignment_actions aa
, pay_payroll_actions pa
, per_assignments_f a
, pay_element_entries_f ee
, pay_element_links_f el
, pay_accrual_plans ap
where aa.assignment_action_id = p_assignment_action_id
and pa.payroll_action_id = aa.payroll_action_id
and a.assignment_id = aa.assignment_id
and a.payroll_id is not null
and ee.assignment_id = a.assignment_id
and el.element_link_id = ee.element_link_id
and ap.accrual_plan_element_type_id = el.element_type_id
and ap.accrual_category = 'NZAL'
and pa.effective_date between a.effective_start_date
and a.effective_end_date
and pa.effective_date between ee.effective_start_date
and ee.effective_end_date
and pa.effective_date between el.effective_start_date
and el.effective_end_date ;
select m.module_id
from pay_au_modules m
where m.formula_name = p_formula_name
and m.enabled_flag = 'Y'
and ((m.business_group_id is null
and m.legislation_code is null)
or (m.business_group_id = p_business_group_id)
or (m.legislation_code = p_legislation_code)) ;