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_EEO4_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

Line 61: 115.16 115.17 getting from the API 'pqh.employment_category.fetch_empl_categories'

57: blank or whose ethnic origin is 'Two or more races' and
58: additional ethnic category is blank.
59: 28-AUG-2009 lbodired 115.14 8812609 Modified the API 'populate_ft_emp_data' to correct the salary ranges
60: 18-SEP-2009 lbodired 115.15 7218995 Replaced the hard coded employee categories with the categories
61: 115.16 115.17 getting from the API 'pqh.employment_category.fetch_empl_categories'
62: 20-APR-2011 nvelaga 115.18 11736960 Modified the package to support the changes to Ethnic Origin Data capture.
63: 115.19 Modified g_select_clause to use new package function
64: per_us_hr_utility_pkg.derive_single_race. This deals with people of
65: Two or More race also.

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

671:
672: -- write Header line
673:
674: -- Fetch the list of employment categories
675: pqh_employment_category.fetch_empl_categories(p_business_group_id, l_fr, l_ft, l_pr, l_pt);
676:
677: -- Added for bug 7218995
678: g_fp_regulars := replace(replace(l_fr,'''',''''),',',''',''');
679: g_fp_temps := replace(replace(l_ft,'''',''''),',',''',''')||',' ||replace(replace(l_pt,'''',''''),',',''',''') ||',' ||replace(replace(l_pr,'''',''''),',',''',''');