DBA Data[Home] [Help]

APPS.PAY_JP_LTAX_IMP_PKG dependencies on PER_ALL_PEOPLE_F

Line 35: i_employee_number per_all_people_f.employee_number%type,

31: file_id number,
32: line number,
33: i_swot_number pay_jp_swot_numbers.swot_number%type,
34: i_personal_number pay_element_entry_values_f.screen_entry_value%type,
35: i_employee_number per_all_people_f.employee_number%type,
36: i_address varchar2(800),
37: i_address_kana varchar2(800),
38: i_full_name varchar2(400),
39: i_full_name_kana varchar2(400),

Line 1462: from per_all_people_f pp,

1458: pa.payroll_id,
1459: pa.assignment_number,
1460: ptp.regular_payment_date,
1461: greatest(ppos.actual_termination_date,nvl(ppos.final_process_date,ppos.actual_termination_date)) final_process_date
1462: from per_all_people_f pp,
1463: per_all_assignments_f pa,
1464: per_time_periods ptp,
1465: per_periods_of_service ppos
1466: where pp.business_group_id + 0 = g_business_group_id