APPS.HR_GENERAL_UTILITIES dependencies on HR_API

Line 797: AND sysdate between NVL(start_date_active, hr_api.g_sot)

793: FROM hr_lookups
794: WHERE lookup_type = p_lookup_type
795: AND lookup_code = p_lookup_code
796: AND enabled_flag = 'Y'
797: AND sysdate between NVL(start_date_active, hr_api.g_sot)
798: AND NVL(end_date_active, hr_api.g_eot);
799: --
800: CURSOR csr_fnd_lookup
801: ( p_lookup_type VARCHAR2

Line 798: AND NVL(end_date_active, hr_api.g_eot);

794: WHERE lookup_type = p_lookup_type
795: AND lookup_code = p_lookup_code
796: AND enabled_flag = 'Y'
797: AND sysdate between NVL(start_date_active, hr_api.g_sot)
798: AND NVL(end_date_active, hr_api.g_eot);
799: --
800: CURSOR csr_fnd_lookup
801: ( p_lookup_type VARCHAR2
802: , p_lookup_code VARCHAR2

Line 810: AND sysdate between NVL(start_date_active, hr_api.g_sot)

806: FROM fnd_lookups
807: WHERE lookup_type = p_lookup_type
808: AND lookup_code = p_lookup_code
809: AND enabled_flag = 'Y'
810: AND sysdate between NVL(start_date_active, hr_api.g_sot)
811: AND NVL(end_date_active, hr_api.g_eot);
812: BEGIN
813: g_debug := hr_utility.debug_enabled;
814: IF g_debug THEN

Line 811: AND NVL(end_date_active, hr_api.g_eot);

807: WHERE lookup_type = p_lookup_type
808: AND lookup_code = p_lookup_code
809: AND enabled_flag = 'Y'
810: AND sysdate between NVL(start_date_active, hr_api.g_sot)
811: AND NVL(end_date_active, hr_api.g_eot);
812: BEGIN
813: g_debug := hr_utility.debug_enabled;
814: IF g_debug THEN
815: l_proc := g_package || ' Get_lookup_Meaning';

Line 877: AND sysdate between NVL(start_date_active, hr_api.g_sot)

873: SELECT lookup_type, lookup_code, meaning
874: FROM hr_lookups
875: WHERE lookup_type = p_lookup_type
876: AND enabled_flag = 'Y'
877: AND sysdate between NVL(start_date_active, hr_api.g_sot)
878: AND NVL(end_date_active, hr_api.g_eot)
879: ORDER by meaning;
880:
881: --

Line 878: AND NVL(end_date_active, hr_api.g_eot)

874: FROM hr_lookups
875: WHERE lookup_type = p_lookup_type
876: AND enabled_flag = 'Y'
877: AND sysdate between NVL(start_date_active, hr_api.g_sot)
878: AND NVL(end_date_active, hr_api.g_eot)
879: ORDER by meaning;
880:
881: --
882: CURSOR csr_fnd_lookup

Line 890: AND sysdate between NVL(start_date_active, hr_api.g_sot)

886: SELECT lookup_type, lookup_code, meaning
887: FROM fnd_lookups
888: WHERE lookup_type = p_lookup_type
889: AND enabled_flag = 'Y'
890: AND sysdate between NVL(start_date_active, hr_api.g_sot)
891: AND NVL(end_date_active, hr_api.g_eot)
892: ORDER by meaning;
893:
894: BEGIN

Line 891: AND NVL(end_date_active, hr_api.g_eot)

887: FROM fnd_lookups
888: WHERE lookup_type = p_lookup_type
889: AND enabled_flag = 'Y'
890: AND sysdate between NVL(start_date_active, hr_api.g_sot)
891: AND NVL(end_date_active, hr_api.g_eot)
892: ORDER by meaning;
893:
894: BEGIN
895: g_debug := hr_utility.debug_enabled;