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_SPR_EFILE_PKG dependencies on PER_ALL_PEOPLE_F

Line 53: sex per_all_people_f.sex%type,

49: itax_yea_category pay_jp_pre_tax.itax_yea_category%type,
50: dpnt_ref_type pay_all_payrolls_f.prl_information1%type,
51: dpnt_effective_date date,
52: person_id number,
53: sex per_all_people_f.sex%type,
54: date_of_birth date,
55: leaving_reason per_periods_of_service.leaving_reason%type,
56: last_name per_all_people_f.per_information18%type,
57: last_name_kana per_all_people_f.last_name%type,

Line 56: last_name per_all_people_f.per_information18%type,

52: person_id number,
53: sex per_all_people_f.sex%type,
54: date_of_birth date,
55: leaving_reason per_periods_of_service.leaving_reason%type,
56: last_name per_all_people_f.per_information18%type,
57: last_name_kana per_all_people_f.last_name%type,
58: first_name per_all_people_f.per_information19%type,
59: first_name_kana per_all_people_f.first_name%type,
60: employment_category per_all_assignments_f.employment_category%type,

Line 57: last_name_kana per_all_people_f.last_name%type,

53: sex per_all_people_f.sex%type,
54: date_of_birth date,
55: leaving_reason per_periods_of_service.leaving_reason%type,
56: last_name per_all_people_f.per_information18%type,
57: last_name_kana per_all_people_f.last_name%type,
58: first_name per_all_people_f.per_information19%type,
59: first_name_kana per_all_people_f.first_name%type,
60: employment_category per_all_assignments_f.employment_category%type,
61: district_code per_addresses.town_or_city%type,

Line 58: first_name per_all_people_f.per_information19%type,

54: date_of_birth date,
55: leaving_reason per_periods_of_service.leaving_reason%type,
56: last_name per_all_people_f.per_information18%type,
57: last_name_kana per_all_people_f.last_name%type,
58: first_name per_all_people_f.per_information19%type,
59: first_name_kana per_all_people_f.first_name%type,
60: employment_category per_all_assignments_f.employment_category%type,
61: district_code per_addresses.town_or_city%type,
62: address varchar2(800),

Line 59: first_name_kana per_all_people_f.first_name%type,

55: leaving_reason per_periods_of_service.leaving_reason%type,
56: last_name per_all_people_f.per_information18%type,
57: last_name_kana per_all_people_f.last_name%type,
58: first_name per_all_people_f.per_information19%type,
59: first_name_kana per_all_people_f.first_name%type,
60: employment_category per_all_assignments_f.employment_category%type,
61: district_code per_addresses.town_or_city%type,
62: address varchar2(800),
63: address_kana varchar2(800),

Line 69: employee_number per_all_people_f.employee_number%type,

65: full_name varchar2(400),
66: actual_termination_date date,
67: date_start date,
68: full_name_kana varchar2(400),
69: employee_number per_all_people_f.employee_number%type,
70: swot_number pay_jp_swot_numbers.swot_number%type,
71: output_file_name pay_jp_swot_numbers.output_file_name%type,
72: itax_org_address varchar2(500),
73: itax_org_address_kana varchar2(500),

Line 173: sex per_all_people_f.sex%type,

169: itax_yea_category pay_jp_pre_tax.itax_yea_category%type,
170: dpnt_ref_type pay_all_payrolls_f.prl_information1%type,
171: dpnt_effective_date date,
172: person_id number,
173: sex per_all_people_f.sex%type,
174: date_of_birth date,
175: leaving_reason per_periods_of_service.leaving_reason%type,
176: last_name per_all_people_f.per_information18%type,
177: last_name_kana per_all_people_f.last_name%type,

Line 176: last_name per_all_people_f.per_information18%type,

172: person_id number,
173: sex per_all_people_f.sex%type,
174: date_of_birth date,
175: leaving_reason per_periods_of_service.leaving_reason%type,
176: last_name per_all_people_f.per_information18%type,
177: last_name_kana per_all_people_f.last_name%type,
178: first_name per_all_people_f.per_information19%type,
179: first_name_kana per_all_people_f.first_name%type,
180: employment_category per_all_assignments_f.employment_category%type,

Line 177: last_name_kana per_all_people_f.last_name%type,

173: sex per_all_people_f.sex%type,
174: date_of_birth date,
175: leaving_reason per_periods_of_service.leaving_reason%type,
176: last_name per_all_people_f.per_information18%type,
177: last_name_kana per_all_people_f.last_name%type,
178: first_name per_all_people_f.per_information19%type,
179: first_name_kana per_all_people_f.first_name%type,
180: employment_category per_all_assignments_f.employment_category%type,
181: address varchar2(800),

Line 178: first_name per_all_people_f.per_information19%type,

174: date_of_birth date,
175: leaving_reason per_periods_of_service.leaving_reason%type,
176: last_name per_all_people_f.per_information18%type,
177: last_name_kana per_all_people_f.last_name%type,
178: first_name per_all_people_f.per_information19%type,
179: first_name_kana per_all_people_f.first_name%type,
180: employment_category per_all_assignments_f.employment_category%type,
181: address varchar2(800),
182: address_kana varchar2(800),

Line 179: first_name_kana per_all_people_f.first_name%type,

175: leaving_reason per_periods_of_service.leaving_reason%type,
176: last_name per_all_people_f.per_information18%type,
177: last_name_kana per_all_people_f.last_name%type,
178: first_name per_all_people_f.per_information19%type,
179: first_name_kana per_all_people_f.first_name%type,
180: employment_category per_all_assignments_f.employment_category%type,
181: address varchar2(800),
182: address_kana varchar2(800),
183: address_jp varchar2(1),

Line 327: o_employee_number per_all_people_f.employee_number%type,

323: o_gen_collecting varchar2(1),
324: o_blue_proprietor varchar2(1),
325: o_immune varchar2(1),
326: o_full_name_kana varchar2(400),
327: o_employee_number per_all_people_f.employee_number%type,
328: o_district_code per_addresses.town_or_city%type,
329: o_swot_number pay_jp_swot_numbers.swot_number%type,
330: o_new_life_ins_prem number,
331: o_old_life_ins_prem number,

Line 683: per_all_people_f pp,

679: from pay_payroll_actions ppa,
680: pay_assignment_actions paa,
681: pay_jp_wic_assacts_v pjwa,
682: pay_all_payrolls_f pap,
683: per_all_people_f pp,
684: per_addresses padr,
685: per_addresses padc
686: where ppa.payroll_action_id = :p_payroll_action_id
687: and paa.payroll_action_id = ppa.payroll_action_id

Line 1928: per_all_people_f pp,

1924: 'select /*+ ORDERED
1925: INDEX(PPOS PER_PERIODS_OF_SERVICE_N3) */
1926: distinct ppos.person_id
1927: from pay_payroll_actions ppa,
1928: per_all_people_f pp,
1929: per_periods_of_service ppos
1930: where ppa.payroll_action_id = :payroll_action_id
1931: and pp.business_group_id = ppa.business_group_id + 0
1932: and ppos.person_id = pp.person_id

Line 3447: per_all_people_f per,

3443: decode(adrr.address_id, null, adrc.country, adrr.country) country,
3444: decode(adrr.address_id, null, adrc.town_or_city, adrr.town_or_city) district_code,
3445: asg.organization_id
3446: from per_all_assignments_f asg,
3447: per_all_people_f per,
3448: per_addresses adrr,
3449: per_addresses adrc
3450: where asg.assignment_id = cp_assignment_id
3451: and cp_effective_date

Line 4359: per_all_people_f per,

4355: decode(adrr.address_id, null, adrc.country, adrr.country) country,
4356: decode(adrr.address_id, null, adrc.town_or_city, adrr.town_or_city) district_code,
4357: asg.organization_id
4358: from per_all_assignments_f asg,
4359: per_all_people_f per,
4360: per_addresses adrr,
4361: per_addresses adrc
4362: where asg.assignment_id = cp_assignment_id
4363: and cp_effective_date