APPS.PQH_PQIPED6_XMLP_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

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 170: AND pqh_employment_category.identify_empl_category(ass.employment_category, cp_fr, cp_ft, cp_pr, cp_pt) IN('FR')

166: WHERE peo.person_id = ass.person_id
167: AND peo.current_employee_flag = 'Y'
168: AND hl.lookup_code = job.job_information8
169: AND job.job_information8 NOT IN('1', '2', '3', '4')
170: AND pqh_employment_category.identify_empl_category(ass.employment_category, cp_fr, cp_ft, cp_pr, cp_pt) IN('FR')
171: AND ppp.change_date =
172: (SELECT MAX(change_date)
173: FROM per_pay_proposals PRO
174: WHERE ppp.assignment_id = PRO.ASSIGNMENT_ID

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 244: AND pqh_employment_category.identify_empl_category(ass.employment_category, cp_fr, cp_ft, cp_pr, cp_pt) IN('FR')

240: WHERE pei3.person_id = pei.person_id))
241: )
242: AND hl.lookup_code = job.job_information8
243: AND job.job_information8 NOT IN('1', '2', '3', '4')
244: AND pqh_employment_category.identify_empl_category(ass.employment_category, cp_fr, cp_ft, cp_pr, cp_pt) IN('FR')
245: AND ppp.change_date =
246: (SELECT MAX(change_date)
247: FROM per_pay_proposals PRO
248: WHERE ppp.assignment_id = PRO.ASSIGNMENT_ID

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

Line 280: pqh_employment_category.fetch_empl_categories(p_business_group_id,l_fr,l_ft,l_pr,l_pt);

276: begin
277: --hr_standard.event('BEFORE REPORT');
278: LP_REPORT_DATE := to_Char(P_REPORT_DATE,'DD-MON-YYYY');
279:
280: pqh_employment_category.fetch_empl_categories(p_business_group_id,l_fr,l_ft,l_pr,l_pt);
281:
282: cp_fr := l_fr;
283: cp_ft := l_ft;
284: cp_pr := l_pr;