APPS.PAY_JP_IWHT_ARCH_PKG dependencies on HR_LOOKUPS

Line 307: FUNCTION proc_lookup_meaning( p_lookup_type IN hr_lookups.lookup_type%TYPE

303: RAISE;
304: END initialization_code;
305: --
306:
307: FUNCTION proc_lookup_meaning( p_lookup_type IN hr_lookups.lookup_type%TYPE
308: ,p_lookup_code IN hr_lookups.lookup_code%TYPE)
309: RETURN VARCHAR2 IS
310: --***************************************************************************
311: -- PROCEDURE

Line 308: ,p_lookup_code IN hr_lookups.lookup_code%TYPE)

304: END initialization_code;
305: --
306:
307: FUNCTION proc_lookup_meaning( p_lookup_type IN hr_lookups.lookup_type%TYPE
308: ,p_lookup_code IN hr_lookups.lookup_code%TYPE)
309: RETURN VARCHAR2 IS
310: --***************************************************************************
311: -- PROCEDURE
312: -- DELETE_ASSACT

Line 324: -- p_lookup_type IN hr_lookups.lookup_type%TYPE

320: -- PARAMETERS
321: --==========
322: -- NAME TYPE DESCRIPTION
323: ------------------- -------- ---------------------------------------
324: -- p_lookup_type IN hr_lookups.lookup_type%TYPE
325: -- p_lookup_code IN hr_lookups.lookup_code%TYPE
326: --
327: -- PREREQUISITES
328: -- None

Line 325: -- p_lookup_code IN hr_lookups.lookup_code%TYPE

321: --==========
322: -- NAME TYPE DESCRIPTION
323: ------------------- -------- ---------------------------------------
324: -- p_lookup_type IN hr_lookups.lookup_type%TYPE
325: -- p_lookup_code IN hr_lookups.lookup_code%TYPE
326: --
327: -- PREREQUISITES
328: -- None
329: --

Line 334: CURSOR lcu_lookup_meaning(p_lookup_type hr_lookups.lookup_type%TYPE

330: -- CALLED BY
331: -- None
332: --***********************************************************************
333: -- Local Variables
334: CURSOR lcu_lookup_meaning(p_lookup_type hr_lookups.lookup_type%TYPE
335: ,p_lookup_code hr_lookups.lookup_code%TYPE)
336: IS
337: SELECT meaning
338: FROM hr_lookups

Line 335: ,p_lookup_code hr_lookups.lookup_code%TYPE)

331: -- None
332: --***********************************************************************
333: -- Local Variables
334: CURSOR lcu_lookup_meaning(p_lookup_type hr_lookups.lookup_type%TYPE
335: ,p_lookup_code hr_lookups.lookup_code%TYPE)
336: IS
337: SELECT meaning
338: FROM hr_lookups
339: WHERE lookup_type = p_lookup_type

Line 338: FROM hr_lookups

334: CURSOR lcu_lookup_meaning(p_lookup_type hr_lookups.lookup_type%TYPE
335: ,p_lookup_code hr_lookups.lookup_code%TYPE)
336: IS
337: SELECT meaning
338: FROM hr_lookups
339: WHERE lookup_type = p_lookup_type
340: AND lookup_code = p_lookup_code;
341: --
342: lc_procedure VARCHAR2(200);

Line 343: lc_meaning hr_lookups.meaning%TYPE;

339: WHERE lookup_type = p_lookup_type
340: AND lookup_code = p_lookup_code;
341: --
342: lc_procedure VARCHAR2(200);
343: lc_meaning hr_lookups.meaning%TYPE;
344: --
345: BEGIN
346: --
347: gb_debug :=hr_utility.debug_enabled ;