APPS.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on HR_GENERAL

Line 910: and date_to = hr_general.end_of_time;

906: cursor c_start_time(p_id in number) is
907: select start_time,stop_time
908: from hxc_time_building_blocks
909: where time_building_block_id = p_id
910: and date_to = hr_general.end_of_time;
911:
912: l_pref_table HXC_PREFERENCE_EVALUATION.T_PREF_TABLE;
913:
914: BEGIN

Line 2381: and nvl(hav.date_to,hr_general.end_of_time) >=p_start_date

2377: and had.alias_definition_id = p_alias_definition_id
2378: and havt.language = USERENV('LANG')
2379: and havt.alias_value_id = hav.alias_value_id
2380: and hav.date_from <= p_end_date
2381: and nvl(hav.date_to,hr_general.end_of_time) >=p_start_date
2382: and exists (
2383: select 'x'
2384: from PAY_ELEMENT_TYPES_F ELEMENT,
2385: PAY_ELEMENT_CLASSIFICATIONS CLASSIFICATION,

Line 2441: 'L', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE,hr_general.end_of_time),

2437: AND (ELEMENT.PROCESSING_TYPE = 'R' OR ASGT.PAYROLL_ID IS NOT NULL)
2438: AND (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NULL
2439: OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL
2440: AND p_start_date <= DECODE(ELEMENT.POST_TERMINATION_RULE,
2441: 'L', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE,hr_general.end_of_time),
2442: 'F', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE,
2443: hr_general.end_of_time),
2444: SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))))
2445: ORDER BY Display_Value;

Line 2443: hr_general.end_of_time),

2439: OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL
2440: AND p_start_date <= DECODE(ELEMENT.POST_TERMINATION_RULE,
2441: 'L', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE,hr_general.end_of_time),
2442: 'F', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE,
2443: hr_general.end_of_time),
2444: SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))))
2445: ORDER BY Display_Value;
2446:
2447: