3435: ' AND USAGE.EFFECTIVE_END_DATE >= FND_PROFILE.VALUE(''OTL_TK_START_DATE''))) '||
3436: ' AND (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NULL '||
3437: ' OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL '||
3438: ' AND FND_PROFILE.VALUE(''OTL_TK_START_DATE'') <= DECODE(ELEMENT.POST_TERMINATION_RULE, '||
3439: ' ''L'', SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE, '||
3440: ' ''F'', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE, '||
3441: ' hr_general.end_of_time), '||
3442: ' SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))) ';
3443:
3518: ' AND (ELEMENT.PROCESSING_TYPE = ''R'' OR ASGT.PAYROLL_ID IS NOT NULL) '||
3519: ' AND (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NULL '||
3520: ' OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL '||
3521: ' AND FND_PROFILE.VALUE(''OTL_TK_START_DATE'') <= DECODE(ELEMENT.POST_TERMINATION_RULE, '||
3522: ' ''L'', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE, hr_general.end_of_time),'||
3523: ' ''F'', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE, '||
3524: ' hr_general.end_of_time), '||
3525: ' SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))) ';
3526: ELSE
3782: -- format.
3783: -- * Check in the associative array for value set formats if
3784: -- the data type exists.
3785: -- * If not, find that out and store it.
3786: -- * If the format is X ( based on FIELD_TYPE lookup ) it is a standard
3787: -- date format, so convert it to canonical date.
3788: -- * If the format is N, it is a standard number, convert to canonical number.
3789:
3790: IF p_alias_type = 'VALUE_SET_NONE'
3784: -- the data type exists.
3785: -- * If not, find that out and store it.
3786: -- * If the format is X ( based on FIELD_TYPE lookup ) it is a standard
3787: -- date format, so convert it to canonical date.
3788: -- * If the format is N, it is a standard number, convert to canonical number.
3789:
3790: IF p_alias_type = 'VALUE_SET_NONE'
3791: THEN
3792: IF NOT hxc_alias_translator.g_vset_fmt.EXISTS(TO_CHAR(l_alias_val_att_to_match(l_alias_val_att_to_match.FIRST).reference_object))