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 HR_ORGANIZATION_INFORMATION

Line 74: itax_org_name hr_organization_information.org_information1%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,
76: itax_org_phone hr_organization_information.org_information12%type,
77: itax_org_serial1 hr_organization_information.org_information4%type,
78: itax_org_serial2 hr_organization_information.org_information5%type,

Line 75: itax_org_name_kana hr_organization_information.org_information2%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,
76: itax_org_phone hr_organization_information.org_information12%type,
77: itax_org_serial1 hr_organization_information.org_information4%type,
78: itax_org_serial2 hr_organization_information.org_information5%type,
79: taxable_income number,

Line 76: itax_org_phone hr_organization_information.org_information12%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,
76: itax_org_phone hr_organization_information.org_information12%type,
77: itax_org_serial1 hr_organization_information.org_information4%type,
78: itax_org_serial2 hr_organization_information.org_information5%type,
79: taxable_income number,
80: net_taxable_income number,

Line 77: itax_org_serial1 hr_organization_information.org_information4%type,

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,
76: itax_org_phone hr_organization_information.org_information12%type,
77: itax_org_serial1 hr_organization_information.org_information4%type,
78: itax_org_serial2 hr_organization_information.org_information5%type,
79: taxable_income number,
80: net_taxable_income number,
81: total_income_exempt number,

Line 78: itax_org_serial2 hr_organization_information.org_information5%type,

74: itax_org_name hr_organization_information.org_information1%type,
75: itax_org_name_kana hr_organization_information.org_information2%type,
76: itax_org_phone hr_organization_information.org_information12%type,
77: itax_org_serial1 hr_organization_information.org_information4%type,
78: itax_org_serial2 hr_organization_information.org_information5%type,
79: taxable_income number,
80: net_taxable_income number,
81: total_income_exempt number,
82: withholding_itax number,

Line 190: itax_org_name hr_organization_information.org_information1%type,

186: actual_termination_date date,
187: date_start date,
188: itax_org_address varchar2(500),
189: itax_org_address_kana varchar2(500),
190: itax_org_name hr_organization_information.org_information1%type,
191: itax_org_name_kana hr_organization_information.org_information2%type,
192: dependent_spouse_exists_kou pay_action_information.action_information1%type,
193: dependent_spouse_no_exist_kou pay_action_information.action_information2%type,
194: dependent_spouse_exists_otsu pay_action_information.action_information3%type,

Line 191: itax_org_name_kana hr_organization_information.org_information2%type,

187: date_start date,
188: itax_org_address varchar2(500),
189: itax_org_address_kana varchar2(500),
190: itax_org_name hr_organization_information.org_information1%type,
191: itax_org_name_kana hr_organization_information.org_information2%type,
192: dependent_spouse_exists_kou pay_action_information.action_information1%type,
193: dependent_spouse_no_exist_kou pay_action_information.action_information2%type,
194: dependent_spouse_exists_otsu pay_action_information.action_information3%type,
195: dependent_spouse_no_exist_otsu pay_action_information.action_information4%type,

Line 237: o_itax_org_serial1 hr_organization_information.org_information4%type,

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,
238: o_itax_org_cnt number,
239: o_itax_org_address varchar2(500),
240: o_itax_org_name hr_organization_information.org_information1%type,
241: o_itax_org_phone hr_organization_information.org_information12%type,

Line 240: o_itax_org_name hr_organization_information.org_information1%type,

236: o_form_number varchar2(3),
237: o_itax_org_serial1 hr_organization_information.org_information4%type,
238: o_itax_org_cnt number,
239: o_itax_org_address varchar2(500),
240: o_itax_org_name hr_organization_information.org_information1%type,
241: o_itax_org_phone hr_organization_information.org_information12%type,
242: o_itax_org_serial2 hr_organization_information.org_information5%type,
243: o_itax_hq_address varchar2(500),
244: o_itax_hq_name hr_organization_information.org_information1%type,

Line 241: o_itax_org_phone hr_organization_information.org_information12%type,

237: o_itax_org_serial1 hr_organization_information.org_information4%type,
238: o_itax_org_cnt number,
239: o_itax_org_address varchar2(500),
240: o_itax_org_name hr_organization_information.org_information1%type,
241: o_itax_org_phone hr_organization_information.org_information12%type,
242: o_itax_org_serial2 hr_organization_information.org_information5%type,
243: o_itax_hq_address varchar2(500),
244: o_itax_hq_name hr_organization_information.org_information1%type,
245: o_amend_flag varchar2(1),

Line 242: o_itax_org_serial2 hr_organization_information.org_information5%type,

238: o_itax_org_cnt number,
239: o_itax_org_address varchar2(500),
240: o_itax_org_name hr_organization_information.org_information1%type,
241: o_itax_org_phone hr_organization_information.org_information12%type,
242: o_itax_org_serial2 hr_organization_information.org_information5%type,
243: o_itax_hq_address varchar2(500),
244: o_itax_hq_name hr_organization_information.org_information1%type,
245: o_amend_flag varchar2(1),
246: o_target_yy varchar2(2),

Line 244: o_itax_hq_name hr_organization_information.org_information1%type,

240: o_itax_org_name hr_organization_information.org_information1%type,
241: o_itax_org_phone hr_organization_information.org_information12%type,
242: o_itax_org_serial2 hr_organization_information.org_information5%type,
243: o_itax_hq_address varchar2(500),
244: o_itax_hq_name hr_organization_information.org_information1%type,
245: o_amend_flag varchar2(1),
246: o_target_yy varchar2(2),
247: o_address varchar2(800),
248: o_address_jp varchar2(1),

Line 718: hr_organization_information hoi,

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';
720: --
721: c_data_ass_where_clause varchar2(32767)
722: := 'pjsn_v.organization_id (+) = wic_v.itax_organization_id

Line 719: hr_organization_information hoiw';

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';
720: --
721: c_data_ass_where_clause varchar2(32767)
722: := 'pjsn_v.organization_id (+) = wic_v.itax_organization_id
723: and substrb(pjsn_v.act_district_code(+),1,5) = wic_v.town_or_city

Line 1621: from hr_organization_information hoi,

1617: select 'Y'
1618: from dual
1619: where not exists(
1620: select null
1621: from hr_organization_information hoi,
1622: hr_all_organization_units hou
1623: where hoi.org_information_context = 'CLASS'
1624: and hoi.org_information1 = 'JP_TAX_SWOT'
1625: and hoi.organization_id = nvl(g_organization_id,hoi.organization_id)

Line 1688: hr_organization_information hoi

1684: cursor csr_bg_itax_dpnt_ref_type
1685: is
1686: select nvl(hoi.org_information2,'CTR_EE')
1687: from /* Business Group details */
1688: hr_organization_information hoi
1689: where hoi.organization_id = g_business_group_id
1690: and hoi.org_information_context = 'JP_BUSINESS_GROUP_INFO';
1691: --
1692: cursor csr_file_dir

Line 2378: l_itax_org_name hr_organization_information.org_information1%type;

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;
2379: l_itax_org_address varchar2(500);
2380: l_itax_org_cnt number;
2381: l_emp_cnt number;
2382: l_term_emp_cnt number;

Line 2405: itax_org_name hr_organization_information.org_information1%type,

2401: --
2402: l_delimiter varchar2(1);
2403: --
2404: type t_itax_org_kana_rec is record(
2405: itax_org_name hr_organization_information.org_information1%type,
2406: itax_org_address varchar2(500));
2407: type t_itax_org_kana_tbl is table of t_itax_org_kana_rec index by binary_integer;
2408: l_itax_org_kana_tbl t_itax_org_kana_tbl;
2409: --

Line 2422: from hr_organization_information hoi

2418: cursor csr_itax_org_kana
2419: is
2420: select hoi.org_information2 itax_org_name_kana,
2421: hoi.org_information9||hoi.org_information10||hoi.org_information11 itax_org_address_kana
2422: from hr_organization_information hoi
2423: where hoi.organization_id = p_itax_organization_id
2424: and hoi.org_information_context = 'JP_TAX_SWOT_INFO';
2425: --
2426: begin