APPS.PQH_PQIPED6_XMLP_PKG dependencies on PQH_SALARY_CLASS_INTERVALS_PKG

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

107: l_tot_wmen NUMBER(10) := 0;
108: CURSOR get_line_counts IS
109: SELECT 1 line,
110: hl.lookup_code job_category_name,
111: pqh_salary_class_intervals_pkg.get_job_sal_interval(pqh_employment_category.identify_empl_category(ass.employment_category,
112: cp_fr, cp_ft, cp_pr, cp_pt), hl.lookup_code, nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor) salary_range,
113: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'M', 1, NULL), NULL)) nrmen,
114: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'F', 1, NULL), NULL)) nrwmen,
115: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'M', 1, NULL), NULL)))) bnhmen,

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

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;
168: CURSOR get_line_tmraces_counts(c_salary_range IN VARCHAR2, c_lookup_code IN NUMBER) IS
169: SELECT COUNT(decode(pei.pei_information5, '2', decode(peo.sex, 'M', 1, NULL), NULL)) bnhmen,

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

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:
240: begin