APPS.PER_ALT_LOOKUPS_PKG dependencies on HR_LOOKUPS

Line 33: from hr_lookups hl, pay_user_rows_f b

29: and nvl(c.legislation_code,l_legislation_code) = l_legislation_code;
30:
31: cursor csr_lookup_code(p_user_table_id number) is
32: select hl.lookup_code, hl.meaning, b.user_row_id, b.effective_start_date, b.effective_end_date
33: from hr_lookups hl, pay_user_rows_f b
34: where hl.lookup_type = P_LOOKUP_TYPE
35: and b.user_table_id (+) = p_user_table_id
36: and nvl(b.business_group_id(+),P_BUSINESS_GROUP_ID) = P_BUSINESS_GROUP_ID
37: and nvl(b.legislation_code(+),l_legislation_code) = l_legislation_code

Line 67: l_lookup_code hr_lookups.lookup_code%type;

63: l_user_column_instance_id number;
64: --
65: l_procedure varchar2(100);
66: --
67: l_lookup_code hr_lookups.lookup_code%type;
68: l_lookup_meaning hr_lookups.meaning%type;
69: --
70: l_effective_start_date date;
71: l_effective_end_date date;

Line 68: l_lookup_meaning hr_lookups.meaning%type;

64: --
65: l_procedure varchar2(100);
66: --
67: l_lookup_code hr_lookups.lookup_code%type;
68: l_lookup_meaning hr_lookups.meaning%type;
69: --
70: l_effective_start_date date;
71: l_effective_end_date date;
72: --