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.PQH_PQIPED6_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 193: FROM hr_all_organization_units org

189: AND ass.job_id = job.job_id
190: AND ass.assignment_type = 'E'
191: AND ass.organization_id IN
192: (SELECT org.organization_id
193: FROM hr_all_organization_units org
194: WHERE business_group_id = p_business_group_id
195: AND pqh_inst_type_pkg.get_inst_type(org.organization_id) = 'NON-MED')
196: GROUP BY
197: pqh_salary_class_intervals_pkg.get_job_sal_interval(pqh_employment_category.identify_empl_category(ass.employment_category,

Line 267: FROM hr_all_organization_units org

263: AND ass.job_id = job.job_id
264: AND ass.assignment_type = 'E'
265: AND ass.organization_id IN
266: (SELECT org.organization_id
267: FROM hr_all_organization_units org
268: WHERE business_group_id = p_business_group_id
269: AND pqh_inst_type_pkg.get_inst_type(org.organization_id) = 'NON-MED')
270: AND pqh_salary_class_intervals_pkg.get_job_sal_interval(pqh_employment_category.identify_empl_category(ass.employment_category, cp_fr, cp_ft, cp_pr, cp_pt), hl.lookup_code,
271: nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor) = c_salary_range