DBA Data[Home] [Help]

APPS.PAY_JP_TRANSLATION_PKG dependencies on HR_LOOKUPS

Line 7: l_user_name HR_LOOKUPS.MEANING%TYPE;

3: FUNCTION user_name(
4: p_lookup_type IN VARCHAR2,
5: p_lookup_code IN VARCHAR2) RETURN VARCHAR2
6: IS
7: l_user_name HR_LOOKUPS.MEANING%TYPE;
8: CURSOR csr_user_name IS
9: select meaning
10: from hr_lookups
11: where lookup_type=p_lookup_type

Line 10: from hr_lookups

6: IS
7: l_user_name HR_LOOKUPS.MEANING%TYPE;
8: CURSOR csr_user_name IS
9: select meaning
10: from hr_lookups
11: where lookup_type=p_lookup_type
12: and lookup_code=p_lookup_code;
13: BEGIN
14: open csr_user_name;