APPS.PQH_PQIPED6_XMLP_PKG dependencies on PQH_INST_TYPE_PKG

Line 195: AND pqh_inst_type_pkg.get_inst_type(org.organization_id) = 'NON-MED')

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,
198: cp_fr, cp_ft, cp_pr, cp_pt), hl.lookup_code, nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor),
199: hl.lookup_code;

Line 269: AND pqh_inst_type_pkg.get_inst_type(org.organization_id) = 'NON-MED')

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
272: AND hl.lookup_code = c_lookup_code;
273: