DBA Data[Home] [Help]

APPS.PQH_PQIPED6_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 161: FROM hr_all_organization_units org

157: AND ass.job_id = job.job_id
158: AND ass.assignment_type = 'E'
159: AND ass.organization_id IN
160: (SELECT org.organization_id
161: FROM hr_all_organization_units org
162: WHERE business_group_id = p_business_group_id
163: AND pqh_inst_type_pkg.get_inst_type(org.organization_id) = 'NON-MED')
164: GROUP BY
165: pqh_salary_class_intervals_pkg.get_job_sal_interval(pqh_employment_category.identify_empl_category(ass.employment_category,

Line 233: FROM hr_all_organization_units org

229: AND ass.job_id = job.job_id
230: AND ass.assignment_type = 'E'
231: AND ass.organization_id IN
232: (SELECT org.organization_id
233: FROM hr_all_organization_units org
234: WHERE business_group_id = p_business_group_id
235: AND pqh_inst_type_pkg.get_inst_type(org.organization_id) = 'NON-MED')
236: 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,
237: nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor) = c_salary_range