DBA Data[Home] [Help]

APPS.HR_MISC_WEB dependencies on HR_LOOKUPS

Line 751: FROM hr_lookups

747: RETURN VARCHAR2 IS
748:
749: CURSOR lc_meaning IS
750: SELECT meaning
751: FROM hr_lookups
752: WHERE LOOKUP_CODE = p_code
753: AND LOOKUP_TYPE = p_lookup_type AND
754: p_date between nvl(start_date_active , p_date) AND
755: nvl(end_date_active, p_date)

Line 759: lv_meaning hr_lookups.meaning%TYPE;

755: nvl(end_date_active, p_date)
756: AND enabled_flag = 'Y' ;
757:
758:
759: lv_meaning hr_lookups.meaning%TYPE;
760:
761: BEGIN
762:
763: OPEN lc_meaning ;