APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HR_LOOKUPS

Line 116: p_lookup_type IN hr_lookups.lookup_type%TYPE,

112:
113: rec_iv_info csr_iv_info%ROWTYPE;
114:
115: FUNCTION lookup_meaning (
116: p_lookup_type IN hr_lookups.lookup_type%TYPE,
117: p_lookup_code IN hr_lookups.lookup_code%TYPE
118: )
119: RETURN hr_lookups.meaning%TYPE
120: AS

Line 117: p_lookup_code IN hr_lookups.lookup_code%TYPE

113: rec_iv_info csr_iv_info%ROWTYPE;
114:
115: FUNCTION lookup_meaning (
116: p_lookup_type IN hr_lookups.lookup_type%TYPE,
117: p_lookup_code IN hr_lookups.lookup_code%TYPE
118: )
119: RETURN hr_lookups.meaning%TYPE
120: AS
121: CURSOR csr_valid_lookup (

Line 119: RETURN hr_lookups.meaning%TYPE

115: FUNCTION lookup_meaning (
116: p_lookup_type IN hr_lookups.lookup_type%TYPE,
117: p_lookup_code IN hr_lookups.lookup_code%TYPE
118: )
119: RETURN hr_lookups.meaning%TYPE
120: AS
121: CURSOR csr_valid_lookup (
122: p_lookup_type VARCHAR2,
123: p_lookup_code VARCHAR2

Line 127: FROM hr_lookups hl

123: p_lookup_code VARCHAR2
124: )
125: IS
126: SELECT hl.meaning
127: FROM hr_lookups hl
128: WHERE hl.lookup_type = p_lookup_type
129: AND hl.lookup_code = p_lookup_code;
130:
131: l_lookup_meaning hr_lookups.meaning%TYPE;

Line 131: l_lookup_meaning hr_lookups.meaning%TYPE;

127: FROM hr_lookups hl
128: WHERE hl.lookup_type = p_lookup_type
129: AND hl.lookup_code = p_lookup_code;
130:
131: l_lookup_meaning hr_lookups.meaning%TYPE;
132: BEGIN
133: OPEN csr_valid_lookup (p_lookup_type, p_lookup_code);
134:
135: FETCH csr_valid_lookup