APPS.PQH_PQIPED6_XMLP_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

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

134: WHERE peo.person_id = ass.person_id
135: AND peo.current_employee_flag = 'Y'
136: AND hl.lookup_code = job.job_information8
137: AND job.job_information8 NOT IN('1', '2', '3', '4')
138: AND pqh_employment_category.identify_empl_category(ass.employment_category, cp_fr, cp_ft, cp_pr, cp_pt) IN('FR')
139: AND ppp.change_date =
140: (SELECT MAX(change_date)
141: FROM per_pay_proposals PRO
142: WHERE ppp.assignment_id = PRO.ASSIGNMENT_ID

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

206: WHERE pei3.person_id = pei.person_id))
207: )
208: AND hl.lookup_code = job.job_information8
209: AND job.job_information8 NOT IN('1', '2', '3', '4')
210: AND pqh_employment_category.identify_empl_category(ass.employment_category, cp_fr, cp_ft, cp_pr, cp_pt) IN('FR')
211: AND ppp.change_date =
212: (SELECT MAX(change_date)
213: FROM per_pay_proposals PRO
214: WHERE ppp.assignment_id = PRO.ASSIGNMENT_ID

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

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

240: begin
241: --hr_standard.event('BEFORE REPORT');
242: LP_REPORT_DATE := to_Char(P_REPORT_DATE,'DD-MON-YYYY');
243:
244: pqh_employment_category.fetch_empl_categories(p_business_group_id,l_fr,l_ft,l_pr,l_pt);
245:
246: cp_fr := l_fr;
247: cp_ft := l_ft;
248: cp_pr := l_pr;