APPS.HR_CN_API dependencies on HR_LOOKUPS

Line 88: l_lookup_code hr_lookups.lookup_code%TYPE;

84: p_argument_value IN VARCHAR2
85: )
86: IS
87:
88: l_lookup_code hr_lookups.lookup_code%TYPE;
89: --
90: CURSOR csr_lookup(p_argument_value VARCHAR2,p_lookup_type VARCHAR2) IS
91: SELECT lookup_code
92: FROM hr_lookups hrl

Line 92: FROM hr_lookups hrl

88: l_lookup_code hr_lookups.lookup_code%TYPE;
89: --
90: CURSOR csr_lookup(p_argument_value VARCHAR2,p_lookup_type VARCHAR2) IS
91: SELECT lookup_code
92: FROM hr_lookups hrl
93: WHERE hrl.lookup_type = p_lookup_type
94: AND hrl.lookup_code = p_argument_value
95: AND enabled_flag = 'Y';
96:

Line 351: TYPE t_pt_tbl IS TABLE OF HR_LOOKUPS.LOOKUP_CODE%TYPE index by binary_integer;

347: --------------------------------------------------------------------------
348: FUNCTION chk_person_type (p_code in VARCHAR2)
349: RETURN BOOLEAN
350: IS
351: TYPE t_pt_tbl IS TABLE OF HR_LOOKUPS.LOOKUP_CODE%TYPE index by binary_integer;
352: l_person_type t_pt_tbl;
353: l_loop_count NUMBER ;
354:
355: BEGIN