eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GRADE_RULES_PKG dependencies on PAY_RATES

Line 82: pay_rates r

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
86: and r.business_group_id + 0 = p_bgroup_id;

Line 300: l_name pay_rates.name%TYPE;

296: FUNCTION POPULATE_RATE (p_spinal_point_id IN NUMBER, p_effective_date IN DATE)
297:
298: RETURN VARCHAR IS
299:
300: l_name pay_rates.name%TYPE;
301: l_spinal_point_id number := p_spinal_point_id;
302:
303: begin
304:

Line 307: from pay_rates pr, pay_grade_rules_f g

303: begin
304:
305: select pr.name
306: into l_name
307: from pay_rates pr, pay_grade_rules_f g
308: where pr.rate_id = g.rate_id
309: and g.grade_or_spinal_point_id = l_spinal_point_id
310: and p_effective_date between g.effective_start_date and g.effective_end_date
311: and g.rate_type = 'SP'; -- Fix 3401079

Line 336: l_rate_uom pay_rates.rate_uom%TYPE;

332:
333: RETURN VARCHAR IS
334:
335: l_value pay_grade_rules_f.value%TYPE;
336: l_rate_uom pay_rates.rate_uom%TYPE;
337: l_currency_code pay_grade_rules_f.currency_code%TYPE;
338: l_format_value varchar2(500);
339: l_spinal_point_id number := p_spinal_point_id;
340:

Line 345: from pay_grade_rules_f g, pay_rates r

341: begin
342:
343: select g.value, r.rate_uom, g.currency_code
344: into l_value, l_rate_uom, l_currency_code
345: from pay_grade_rules_f g, pay_rates r
346: where g.rate_id = r.rate_id
347: and g.grade_or_spinal_point_id = l_spinal_point_id
348: and p_effective_date between g.effective_start_date and g.effective_end_date
349: and g.rate_type = 'SP'; -- Fix 3401079

Line 381: l_bg_id pay_rates.business_group_id%TYPE;

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:
385: begin

Line 382: l_rate_id pay_rates.rate_id%TYPE;

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:
385: begin
386:

Line 389: from pay_grade_rules_f g, pay_rates r

385: begin
386:
387: select r.rate_id, r.business_group_id
388: into l_rate_id, l_bg_id
389: from pay_grade_rules_f g, pay_rates r
390: where r.rate_id = g.rate_id
391: and GRADE_OR_SPINAL_POINT_ID = l_spinal_point_id
392: and p_effective_date between g.effective_start_date and g.effective_end_date
393: and g.rate_type = 'SP'; -- Fix 3401079

Line 398: pay_rates r

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
402: and r.business_group_id + 0 = l_bg_id;