APPS.PER_PEM_BUS dependencies on HR_LEG_LOOKUPS

Line 1088: from hr_leg_lookups

1084: ,p_effective_date in date) is
1085: --
1086: cursor csr_employer_subtype is
1087: select lookup_code
1088: from hr_leg_lookups
1089: where lookup_type = 'PREV_EMP_SUBTYPE'
1090: and lookup_code like p_employer_type||'_%'
1091: and lookup_code = p_employer_subtype;
1092: --

Line 1098: l_employer_subtype hr_leg_lookups.lookup_code%type;

1094: l_no_lookup boolean;
1095: l_effective_date date := p_effective_date;
1096: l_lookup_type fnd_lookups.lookup_type%type := 'PREV_EMP_SUBTYPE';
1097: l_lookup_code fnd_lookups.lookup_code%type := p_employer_subtype;
1098: l_employer_subtype hr_leg_lookups.lookup_code%type;
1099: --
1100: l_api_updating boolean;
1101: begin
1102: hr_utility.set_location('Entering:'||l_proc, 5);