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_ITWB_ARCHIVE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 918: emp_ass_organization_name hr_all_organization_units.name%type,

914: emp_add_address_kana varchar2(800),
915: emp_add_phone1 per_addresses.telephone_number_1%type,
916: emp_add_phone2 per_addresses.telephone_number_2%type,
917: emp_ass_hire_date date,
918: emp_ass_organization_name hr_all_organization_units.name%type,
919: emp_ass_job_name per_jobs.name%type,
920: emp_ass_payroll_name pay_all_payrolls_f.payroll_name%type,
921: emp_ass_location_name hr_locations.location_code%type,
922: emp_si_itax_org_id number,

Line 1754: hr_all_organization_units hou

1750: from dual
1751: where not exists(
1752: select null
1753: from hr_organization_information hoi,
1754: hr_all_organization_units hou
1755: where hoi.org_information_context = 'CLASS'
1756: and hoi.org_information1 = 'JP_TAX_SWOT'
1757: and hoi.organization_id = nvl(g_itax_organization_id,hoi.organization_id)
1758: and hou.organization_id = hoi.organization_id

Line 5829: from hr_all_organization_units hou,

5825: hoi.org_information9||hoi.org_information10||hoi.org_information11 address_kana,
5826: hoi.org_information12 phone,
5827: hoiw.org_information4 serial1,
5828: hoiw.org_information5 serial2
5829: from hr_all_organization_units hou,
5830: hr_organization_information hoi,
5831: hr_organization_information hoiw
5832: where hou.organization_id = g_itax_organization_id
5833: and hoi.organization_id(+) = hou.organization_id

Line 7632: hr_all_organization_units_vl hou,

7628: and ppy.payroll_id = proc_v.payroll_id
7629: and proc_v.effective_date
7630: between ppy.effective_start_date and ppy.effective_end_date) v,
7631: per_jobs_vl pjb,
7632: hr_all_organization_units_vl hou,
7633: hr_locations_all_vl hlc,
7634: per_addresses padr,
7635: per_addresses padc
7636: where pjb.job_id (+) = v.job_id

Line 8145: hr_all_organization_units_vl hou,

8141: and ppy.payroll_id = proc_v.payroll_id
8142: and proc_v.effective_date
8143: between ppy.effective_start_date and ppy.effective_end_date) v,
8144: per_jobs_vl pjb,
8145: hr_all_organization_units_vl hou,
8146: hr_locations_all_vl hlc,
8147: per_addresses padr,
8148: per_addresses padc
8149: where pjb.job_id (+) = v.job_id

Line 8243: hr_all_organization_units_vl hou,

8239: per_addresses padr,
8240: per_addresses padc,
8241: pay_all_payrolls_f ppy,
8242: per_jobs_vl pjb,
8243: hr_all_organization_units_vl hou,
8244: hr_locations_all_vl hlc
8245: where padr.person_id (+) = v.person_id
8246: and padr.address_type (+) = 'JP_R'
8247: and nvl(v.actual_termination_date, p_effective_date)