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:
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'));
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'));
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