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.HXC_PREFERENCE_EVALUATION dependencies on HR_ALL_ORGANIZATION_UNITS

Line 206: from hr_all_organization_units

202: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
203: hrr.eligibility_criteria_type)
204: union
205: select organization_id
206: from hr_all_organization_units
207: where organization_id = pa.organization_id))
208: AND hrr.eligibility_criteria_type = 'ROLLUP' )
209: );
210:

Line 1518: from hr_all_organization_units

1514: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
1515: hrr.eligibility_criteria_type)
1516: union
1517: select organization_id
1518: from hr_all_organization_units
1519: where organization_id = pa.organization_id))
1520: AND hrr.eligibility_criteria_type = 'ROLLUP' )
1521: OR (
1522: hrr.eligibility_criteria_type = 'ALL_PEOPLE'));

Line 1578: from hr_all_organization_units

1574: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
1575: hrr.eligibility_criteria_type)
1576: union
1577: select organization_id
1578: from hr_all_organization_units
1579: where organization_id = pa.organization_id))
1580: AND hrr.eligibility_criteria_type = 'ROLLUP' )
1581: OR (
1582: hrr.eligibility_criteria_type = 'ALL_PEOPLE'));

Line 3154: from hr_all_organization_units

3150: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,''-'',1,1)-1)),
3151: hrr.eligibility_criteria_type)
3152: union
3153: select organization_id
3154: from hr_all_organization_units
3155: where organization_id = pa.organization_id))
3156: AND hrr.eligibility_criteria_type = ''ROLLUP'' )
3157: OR ( HXC_PREFERENCE_EVALUATION.check_number(hrr.eligibility_criteria_id)
3158: in ( SELECT typ.person_type_id