DBA Data[Home] [Help]

APPS.GHR_MTI_INT_INSERT dependencies on HR_LOOKUPS

Line 957: p_lookup_type hr_lookups.lookup_type%TYPE

953:
954: end;
955:
956: FUNCTION get_lookup_meaning(
957: p_lookup_type hr_lookups.lookup_type%TYPE
958: ,p_lookup_code hr_lookups.lookup_code%TYPE)
959: RETURN VARCHAR2 IS
960:
961: l_ret_val hr_lookups.meaning%TYPE := NULL;

Line 958: ,p_lookup_code hr_lookups.lookup_code%TYPE)

954: end;
955:
956: FUNCTION get_lookup_meaning(
957: p_lookup_type hr_lookups.lookup_type%TYPE
958: ,p_lookup_code hr_lookups.lookup_code%TYPE)
959: RETURN VARCHAR2 IS
960:
961: l_ret_val hr_lookups.meaning%TYPE := NULL;
962:

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

957: p_lookup_type hr_lookups.lookup_type%TYPE
958: ,p_lookup_code hr_lookups.lookup_code%TYPE)
959: RETURN VARCHAR2 IS
960:
961: l_ret_val hr_lookups.meaning%TYPE := NULL;
962:
963: CURSOR cur_loc IS
964: SELECT loc.meaning
965: FROM hr_lookups loc

Line 965: FROM hr_lookups loc

961: l_ret_val hr_lookups.meaning%TYPE := NULL;
962:
963: CURSOR cur_loc IS
964: SELECT loc.meaning
965: FROM hr_lookups loc
966: WHERE
967: loc.lookup_type = p_lookup_type
968: AND loc.lookup_code = p_lookup_code;
969: