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 2445: and nvl(hav.date_to,hr_general.end_of_time) >=p_start_date

2441: and had.alias_definition_id = p_alias_definition_id
2442: and havt.language = USERENV('LANG')
2443: and havt.alias_value_id = hav.alias_value_id
2444: and hav.date_from <= p_end_date
2445: and nvl(hav.date_to,hr_general.end_of_time) >=p_start_date
2446: and exists (
2447: select 'x'
2448: from PAY_ELEMENT_TYPES_F ELEMENT,
2449: PAY_ELEMENT_CLASSIFICATIONS CLASSIFICATION,

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

2501: AND (ELEMENT.PROCESSING_TYPE = 'R' OR ASGT.PAYROLL_ID IS NOT NULL)
2502: AND (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NULL
2503: OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL
2504: AND p_start_date <= DECODE(ELEMENT.POST_TERMINATION_RULE,
2505: 'L', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE,hr_general.end_of_time),
2506: 'F', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE,
2507: hr_general.end_of_time),
2508: SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))))
2509: ORDER BY Display_Value;

Line 2507: hr_general.end_of_time),

2503: OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL
2504: AND p_start_date <= DECODE(ELEMENT.POST_TERMINATION_RULE,
2505: 'L', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE,hr_general.end_of_time),
2506: 'F', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE,
2507: hr_general.end_of_time),
2508: SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))))
2509: ORDER BY Display_Value;
2510:
2511: