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_ADDRESSES

Line 61: district_code per_addresses.town_or_city%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),
65: full_name varchar2(400),

Line 328: o_district_code per_addresses.town_or_city%type,

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,
332: o_new_care_med_prem number,

Line 345: district_code per_addresses.town_or_city%type,

341: g_file_tbl t_file_tbl;
342: --
343: type t_summary_rec is record(
344: file_name varchar2(80),
345: district_code per_addresses.town_or_city%type,
346: itax_org_cnt number,
347: emp_cnt number,
348: term_emp_cnt number);
349: type t_summary_tbl is table of t_summary_rec index by binary_integer;

Line 407: per_addresses padr,

403: between pa.effective_start_date and pa.effective_end_date
404: and pjwa.assignment_action_id = paa.assignment_action_id
405: and pjwa.payroll_action_id = ppa.payroll_action_id
406: and pjwa.itax_organization_id = nvl(to_number(''i_organization_id''),pjwa.itax_organization_id)) pjwa_v,
407: per_addresses padr,
408: per_addresses padc
409: where padr.person_id (+) = pjwa_v.pjwa_person_id
410: and padr.address_type (+) = ''JP_R''
411: and nvl(pjwa_v.actual_termination_date, add_months(trunc(pjwa_v.effective_date, ''YYYY''), 12))

Line 408: per_addresses padc

404: and pjwa.assignment_action_id = paa.assignment_action_id
405: and pjwa.payroll_action_id = ppa.payroll_action_id
406: and pjwa.itax_organization_id = nvl(to_number(''i_organization_id''),pjwa.itax_organization_id)) pjwa_v,
407: per_addresses padr,
408: per_addresses padc
409: where padr.person_id (+) = pjwa_v.pjwa_person_id
410: and padr.address_type (+) = ''JP_R''
411: and nvl(pjwa_v.actual_termination_date, add_months(trunc(pjwa_v.effective_date, ''YYYY''), 12))
412: between padr.date_from (+) and nvl(padr.date_to(+), fnd_date.canonical_to_date(''i_eot''))

Line 684: per_addresses padr,

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
688: and pjwa.assignment_action_id = paa.source_action_id

Line 685: per_addresses padc

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
688: and pjwa.assignment_action_id = paa.source_action_id
689: and pjwa.assignment_id = paa.assignment_id

Line 2374: l_district_code per_addresses.town_or_city%type;

2370: l_prev_job_info pay_jp_wic_pkg.t_prev_job_info;
2371: l_housing_info pay_jp_wic_pkg.t_housing_info;
2372: l_submission_required_flag varchar2(1);
2373: --
2374: l_district_code per_addresses.town_or_city%type;
2375: l_district_code_chg boolean;
2376: l_district_code_null boolean;
2377: l_itax_organization_id number;
2378: l_itax_org_name hr_organization_information.org_information1%type;

Line 3448: per_addresses adrr,

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
3452: between asg.effective_start_date and asg.effective_end_date

Line 3449: per_addresses adrc

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
3452: between asg.effective_start_date and asg.effective_end_date
3453: and per.person_id = asg.person_id

Line 4360: per_addresses adrr,

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
4364: between asg.effective_start_date and asg.effective_end_date

Line 4361: per_addresses adrc

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
4364: between asg.effective_start_date and asg.effective_end_date
4365: and per.person_id = asg.person_id

Line 4987: l_district_code per_addresses.town_or_city%type;

4983: l_proc varchar2(80) := c_package||'del_file';
4984: --
4985: l_payroll_action_id number;
4986: --
4987: l_district_code per_addresses.town_or_city%type;
4988: l_itax_organization_id number;
4989: l_itax_org_cnt number;
4990: --
4991: l_select_clause varchar2(32767);