DBA Data[Home] [Help]

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on HR_LOOKUPS

Line 305: from hr_lookups

301: -----------------------------------------------------------------------------
302: FUNCTION get_lookup_meaning (p_lookup_type varchar2,p_lookup_code varchar2) RETURN VARCHAR2 IS
303: CURSOR csr_lookup IS
304: select meaning
305: from hr_lookups
306: where lookup_type = p_lookup_type
307: and lookup_code = p_lookup_code
308: and enabled_flag ='Y';
309: l_meaning hr_lookups.meaning%type;

Line 309: l_meaning hr_lookups.meaning%type;

305: from hr_lookups
306: where lookup_type = p_lookup_type
307: and lookup_code = p_lookup_code
308: and enabled_flag ='Y';
309: l_meaning hr_lookups.meaning%type;
310: BEGIN
311: OPEN csr_lookup;
312: FETCH csr_lookup INTO l_Meaning;
313: CLOSE csr_lookup;