DBA Data[Home] [Help]

APPS.HR_GENERAL_UTILITIES dependencies on HR_LOOKUPS

Line 793: FROM hr_lookups

789: , p_lookup_code VARCHAR2
790: )
791: IS
792: SELECT lookup_type, lookup_code, meaning
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)

Line 874: FROM hr_lookups

870: ( p_lookup_type VARCHAR2
871: )
872: IS
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)