DBA Data[Home] [Help]

APPS.HR_GENERAL_UTILITIES dependencies on FND_LOOKUPS

Line 806: FROM fnd_lookups

802: , p_lookup_code VARCHAR2
803: )
804: IS
805: SELECT lookup_type, lookup_code, meaning
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)

Line 887: FROM fnd_lookups

883: ( p_lookup_type VARCHAR2
884: )
885: IS
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)