APPS.PQH_PQIPED6_XMLP_PKG dependencies on PQH_INST_TYPE_PKG

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

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

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

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