[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select /*+ ORDERED */
ppa.business_group_id,
ppa.effective_date,
ppa.legislative_parameters,
pbg.legislation_code
from pay_payroll_actions ppa,
per_business_groups_perf pbg
where ppa.payroll_action_id = g_payroll_action_id
and pbg.business_group_id = ppa.business_group_id;
select /*+ ORDERED */
ppa.business_group_id,
ppa.effective_date,
pbg.legislation_code
from pay_payroll_actions ppa,
per_business_groups_perf pbg
where ppa.payroll_action_id = g_arch_payroll_action_id
and pbg.business_group_id = ppa.business_group_id;
'select distinct ppos.person_id
from pay_payroll_actions ppa,
per_all_people_f pp,
per_periods_of_service ppos
where ppa.payroll_action_id = :payroll_action_id
and pp.business_group_id = ppa.business_group_id + 0
and ppos.person_id = pp.person_id
and ppos.business_group_id + 0 = pp.business_group_id
and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_date'')
and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_date'')) >= fnd_date.canonical_to_date(''i_effective_date'')
order by
ppos.person_id';
select /*+ ORDERED */
pjda.assignment_id,
pjda.assignment_action_id,
pjda.effective_date
from per_periods_of_service ppos,
per_all_assignments_f pa,
pay_assignment_actions paa,
pay_jp_def_assact_v pjda,
pay_jp_def_emp_v pjde
where ppos.person_id
between p_start_person_id and p_end_person_id
and ppos.business_group_id + 0 = g_business_group_id
and ppos.date_start <= g_effective_date
and nvl(ppos.final_process_date,g_effective_date) >= g_effective_date
and pa.period_of_service_id = ppos.period_of_service_id
and pa.primary_flag = 'Y'
and g_effective_date
between pa.effective_start_date and pa.effective_end_date
and paa.assignment_id = pa.assignment_id
and paa.payroll_action_id = g_arch_payroll_action_id
and pjda.assignment_action_id = paa.assignment_action_id
and decode(nvl(g_txn_status,'Y'),'Y',pjda.transaction_status,'F') in ('F', 'A')
and pjde.assignment_action_id = pjda.assignment_action_id
and pjde.effective_date = pjda.effective_date;
select /*+ ORDERED */
pjda.assignment_id,
pjda.assignment_action_id,
pjda.effective_date,
hasa.include_or_exclude
from per_periods_of_service ppos,
per_all_assignments_f pa,
pay_assignment_actions paa,
hr_assignment_set_amendments hasa,
pay_jp_def_assact_v pjda,
pay_jp_def_emp_v pjde
where ppos.person_id
between p_start_person_id and p_end_person_id
and ppos.business_group_id + 0 = g_business_group_id
and ppos.date_start <= g_effective_date
and nvl(ppos.final_process_date,g_effective_date) >= g_effective_date
and pa.period_of_service_id = ppos.period_of_service_id
and pa.primary_flag = 'Y'
and g_effective_date
between pa.effective_start_date and pa.effective_end_date
and paa.assignment_id = pa.assignment_id
and paa.payroll_action_id = g_arch_payroll_action_id
and to_number(decode(nvl(to_char(g_ass_set_formula_id),'-1'),'-1',
decode(nvl(g_ass_set_amendment_type,'X'),'I',hasa.assignment_id,paa.assignment_id),
paa.assignment_id)) = paa.assignment_id
and hasa.assignment_set_id (+) = g_assignment_set_id
and hasa.assignment_id (+) = paa.assignment_id
and nvl(hasa.include_or_exclude,'I') <> 'E'
and pjda.assignment_action_id = paa.assignment_action_id
and decode(nvl(g_txn_status,'Y'),'Y',pjda.transaction_status,'F') in ('F', 'A')
and pjde.assignment_action_id = pjda.assignment_action_id
and pjde.effective_date = pjda.effective_date;
select pay_assignment_actions_s.nextval
into l_assignment_action_id
from dual;
select pay_assignment_actions_s.nextval
into l_assignment_action_id
from dual;
select /*+ ORDERED */
pjde.action_information_id,
pjdp.tax_office_name,
pjde.district_name,
pjdp.salary_payer_name,
pjdp.salary_payer_address,
pjde.employee_number,
pjde.last_name_kana,
pjde.first_name_kana,
pjde.last_name,
pjde.first_name,
pjde.date_of_birth,
pjde.sex,
pjde.household_head_ctr_id,
pjde.household_head_full_name,
pjde.household_head_contact_type,
pjde.postal_code,
pjde.address,
pjde.married_flag,
pjde.sec_sal_submit_flag,
pjde.disability_type,
pjde.aged_type,
pjde.widow_type,
pjde.working_student_type,
pjde.disability_details,
pjde.aged_details,
pjde.widow_details,
pjde.working_student_details,
pjde.change_date,
pjde.change_reason
from pay_assignment_actions paa,
pay_jp_def_pact_v pjdp,
pay_jp_def_assact_v pjda,
pay_jp_def_emp_v pjde
where paa.assignment_action_id = p_assignment_action_id
and pjdp.payroll_action_id = paa.payroll_action_id
and pjda.assignment_action_id = paa.assignment_action_id
and pjde.assignment_action_id = pjda.assignment_action_id
and pjde.effective_date = pjda.effective_date;
select /*+ ORDERED */
pjdd.action_information_id,
pjdd.last_name,
pjdd.first_name,
pjdd.date_of_birth,
pjdd.dep_type,
pjdd.occupation,
pjdd.address,
pjdd.estimated_annual_income,
pjdd.change_date,
pjdd.change_reason,
pjdd.disability_type,
pjdd.disability_details
from pay_jp_def_dep_v pjdd
where pjdd.assignment_action_id = p_assignment_action_id
and pjdd.contact_type = 'S'
and pjdd.status <> 'D';
select /*+ ORDERED */
pjdd.last_name,
pjdd.first_name,
pjdd.contact_type,
pjdd.date_of_birth,
pjdd.dep_type,
pjdd.occupation,
pjdd.address,
pjdd.estimated_annual_income,
pjdd.change_date,
pjdd.change_reason,
pjdd.disability_type,
pjdd.disability_details
from pay_jp_def_dep_v pjdd
where pjdd.assignment_action_id = p_assignment_action_id
and pjdd.contact_type <> 'S'
and pjdd.status <> 'D'
and nvl(pjdd.dep_type,'0') <> '5'
order by
pjdd.date_of_birth,
pjdd.last_name_kana,
pjdd.first_name_kana;
select /*+ ORDERED */
pjddo.last_name,
pjddo.first_name,
pjddo.contact_type,
pjddo.date_of_birth,
pjddo.occupation,
pjddo.address,
pjddo.change_date,
pjddo.change_reason,
pjddo.oe_full_name,
pjddo.oe_contact_type,
pjddo.oe_address
from pay_jp_def_dep_oe_v pjddo
where pjddo.assignment_action_id = p_assignment_action_id
and pjddo.status <> 'D'
order by
decode(pjddo.contact_type,'S',1,2),
pjddo.date_of_birth,
pjddo.last_name_kana,
pjddo.first_name_kana;
select /*+ ORDERED */
pjddo.last_name,
pjddo.first_name,
pjddo.contact_type,
pjddo.date_of_birth,
pjddo.occupation,
pjddo.os_salary_payer_name,
pjddo.os_salary_payer_address
from pay_jp_def_dep_os_v pjddo
where pjddo.assignment_action_id = p_assignment_action_id
and pjddo.status <> 'D'
order by
decode(pjddo.contact_type,'S',1,2),
pjddo.date_of_birth,
pjddo.last_name_kana,
pjddo.first_name_kana;
select /*+ ORDERED */
pjdd.last_name,
pjdd.first_name,
pjdd.contact_type,
pjdd.date_of_birth,
pjdd.address,
pjdd.estimated_annual_income,
pjdd.change_date,
pjdd.change_reason,
pjdd.disability_type,
pjdd.disability_details
from pay_jp_def_dep_v pjdd
where pjdd.assignment_action_id = p_assignment_action_id
and pjdd.contact_type <> 'S'
and nvl(pjdd.dep_type,'0') = '5'
and pjdd.status <> 'D'
order by
pjdd.date_of_birth,
pjdd.last_name_kana,
pjdd.first_name_kana;
select source_action_id
from pay_assignment_actions proc_paa
where assignment_action_id = l_mag_assignment_action_id;
select payroll_action_id
from pay_assignment_actions
where assignment_action_id = p_assignment_action_id;