APPS.PER_US_IPEDS_EXP_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

Line 54: pqh_employment_category.fetch_empl_categories(p_business_group_id

50: begin
51:
52: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_reporting_date =' || p_report_date);
53: l_report_date := fnd_date.canonical_to_date(p_report_date); --to_date(p_report_date,'YYYY/MM/DD HH24:MI:SS');
54: pqh_employment_category.fetch_empl_categories(p_business_group_id
55: ,l_fr
56: ,l_ft
57: ,l_pr
58: ,l_pt);

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

75: AND fnd_date.date_to_canonical(''' || to_char(l_report_date) || ''') between pei.pei_information7 and pei.pei_information8
76: AND pei.pei_information9 IN (''04'',''05'',''06'',''07'',''12''))
77: AND peo.current_employee_flag = ''Y''
78: AND hl.lookup_code = job.job_information8
79: AND pqh_employment_category.identify_empl_category(ass.employment_category,
80: ' || l_fr || ',' || l_ft || ','
81: || l_pr ||',' || l_pt || ') IN (''FR'',''PR'')
82: AND hl.lookup_type = ''US_IPEDS_JOB_CATEGORIES''
83: AND job.job_information_category = ''US''