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_LOCATIONS_ALL_VL

Line 7633: hr_locations_all_vl hlc,

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
7637: and v.effective_date

Line 8146: hr_locations_all_vl hlc,

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
8150: and v.effective_date

Line 8244: hr_locations_all_vl hlc

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)
8248: between padr.date_from (+) and nvl(padr.date_to(+), hr_api.g_eot)