APPS.PER_US_EEO5_EXP_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

Line 52: pqh_employment_category.fetch_empl_categories(p_business_group_id

48: l_pr VARCHAR2(2000);
49: l_pt VARCHAR2(2000);
50: begin
51: l_report_date := to_date ('30-09'|| p_reporting_year,'dd-mm-yyyy');
52: pqh_employment_category.fetch_empl_categories(p_business_group_id
53: ,l_fr
54: ,l_ft
55: ,l_pr
56: ,l_pt);

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

67: hr_lookups hl
68: WHERE peo.person_id = ass.person_id
69: AND peo.current_employee_flag = ''Y''
70: AND hl.lookup_code = job.job_information1
71: AND pqh_employment_category.identify_empl_category(ass.employment_category,
72: ' || l_fr || ',' || l_ft || ','
73: || l_pr ||',' || l_pt || ') IN (''FR'',''PR'')
74: AND hl.lookup_type = ''US_EEO5_JOB_CATEGORIES''
75: AND job.job_information_category = ''US''