APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HR_LOOKUPS

Line 62: p_lookup_type IN hr_lookups.lookup_type%TYPE,

58:
59: rec_iv_info csr_iv_info%ROWTYPE;
60:
61: FUNCTION lookup_meaning (
62: p_lookup_type IN hr_lookups.lookup_type%TYPE,
63: p_lookup_code IN hr_lookups.lookup_code%TYPE
64: )
65: RETURN hr_lookups.meaning%TYPE
66: AS

Line 63: p_lookup_code IN hr_lookups.lookup_code%TYPE

59: rec_iv_info csr_iv_info%ROWTYPE;
60:
61: FUNCTION lookup_meaning (
62: p_lookup_type IN hr_lookups.lookup_type%TYPE,
63: p_lookup_code IN hr_lookups.lookup_code%TYPE
64: )
65: RETURN hr_lookups.meaning%TYPE
66: AS
67: CURSOR csr_valid_lookup (

Line 65: RETURN hr_lookups.meaning%TYPE

61: FUNCTION lookup_meaning (
62: p_lookup_type IN hr_lookups.lookup_type%TYPE,
63: p_lookup_code IN hr_lookups.lookup_code%TYPE
64: )
65: RETURN hr_lookups.meaning%TYPE
66: AS
67: CURSOR csr_valid_lookup (
68: p_lookup_type VARCHAR2,
69: p_lookup_code VARCHAR2

Line 73: FROM hr_lookups hl

69: p_lookup_code VARCHAR2
70: )
71: IS
72: SELECT hl.meaning
73: FROM hr_lookups hl
74: WHERE hl.lookup_type = p_lookup_type
75: AND hl.lookup_code = p_lookup_code;
76:
77: l_lookup_meaning hr_lookups.meaning%TYPE;

Line 77: l_lookup_meaning hr_lookups.meaning%TYPE;

73: FROM hr_lookups hl
74: WHERE hl.lookup_type = p_lookup_type
75: AND hl.lookup_code = p_lookup_code;
76:
77: l_lookup_meaning hr_lookups.meaning%TYPE;
78: BEGIN
79: OPEN csr_valid_lookup (p_lookup_type, p_lookup_code);
80:
81: FETCH csr_valid_lookup