APPS.HXC_ALIAS_TRANSLATOR dependencies on HR_GENERAL

Line 14: and nvl(date_to,hr_general.end_of_time) >= SYSDATE;

10: from hxc_alias_values
11: where alias_definition_id = 1
12: and enabled_flag = 'Y'
13: and date_from <= SYSDATE
14: and nvl(date_to,hr_general.end_of_time) >= SYSDATE;
15:
16: TYPE AVTAB IS TABLE OF g_csr_alias_values%ROWTYPE;
17: TYPE AD_AVTAB IS TABLE OF AVTAB INDEX BY VARCHAR2(100);
18: g_ad_avtab AD_AVTAB;

Line 491: l_tbb_end_date := HR_GENERAL.END_OF_TIME;

487:
488: --dbms_output.put_line('l_index_string '||l_index_string);
489:
490: l_tbb_start_date := SYSDATE;
491: l_tbb_end_date := HR_GENERAL.END_OF_TIME;
492: --dbms_output.put_line('l_time_building_block_id '||l_time_building_block_id);
493:
494: IF (p_tbb_date_reference_table.exists(l_time_building_block_id)) THEN
495: l_tbb_start_date := p_tbb_date_reference_table(l_time_building_block_id).START_TIME;

Line 982: ,p_stop_time IN DATE DEFAULT hr_general.end_of_time

978: PROCEDURE do_retrieval_translation
979: (p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE--hxc_self_service_time_deposit.building_block_attribute_info
980: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE--hxc_self_service_time_deposit.timecard_info
981: ,p_start_time IN DATE DEFAULT sysdate
982: ,p_stop_time IN DATE DEFAULT hr_general.end_of_time
983: ,p_resource_id IN NUMBER -- timekeeper or resource
984: ,p_processing_mode IN VARCHAR2 DEFAULT hxc_alias_utility.c_ss_processing
985: ,p_add_alias_display_value IN BOOLEAN DEFAULT FALSE
986: ,p_add_alias_ref_object IN BOOLEAN DEFAULT FALSE

Line 999: and nvl(date_to,hr_general.end_of_time) >= p_start_time;

995: from hxc_alias_values
996: where alias_definition_id = p_alias_definition_id
997: and enabled_flag = 'Y'
998: and date_from <= p_stop_time
999: and nvl(date_to,hr_general.end_of_time) >= p_start_time;
1000:
1001: -- index for pl/sql table
1002: l_index_alias_def NUMBER;
1003: --l_time_building_block_id NUMBER;