APPS.PQH_PQIPED6_XMLP_PKG dependencies on PQH_SALARY_CLASS_INTERVALS_PKG

Line 116: pqh_salary_class_intervals_pkg.get_job_sal_interval(pqh_employment_category.identify_empl_category(ass.employment_category,

112:
113: CURSOR get_line_counts IS
114: SELECT 1 line,
115: hl.lookup_code job_category_name,
116: pqh_salary_class_intervals_pkg.get_job_sal_interval(pqh_employment_category.identify_empl_category(ass.employment_category,
117: cp_fr, cp_ft, cp_pr, cp_pt), hl.lookup_code, nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor) salary_range,
118: -- Added for bug#11736960
119: COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 0, decode(peo.sex, 'M', 1, NULL), NULL)) nrmen,
120: COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 0, decode(peo.sex, 'F', 1, NULL), NULL)) nrwmen,

Line 197: pqh_salary_class_intervals_pkg.get_job_sal_interval(pqh_employment_category.identify_empl_category(ass.employment_category,

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;
200: /* Commenting for the bug#7033011
201:

Line 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,

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:
274: */