[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select business_group_id, payroll_id
from per_all_assignments_f
where assignment_id = cp_assignment_id
and cp_effective_date between effective_start_date and effective_end_date;
select paa.assignment_id, ppa.business_group_id, ppa.payroll_id
from pay_assignment_actions paa
,pay_payroll_actions ppa
where paa.assignment_action_id = cp_assignment_action_id
and paa.payroll_action_id = ppa.payroll_action_id;
select rownum, et.element_name, paf.assignment_id, plan.accrual_plan_id
,plan.accrual_plan_name, lookup.meaning UOM
,paf.business_group_id, paf.payroll_id
,ee.element_entry_id, ee.effective_start_date ee_start_date
from pay_element_entries_f ee
,pay_element_types_f et
,pay_accrual_plans plan
,per_all_assignments_f paf
,per_all_people_f peo
,hr_lookups lookup
where peo.person_id = cp_person_id
and cp_effective_date between peo.effective_start_date
and peo.effective_end_date
and peo.person_id = paf.person_id
and paf.effective_start_date between peo.effective_start_date
and peo.effective_end_date
and ee.assignment_id = paf.assignment_id
and ee.element_type_id = plan.ACCRUAL_PLAN_ELEMENT_TYPE_ID
and ee.element_type_id = et.element_type_id
and ee.effective_start_date between et.effective_start_date
and et.effective_end_date
and lookup.lookup_type = 'HOURS_OR_DAYS'
and plan.ACCRUAL_UNITS_OF_MEASURE = lookup_code
and lookup.enabled_flag = 'Y';
select defined_balance_id
from pay_accrual_plans
where accrual_plan_id = p_plan_id;