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 PAY_JP_SWOT_NUMBERS

Line 70: swot_number pay_jp_swot_numbers.swot_number%type,

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),
74: itax_org_name hr_organization_information.org_information1%type,

Line 71: output_file_name pay_jp_swot_numbers.output_file_name%type,

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),
74: itax_org_name hr_organization_information.org_information1%type,
75: itax_org_name_kana hr_organization_information.org_information2%type,

Line 233: output_file_name pay_jp_swot_numbers.output_file_name%type,

229: wtm_user_desc varchar2(500),
230: wtm_user_desc_kana varchar2(500),
231: spr_term_valid number,
232: --
233: output_file_name pay_jp_swot_numbers.output_file_name%type,
234: file_ind number,
235: --
236: o_form_number varchar2(3),
237: o_itax_org_serial1 hr_organization_information.org_information4%type,

Line 329: o_swot_number pay_jp_swot_numbers.swot_number%type,

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,
333: o_new_pens_ins_prem number);

Line 423: from pay_jp_swot_numbers pjsn_rep,

419: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code,
420: pjsn_rep.swot_number rep_swot_number,
421: pjsn_rep.output_file_name rep_output_file_name,
422: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
423: from pay_jp_swot_numbers pjsn_rep,
424: pay_jp_swot_numbers pjsn_act
425: where pjsn_rep.organization_id = pjsn_act.organization_id
426: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v';
427: --

Line 424: pay_jp_swot_numbers pjsn_act

420: pjsn_rep.swot_number rep_swot_number,
421: pjsn_rep.output_file_name rep_output_file_name,
422: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
423: from pay_jp_swot_numbers pjsn_rep,
424: pay_jp_swot_numbers pjsn_act
425: where pjsn_rep.organization_id = pjsn_act.organization_id
426: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v';
427: --
428: c_proc_ass_where_clause varchar2(32767)

Line 476: from pay_jp_swot_numbers pjsn_rep,

472: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code,
473: pjsn_rep.swot_number rep_swot_number,
474: pjsn_rep.output_file_name rep_output_file_name,
475: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
476: from pay_jp_swot_numbers pjsn_rep,
477: pay_jp_swot_numbers pjsn_act
478: where pjsn_rep.organization_id = pjsn_act.organization_id
479: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v';
480: --

Line 477: pay_jp_swot_numbers pjsn_act

473: pjsn_rep.swot_number rep_swot_number,
474: pjsn_rep.output_file_name rep_output_file_name,
475: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
476: from pay_jp_swot_numbers pjsn_rep,
477: pay_jp_swot_numbers pjsn_act
478: where pjsn_rep.organization_id = pjsn_act.organization_id
479: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v';
480: --
481: c_proc_arch_where_clause varchar2(32767)

Line 714: from pay_jp_swot_numbers pjsn_rep,

710: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code,
711: pjsn_rep.swot_number rep_swot_number,
712: pjsn_rep.output_file_name rep_output_file_name,
713: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
714: from pay_jp_swot_numbers pjsn_rep,
715: pay_jp_swot_numbers pjsn_act
716: where pjsn_rep.organization_id = pjsn_act.organization_id
717: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v,
718: hr_organization_information hoi,

Line 715: pay_jp_swot_numbers pjsn_act

711: pjsn_rep.swot_number rep_swot_number,
712: pjsn_rep.output_file_name rep_output_file_name,
713: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
714: from pay_jp_swot_numbers pjsn_rep,
715: pay_jp_swot_numbers pjsn_act
716: where pjsn_rep.organization_id = pjsn_act.organization_id
717: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v,
718: hr_organization_information hoi,
719: hr_organization_information hoiw';

Line 879: from pay_jp_swot_numbers pjsn_rep,

875: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code,
876: pjsn_rep.swot_number rep_swot_number,
877: pjsn_rep.output_file_name rep_output_file_name,
878: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
879: from pay_jp_swot_numbers pjsn_rep,
880: pay_jp_swot_numbers pjsn_act
881: where pjsn_rep.organization_id = pjsn_act.organization_id
882: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v';
883: --

Line 880: pay_jp_swot_numbers pjsn_act

876: pjsn_rep.swot_number rep_swot_number,
877: pjsn_rep.output_file_name rep_output_file_name,
878: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
879: from pay_jp_swot_numbers pjsn_rep,
880: pay_jp_swot_numbers pjsn_act
881: where pjsn_rep.organization_id = pjsn_act.organization_id
882: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v';
883: --
884: c_data_arch_where_clause varchar2(32767)

Line 1058: from pay_jp_swot_numbers pjsn_rep,

1054: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code,
1055: pjsn_rep.swot_number rep_swot_number,
1056: pjsn_rep.output_file_name rep_output_file_name,
1057: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
1058: from pay_jp_swot_numbers pjsn_rep,
1059: pay_jp_swot_numbers pjsn_act
1060: where pjsn_rep.organization_id = pjsn_act.organization_id
1061: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v';
1062: --

Line 1059: pay_jp_swot_numbers pjsn_act

1055: pjsn_rep.swot_number rep_swot_number,
1056: pjsn_rep.output_file_name rep_output_file_name,
1057: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
1058: from pay_jp_swot_numbers pjsn_rep,
1059: pay_jp_swot_numbers pjsn_act
1060: where pjsn_rep.organization_id = pjsn_act.organization_id
1061: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v';
1062: --
1063: c_data_arch_where_clause_2009 varchar2(32767)

Line 1234: from pay_jp_swot_numbers pjsn_rep,

1230: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code,
1231: pjsn_rep.swot_number rep_swot_number,
1232: pjsn_rep.output_file_name rep_output_file_name,
1233: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
1234: from pay_jp_swot_numbers pjsn_rep,
1235: pay_jp_swot_numbers pjsn_act
1236: where pjsn_rep.organization_id = pjsn_act.organization_id
1237: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v';
1238: --

Line 1235: pay_jp_swot_numbers pjsn_act

1231: pjsn_rep.swot_number rep_swot_number,
1232: pjsn_rep.output_file_name rep_output_file_name,
1233: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
1234: from pay_jp_swot_numbers pjsn_rep,
1235: pay_jp_swot_numbers pjsn_act
1236: where pjsn_rep.organization_id = pjsn_act.organization_id
1237: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v';
1238: --
1239: c_data_arch_where_clause_2011 varchar2(32767)

Line 1413: from pay_jp_swot_numbers pjsn_rep,

1409: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code,
1410: pjsn_rep.swot_number rep_swot_number,
1411: pjsn_rep.output_file_name rep_output_file_name,
1412: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
1413: from pay_jp_swot_numbers pjsn_rep,
1414: pay_jp_swot_numbers pjsn_act
1415: where pjsn_rep.organization_id = pjsn_act.organization_id
1416: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v';
1417: --

Line 1414: pay_jp_swot_numbers pjsn_act

1410: pjsn_rep.swot_number rep_swot_number,
1411: pjsn_rep.output_file_name rep_output_file_name,
1412: pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
1413: from pay_jp_swot_numbers pjsn_rep,
1414: pay_jp_swot_numbers pjsn_act
1415: where pjsn_rep.organization_id = pjsn_act.organization_id
1416: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v';
1417: --
1418: c_data_arch_where_clause_2012 varchar2(32767)