[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pes.element_set_name,
ppa.business_group_id,
ppa.date_earned,
paa.assignment_id,
ppa.effective_date
from pay_element_sets pes,
pay_payroll_actions ppa,
pay_assignment_actions paa
where paa.assignment_action_id=p_assignment_action_id
and ppa.payroll_action_id=paa.payroll_action_id
and pes.element_set_id(+)=ppa.element_set_id;
select pec.balance_initialization_flag,
pec.classification_name,
pet.element_name,
pec.legislation_code
from pay_element_classifications pec,
pay_element_types_f pet,
pay_run_results prr,
pay_payroll_actions ppa,
pay_assignment_actions paa
where paa.assignment_action_id=p_assignment_action_id
and ppa.payroll_action_id=paa.payroll_action_id
and prr.assignment_action_id=paa.assignment_action_id
and pet.element_type_id=prr.element_type_id
and ppa.effective_date
between pet.effective_start_date and pet.effective_end_date
and pec.classification_id=pet.classification_id;
select prrv.result_value
from pay_input_values_f piv,
pay_element_types_f pet,
pay_run_result_values prrv,
pay_run_results prr,
pay_payroll_actions ppa2,
pay_assignment_actions paa2,
pay_payroll_actions ppa,
pay_assignment_actions paa
where paa.assignment_action_id=p_assignment_action_id
and ppa.payroll_action_id=paa.payroll_action_id
and ppa.action_type='I'
and paa2.assignment_id=paa.assignment_id
and ppa2.payroll_action_id=paa2.payroll_action_id
and ppa2.effective_date=ppa.effective_date
and ppa2.action_type='I'
and prr.assignment_action_id=paa2.assignment_action_id
and prrv.run_result_id=prr.run_result_id
and prrv.result_value is not NULL
and pet.element_type_id=prr.element_type_id
and ppa2.effective_date
between pet.effective_start_date and pet.effective_end_date
and (pet.element_name = g_name_tl.bal_init_prefix || g_name_tl.yea || '2'
or (pet.element_name = 'INI_YEA2' and pet.legislation_code = 'JP'))
and piv.input_value_id=prrv.input_value_id
and ppa2.effective_date
between piv.effective_start_date and piv.effective_end_date
and piv.name=g_name_tl.yea_category2;
select ppa.business_group_id,
ppa.effective_date,
-- ppa.date_earned,
paa.assignment_id,
ppa.element_set_id,
ppa.element_type_id
into l_business_group_id,
l_effective_date,
-- l_date_earned,
l_assignment_id,
l_element_set_id,
l_element_type_id
from pay_assignment_actions paa,
pay_payroll_actions ppa
where paa.assignment_action_id = p_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id;
select element_set_name,
legislation_code
into l_element_set_name, l_legislation_code
from pay_element_sets
where element_set_id = l_element_set_id;
select pet.element_name,
pec.classification_name,
pec.legislation_code
into l_element_name,
l_classification_name,
l_legislation_code
from pay_element_types_f pet,
pay_element_classifications pec
where pet.element_type_id = l_element_type_id
and l_effective_date
between pet.effective_start_date and pet.effective_end_date
and pec.classification_id = pet.classification_id;