APPS.PER_IN_ADD_LEG_HOOK dependencies on HR_LOOKUPS

Line 11: FROM hr_lookups

7:
8: CURSOR csr_pin_codes IS
9: SELECT lookup_code,
10: meaning
11: FROM hr_lookups
12: WHERE lookup_type='IN_PIN_CODES';
13:
14:
15: /*--------------------------------------------------------------------------

Line 44: FUNCTION validate_pin_code(p_state hr_lookups.lookup_code%TYPE,

40: -- Description : This is the main function that performs pin code --
41: -- validation of the address. --
42: --------------------------------------------------------------------------*/
43:
44: FUNCTION validate_pin_code(p_state hr_lookups.lookup_code%TYPE,
45: p_postal_code hr_lookups.meaning%TYPE)
46: RETURN BOOLEAN IS
47: l_postal_code hr_lookups.meaning%TYPE;
48: l_func VARCHAR2(72);

Line 45: p_postal_code hr_lookups.meaning%TYPE)

41: -- validation of the address. --
42: --------------------------------------------------------------------------*/
43:
44: FUNCTION validate_pin_code(p_state hr_lookups.lookup_code%TYPE,
45: p_postal_code hr_lookups.meaning%TYPE)
46: RETURN BOOLEAN IS
47: l_postal_code hr_lookups.meaning%TYPE;
48: l_func VARCHAR2(72);
49: g_debug BOOLEAN;

Line 47: l_postal_code hr_lookups.meaning%TYPE;

43:
44: FUNCTION validate_pin_code(p_state hr_lookups.lookup_code%TYPE,
45: p_postal_code hr_lookups.meaning%TYPE)
46: RETURN BOOLEAN IS
47: l_postal_code hr_lookups.meaning%TYPE;
48: l_func VARCHAR2(72);
49: g_debug BOOLEAN;
50: l_state hr_lookups.lookup_code%TYPE;
51:

Line 50: l_state hr_lookups.lookup_code%TYPE;

46: RETURN BOOLEAN IS
47: l_postal_code hr_lookups.meaning%TYPE;
48: l_func VARCHAR2(72);
49: g_debug BOOLEAN;
50: l_state hr_lookups.lookup_code%TYPE;
51:
52: BEGIN
53: g_debug := hr_utility.debug_enabled ;
54: l_procedure := g_package ||'validate_pin_code';