APPS.PER_PEM_BUS dependencies on HR_LEG_LOOKUPS

Line 1084: from hr_leg_lookups

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

Line 1094: l_employer_subtype hr_leg_lookups.lookup_code%type;

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