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_EEO_MAG_REPORT dependencies on PER_US_HR_UTILITY_PKG

Line 2026: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlfemale,

2022:
2023: CURSOR c_female_details IS
2024: SELECT
2025: /* Added for fix of fix of #12616269 */
2026: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlfemale,
2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,
2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,

Line 2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,

2023: CURSOR c_female_details IS
2024: SELECT
2025: /* Added for fix of fix of #12616269 */
2026: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlfemale,
2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,
2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,
2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,

Line 2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,

2024: SELECT
2025: /* Added for fix of fix of #12616269 */
2026: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlfemale,
2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,
2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,
2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,
2032: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesfemale,

Line 2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,

2025: /* Added for fix of fix of #12616269 */
2026: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlfemale,
2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,
2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,
2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,
2032: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesfemale,
2033: /* Added for fix of fix of #12616269 */

Line 2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,

2026: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlfemale,
2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,
2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,
2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,
2032: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesfemale,
2033: /* Added for fix of fix of #12616269 */
2034: /* Commented for fix of #12616269

Line 2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,

2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,
2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,
2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,
2032: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesfemale,
2033: /* Added for fix of fix of #12616269 */
2034: /* Commented for fix of #12616269
2035: COUNT(DECODE(peo.per_information1,'3',1)) c_hlfemale,

Line 2032: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesfemale,

2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,
2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,
2032: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesfemale,
2033: /* Added for fix of fix of #12616269 */
2034: /* Commented for fix of #12616269
2035: COUNT(DECODE(peo.per_information1,'3',1)) c_hlfemale,
2036: COUNT(DECODE(peo.per_information1,'1',1)) c_wfemale,

Line 2131: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlmale,

2127:
2128: CURSOR c_male_details IS
2129: SELECT
2130: /* Added for fix of fix of #12616269 */
2131: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlmale,
2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,
2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,

Line 2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,

2128: CURSOR c_male_details IS
2129: SELECT
2130: /* Added for fix of fix of #12616269 */
2131: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlmale,
2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,
2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,
2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,

Line 2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,

2129: SELECT
2130: /* Added for fix of fix of #12616269 */
2131: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlmale,
2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,
2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,
2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,
2137: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesmale,

Line 2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,

2130: /* Added for fix of fix of #12616269 */
2131: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlmale,
2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,
2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,
2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,
2137: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesmale,
2138: /* Added for fix of fix of #12616269 */

Line 2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,

2131: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlmale,
2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,
2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,
2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,
2137: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesmale,
2138: /* Added for fix of fix of #12616269 */
2139: /* Commented for fix of #12616269

Line 2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,

2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,
2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,
2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,
2137: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesmale,
2138: /* Added for fix of fix of #12616269 */
2139: /* Commented for fix of #12616269
2140: COUNT(DECODE(peo.per_information1,'3',1)) c_hlmale,

Line 2137: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesmale,

2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,
2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,
2137: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesmale,
2138: /* Added for fix of fix of #12616269 */
2139: /* Commented for fix of #12616269
2140: COUNT(DECODE(peo.per_information1,'3',1)) c_hlmale,
2141: COUNT(DECODE(peo.per_information1,'1',1)) c_wmale,

Line 2243: -- Modified to add function call per_us_hr_utility_pkg.derive_alien_ethnic_origin instead of peo.per_information1

2239: per_jobs_vl job,
2240: hr_lookups hrl,
2241: per_gen_hierarchy_nodes pgn_est
2242: WHERE peo.person_id = ass.person_id
2243: -- Modified to add function call per_us_hr_utility_pkg.derive_alien_ethnic_origin instead of peo.per_information1
2244: -- AND peo.per_information1 IN ('1','2','3','4','5','6','13') --BUG4410003
2245: AND per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id) IN ('1','2','3','4','5','6','13')
2246: AND peo.per_information_category = 'US'
2247: AND job.job_information_category = 'US'

Line 2245: AND per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id) IN ('1','2','3','4','5','6','13')

2241: per_gen_hierarchy_nodes pgn_est
2242: WHERE peo.person_id = ass.person_id
2243: -- Modified to add function call per_us_hr_utility_pkg.derive_alien_ethnic_origin instead of peo.per_information1
2244: -- AND peo.per_information1 IN ('1','2','3','4','5','6','13') --BUG4410003
2245: AND per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id) IN ('1','2','3','4','5','6','13')
2246: AND peo.per_information_category = 'US'
2247: AND job.job_information_category = 'US'
2248: AND p_start_date <= nvl(job.date_to,p_start_date)
2249: AND p_end_date >= job.date_from