APPS.PAY_GRADE_RULES_PKG dependencies on HR_LOOKUPS

Line 81: from hr_lookups u,

77:
78: cursor c10 is
79: select r.name,
80: u.meaning
81: from hr_lookups u,
82: pay_rates r
83: where u.lookup_type = 'UNITS'
84: and u.lookup_code = r.rate_uom
85: and r.rate_id = p_rt_id

Line 380: l_meaning hr_lookups.meaning%TYPE;

376: FUNCTION POPULATE_UNITS(p_spinal_point_id IN NUMBER, p_effective_date IN DATE)
377:
378: RETURN VARCHAR IS
379:
380: l_meaning hr_lookups.meaning%TYPE;
381: l_bg_id pay_rates.business_group_id%TYPE;
382: l_rate_id pay_rates.rate_id%TYPE;
383: l_spinal_point_id number := p_spinal_point_id;
384:

Line 397: from hr_lookups u,

393: and g.rate_type = 'SP'; -- Fix 3401079
394:
395: select u.meaning
396: into l_meaning
397: from hr_lookups u,
398: pay_rates r
399: where u.lookup_type = 'UNITS'
400: and u.lookup_code = r.rate_uom
401: and r.rate_id = l_rate_id