DBA Data[Home] [Help]

APPS.PAY_AE_PAYROLL_REGISTER dependencies on HR_LOOKUPS

Line 2137: from hr_lookups

2133: ,p_lookup_code varchar2)
2134: RETURN VARCHAR2 IS
2135: CURSOR csr_lookup IS
2136: select meaning
2137: from hr_lookups
2138: where lookup_type = p_lookup_type
2139: and lookup_code = p_lookup_code;
2140: l_meaning hr_lookups.meaning%type;
2141: BEGIN

Line 2140: l_meaning hr_lookups.meaning%type;

2136: select meaning
2137: from hr_lookups
2138: where lookup_type = p_lookup_type
2139: and lookup_code = p_lookup_code;
2140: l_meaning hr_lookups.meaning%type;
2141: BEGIN
2142: OPEN csr_lookup;
2143: FETCH csr_lookup INTO l_Meaning;
2144: CLOSE csr_lookup;