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_ASSIGNMENTS_F

Line 60: employment_category per_all_assignments_f.employment_category%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),
64: address_jp varchar2(1),

Line 180: employment_category per_all_assignments_f.employment_category%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),
184: full_name varchar2(400),

Line 391: per_all_assignments_f pa,

387: pjwa.employment_category,
388: pjwa.actual_termination_date))) spr_term_valid
389: from pay_payroll_actions ppa,
390: pay_assignment_actions paa,
391: per_all_assignments_f pa,
392: pay_jp_wic_assacts_v pjwa
393: where ppa.effective_date
394: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')
395: and ppa.business_group_id + 0 = to_number(''i_business_group_id'')

Line 3446: from per_all_assignments_f asg,

3442: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240)) address_kanji,
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

Line 4358: from per_all_assignments_f asg,

4354: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240)) address_kanji,
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