APPS.PER_US_EEO5_EXP_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

Line 67: pqh_employment_category.fetch_empl_categories(p_business_group_id

63: l_pr VARCHAR2(2000);
64: l_pt VARCHAR2(2000);
65: begin
66: l_report_date := to_date ('30-09'|| p_reporting_year,'dd-mm-yyyy');
67: pqh_employment_category.fetch_empl_categories(p_business_group_id
68: ,l_fr
69: ,l_ft
70: ,l_pr
71: ,l_pt);

Line 87: AND pqh_employment_category.identify_empl_category(ass.employment_category,

83: hr_lookups hl
84: WHERE peo.person_id = ass.person_id
85: AND peo.current_employee_flag = ''Y''
86: AND hl.lookup_code = job.job_information1
87: AND pqh_employment_category.identify_empl_category(ass.employment_category,
88: ' || l_fr || ',' || l_ft || ','
89: || l_pr ||',' || l_pt || ') IN (''FR'',''PR'')
90: AND hl.lookup_type = ''US_EEO5_JOB_CATEGORIES''
91: AND job.job_information_category = ''US''

Line 129: AND pqh_employment_category.identify_empl_category(ass.employment_category,

125: per_people_extra_info ppei
126: WHERE peo.person_id = ass.person_id
127: AND peo.current_employee_flag = ''Y''
128: AND hl.lookup_code = job.job_information1
129: AND pqh_employment_category.identify_empl_category(ass.employment_category,
130: ' || l_fr || ',' || l_ft || ','
131: || l_pr ||',' || l_pt || ') IN (''FR'',''PR'')
132: AND hl.lookup_type = ''US_EEO5_JOB_CATEGORIES''
133: AND job.job_information_category = ''US''

Line 208: AND pqh_employment_category.identify_empl_category(ass.employment_category,

204: AND ass.organization_id IN (
205: SELECT organization_id
206: FROM hr_all_organization_units
207: WHERE business_group_id = '||p_business_group_id || ')
208: AND pqh_employment_category.identify_empl_category(ass.employment_category,
209: ' || l_fr || ',' || l_ft || ','
210: || l_pr ||',' || l_pt || ') NOT IN (''FR'',''PR'')';
211:
212: /* Commneted for bug#11736960 starts

Line 226: AND pqh_employment_category.identify_empl_category(ass.employment_category,

222: hr_lookups hl
223: WHERE peo.person_id = ass.person_id
224: AND peo.current_employee_flag = ''Y''
225: AND hl.lookup_code = job.job_information1
226: AND pqh_employment_category.identify_empl_category(ass.employment_category,
227: ' || l_fr || ',' || l_ft || ','
228: || l_pr ||',' || l_pt || ') IN (''FR'',''PR'')
229: AND hl.lookup_type = ''US_EEO5_JOB_CATEGORIES''
230: AND job.job_information_category = ''US''