[Home] [Help]
916: emp_add_phone2 per_addresses.telephone_number_2%type,
917: emp_ass_hire_date date,
918: emp_ass_organization_name hr_all_organization_units.name%type,
919: emp_ass_job_name per_jobs.name%type,
920: emp_ass_payroll_name pay_all_payrolls_f.payroll_name%type,
921: emp_ass_location_name hr_locations.location_code%type,
922: emp_si_itax_org_id number,
923: emp_si_itax_type varchar2(60),
924: emp_si_hi_org_id number,
1803: pp.last_name last_name_kana,
1804: pjwa.employment_category
1805: from pay_assignment_actions paa_yea,
1806: pay_jp_wic_assacts_v pjwa,
1807: pay_all_payrolls_f pap,
1808: per_all_people_f pp
1809: where paa_yea.assignment_action_id = p_assignment_action_id
1810: and pjwa.payroll_action_id = paa_yea.payroll_action_id
1811: and pap.payroll_id = pjwa.payroll_id
1938: pp.last_name last_name_kana,
1939: pjwa.employment_category
1940: from pay_assignment_actions paa_yea,
1941: pay_jp_wic_assacts_v pjwa,
1942: pay_all_payrolls_f pap,
1943: per_all_people_f pp
1944: where paa_yea.assignment_action_id = p_assignment_action_id
1945: and pjwa.payroll_action_id = paa_yea.payroll_action_id
1946: and pap.payroll_id = pjwa.payroll_id
7616: ) proc_v,
7617: per_all_assignments_f pa,
7618: per_all_people_f pp,
7619: per_periods_of_service ppos,
7620: pay_all_payrolls_f ppy
7621: where pa.assignment_id = proc_v.assignment_id
7622: and proc_v.effective_date
7623: between pa.effective_start_date and pa.effective_end_date
7624: and pp.person_id = pa.person_id
7852: -- and peev_itax_type2.effective_end_date = pee_itax_type2.effective_end_date
7853: -- and peev_itax_type2.screen_entry_value <> 'E'
7854: -- and paa2.action_sequence > paa.action_sequence) */
7855: ) proc_v,
7856: pay_all_payrolls_f ppy
7857: where ppy.payroll_id = proc_v.payroll_id
7858: and proc_v.effective_date
7859: between ppy.effective_start_date and ppy.effective_end_date
7860: order by
8129: ) proc_v,
8130: per_all_assignments_f pa,
8131: per_all_people_f pp,
8132: per_periods_of_service ppos,
8133: pay_all_payrolls_f ppy
8134: where pa.assignment_id = proc_v.assignment_id
8135: and proc_v.effective_date
8136: between pa.effective_start_date and pa.effective_end_date
8137: and pp.person_id = pa.person_id
8237: between pp.effective_start_date and pp.effective_end_date
8238: and ppos.period_of_service_id = pa.period_of_service_id) v,
8239: per_addresses padr,
8240: per_addresses padc,
8241: pay_all_payrolls_f ppy,
8242: per_jobs_vl pjb,
8243: hr_all_organization_units_vl hou,
8244: hr_locations_all_vl hlc
8245: where padr.person_id (+) = v.person_id