eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_US_IPEDS_EXP_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

Line 74: pqh_employment_category.fetch_empl_categories(p_business_group_id

70: begin
71:
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_reporting_date =' || p_report_date);
73: l_report_date := fnd_date.canonical_to_date(p_report_date); --to_date(p_report_date,'YYYY/MM/DD HH24:MI:SS');
74: pqh_employment_category.fetch_empl_categories(p_business_group_id
75: ,l_fr
76: ,l_ft
77: ,l_pr
78: ,l_pt);

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

97: AND fnd_date.date_to_canonical(''' || to_char(l_report_date) || ''') between pei.pei_information7 and pei.pei_information8
98: AND pei.pei_information9 IN (''04'',''05'',''06'',''07'',''12''))
99: AND peo.current_employee_flag = ''Y''
100: AND hl.lookup_code = job.job_information8
101: AND pqh_employment_category.identify_empl_category(ass.employment_category,
102: ' || l_fr || ',' || l_ft || ','
103: || l_pr ||',' || l_pt || ') IN (''FR'',''PR'')
104: AND hl.lookup_type = ''US_IPEDS_JOB_CATEGORIES''
105: AND job.job_information_category = ''US''

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

143: AND fnd_date.date_to_canonical(''' || to_char(l_report_date) || ''') between pei.pei_information7 and pei.pei_information8
144: AND pei.pei_information9 IN (''04'',''05'',''06'',''07'',''12''))
145: AND peo.current_employee_flag = ''Y''
146: AND hl.lookup_code = job.job_information8
147: AND pqh_employment_category.identify_empl_category(ass.employment_category,
148: ' || l_fr || ',' || l_ft || ','
149: || l_pr ||',' || l_pt || ') IN (''FR'',''PR'')
150: AND hl.lookup_type = ''US_IPEDS_JOB_CATEGORIES''
151: AND hl.enabled_flag = ''Y''

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

205: AND fnd_date.date_to_canonical(''' || to_char(l_report_date) || ''') between pei.pei_information7 and pei.pei_information8
206: AND pei.pei_information9 IN (''04'',''05'',''06'',''07'',''12''))
207: AND peo.current_employee_flag = ''Y''
208: AND hl.lookup_code = job.job_information8
209: AND pqh_employment_category.identify_empl_category(ass.employment_category,
210: ' || l_fr || ',' || l_ft || ','
211: || l_pr ||',' || l_pt || ') IN (''FR'',''PR'')
212: AND hl.lookup_type = ''US_IPEDS_JOB_CATEGORIES''
213: AND hl.enabled_flag = ''Y''

Line 412: AND pqh_employment_category.identify_empl_category(asg.employment_category,

408: AND peo.person_id = ppet.person_id
409: AND ppet.information_type = ''PQH_TENURE_STATUS''
410: AND ppet.pei_information1 IN (''03'',''05'')
411: AND peo.current_employee_flag = ''Y''
412: AND pqh_employment_category.identify_empl_category(asg.employment_category,
413: ' || l_fr || ',' || l_ft || ',' || l_pr ||',' || l_pt || ') IS NOT NULL
414: AND job.business_group_id = ' || p_business_group_id || '
415: AND job.job_information_category = ''US''
416: AND job.job_information8 IS NOT NULL