DBA Data[Home] [Help]

APPS.GHR_MTI_INT_INSERT dependencies on HR_LOOKUPS

Line 902: p_lookup_type hr_lookups.lookup_type%TYPE

898:
899: end;
900:
901: FUNCTION get_lookup_meaning(
902: p_lookup_type hr_lookups.lookup_type%TYPE
903: ,p_lookup_code hr_lookups.lookup_code%TYPE)
904: RETURN VARCHAR2 IS
905:
906: l_ret_val hr_lookups.meaning%TYPE := NULL;

Line 903: ,p_lookup_code hr_lookups.lookup_code%TYPE)

899: end;
900:
901: FUNCTION get_lookup_meaning(
902: p_lookup_type hr_lookups.lookup_type%TYPE
903: ,p_lookup_code hr_lookups.lookup_code%TYPE)
904: RETURN VARCHAR2 IS
905:
906: l_ret_val hr_lookups.meaning%TYPE := NULL;
907:

Line 906: l_ret_val hr_lookups.meaning%TYPE := NULL;

902: p_lookup_type hr_lookups.lookup_type%TYPE
903: ,p_lookup_code hr_lookups.lookup_code%TYPE)
904: RETURN VARCHAR2 IS
905:
906: l_ret_val hr_lookups.meaning%TYPE := NULL;
907:
908: CURSOR cur_loc IS
909: SELECT loc.meaning
910: FROM hr_lookups loc

Line 910: FROM hr_lookups loc

906: l_ret_val hr_lookups.meaning%TYPE := NULL;
907:
908: CURSOR cur_loc IS
909: SELECT loc.meaning
910: FROM hr_lookups loc
911: WHERE
912: loc.lookup_type = p_lookup_type
913: AND loc.lookup_code = p_lookup_code;
914: