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_VL

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)