APPS.HXC_TK_GRP_QUERY_CRITERIA_API dependencies on HR_GENERAL

Line 501: AND sysdate BETWEEN h.start_date_active AND NVL(h.end_date_active, hr_general.end_of_time) );

497: FROM hr_lookups h
498: WHERE h.lookup_type = 'HXC_TK_CRITERIA_TYPES'
499: AND h.lookup_code = p_criteria_type
500: AND h.enabled_flag = 'Y'
501: AND sysdate BETWEEN h.start_date_active AND NVL(h.end_date_active, hr_general.end_of_time) );
502: --
503: l_dummy varchar2(5) := NULL;
504: --
505: BEGIN

Line 889: , p_start_evaluation_date => hr_general.start_of_time

885: -- get preference as of session date
886:
887: hxc_preference_evaluation.resource_preferences(
888: p_resource_id => p_resource_id
889: , p_start_evaluation_date => hr_general.start_of_time
890: , p_end_evaluation_date => hr_general.end_of_time
891: , p_pref_table => l_pref_tab );
892: */
893:

Line 890: , p_end_evaluation_date => hr_general.end_of_time

886:
887: hxc_preference_evaluation.resource_preferences(
888: p_resource_id => p_resource_id
889: , p_start_evaluation_date => hr_general.start_of_time
890: , p_end_evaluation_date => hr_general.end_of_time
891: , p_pref_table => l_pref_tab );
892: */
893:
894: OPEN csr_get_effective_date;