eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PER_ALL_PEOPLE_F

Line 902: emp_employee_number per_all_people_f.employee_number%type,

898: assact_location_id number,
899: assact_termination_date date,
900: assact_leaving_reason per_periods_of_service.leaving_reason%type,
901: emp_person_id number,
902: emp_employee_number per_all_people_f.employee_number%type,
903: emp_last_name per_all_people_f.per_information18%type,
904: emp_first_name per_all_people_f.per_information19%type,
905: emp_last_name_kana per_all_people_f.last_name%type,
906: emp_first_name_kana per_all_people_f.first_name%type,

Line 903: emp_last_name per_all_people_f.per_information18%type,

899: assact_termination_date date,
900: assact_leaving_reason per_periods_of_service.leaving_reason%type,
901: emp_person_id number,
902: emp_employee_number per_all_people_f.employee_number%type,
903: emp_last_name per_all_people_f.per_information18%type,
904: emp_first_name per_all_people_f.per_information19%type,
905: emp_last_name_kana per_all_people_f.last_name%type,
906: emp_first_name_kana per_all_people_f.first_name%type,
907: emp_sex per_all_people_f.sex%type,

Line 904: emp_first_name per_all_people_f.per_information19%type,

900: assact_leaving_reason per_periods_of_service.leaving_reason%type,
901: emp_person_id number,
902: emp_employee_number per_all_people_f.employee_number%type,
903: emp_last_name per_all_people_f.per_information18%type,
904: emp_first_name per_all_people_f.per_information19%type,
905: emp_last_name_kana per_all_people_f.last_name%type,
906: emp_first_name_kana per_all_people_f.first_name%type,
907: emp_sex per_all_people_f.sex%type,
908: emp_birth_date date,

Line 905: emp_last_name_kana per_all_people_f.last_name%type,

901: emp_person_id number,
902: emp_employee_number per_all_people_f.employee_number%type,
903: emp_last_name per_all_people_f.per_information18%type,
904: emp_first_name per_all_people_f.per_information19%type,
905: emp_last_name_kana per_all_people_f.last_name%type,
906: emp_first_name_kana per_all_people_f.first_name%type,
907: emp_sex per_all_people_f.sex%type,
908: emp_birth_date date,
909: emp_add_address_id number,

Line 906: emp_first_name_kana per_all_people_f.first_name%type,

902: emp_employee_number per_all_people_f.employee_number%type,
903: emp_last_name per_all_people_f.per_information18%type,
904: emp_first_name per_all_people_f.per_information19%type,
905: emp_last_name_kana per_all_people_f.last_name%type,
906: emp_first_name_kana per_all_people_f.first_name%type,
907: emp_sex per_all_people_f.sex%type,
908: emp_birth_date date,
909: emp_add_address_id number,
910: emp_add_address_jp varchar2(1),

Line 907: emp_sex per_all_people_f.sex%type,

903: emp_last_name per_all_people_f.per_information18%type,
904: emp_first_name per_all_people_f.per_information19%type,
905: emp_last_name_kana per_all_people_f.last_name%type,
906: emp_first_name_kana per_all_people_f.first_name%type,
907: emp_sex per_all_people_f.sex%type,
908: emp_birth_date date,
909: emp_add_address_id number,
910: emp_add_address_jp varchar2(1),
911: emp_add_postal_code per_addresses.postal_code%type,

Line 1808: per_all_people_f pp

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
1812: and pjwa.effective_date

Line 1943: per_all_people_f pp

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
1947: and pjwa.effective_date

Line 6034: per_all_people_f pp,

6030: --
6031: p_sqlstr :=
6032: 'select distinct ppos.person_id
6033: from pay_payroll_actions ppa,
6034: per_all_people_f pp,
6035: per_periods_of_service ppos
6036: where ppa.payroll_action_id = :payroll_action_id
6037: and pp.business_group_id = ppa.business_group_id + 0
6038: and ppos.person_id = pp.person_id

Line 7618: per_all_people_f pp,

7614: -- and peev_itax_type2.screen_entry_value <> 'E'
7615: -- and paa2.action_sequence > paa.action_sequence) */
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

Line 8131: per_all_people_f pp,

8127: -- and peev_itax_type2.screen_entry_value <> 'E'
8128: -- and paa2.action_sequence > paa.action_sequence) */
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

Line 8230: per_all_people_f pp,

8226: ppos.leaving_reason,
8227: pp.sex,
8228: pp.date_of_birth
8229: from per_all_assignments_f pa,
8230: per_all_people_f pp,
8231: per_periods_of_service ppos
8232: where pa.assignment_id = p_assignment_id
8233: and p_effective_date
8234: between pa.effective_start_date and pa.effective_end_date