APPS.PE_GET_VAL_PKG dependencies on PAY_GRADE_RULES_F

Line 6: g_grade_id pay_grade_rules_f.grade_or_spinal_point_id%TYPE;

2: /* $Header: pepyppgr.pkb 120.2 2005/12/01 01:04:45 ggnanagu noship $ */
3: --
4: -- define private global vars
5: --
6: g_grade_id pay_grade_rules_f.grade_or_spinal_point_id%TYPE;
7: g_rate_id pay_grade_rules_f.rate_id%TYPE;
8: g_change_date DATE;
9: g_min_val pay_grade_rules_f.MINIMUM%TYPE;
10: g_mid_val pay_grade_rules_f.mid_value%TYPE;

Line 7: g_rate_id pay_grade_rules_f.rate_id%TYPE;

3: --
4: -- define private global vars
5: --
6: g_grade_id pay_grade_rules_f.grade_or_spinal_point_id%TYPE;
7: g_rate_id pay_grade_rules_f.rate_id%TYPE;
8: g_change_date DATE;
9: g_min_val pay_grade_rules_f.MINIMUM%TYPE;
10: g_mid_val pay_grade_rules_f.mid_value%TYPE;
11: g_max_val pay_grade_rules_f.maximum%TYPE;

Line 9: g_min_val pay_grade_rules_f.MINIMUM%TYPE;

5: --
6: g_grade_id pay_grade_rules_f.grade_or_spinal_point_id%TYPE;
7: g_rate_id pay_grade_rules_f.rate_id%TYPE;
8: g_change_date DATE;
9: g_min_val pay_grade_rules_f.MINIMUM%TYPE;
10: g_mid_val pay_grade_rules_f.mid_value%TYPE;
11: g_max_val pay_grade_rules_f.maximum%TYPE;
12:
13: --

Line 10: g_mid_val pay_grade_rules_f.mid_value%TYPE;

6: g_grade_id pay_grade_rules_f.grade_or_spinal_point_id%TYPE;
7: g_rate_id pay_grade_rules_f.rate_id%TYPE;
8: g_change_date DATE;
9: g_min_val pay_grade_rules_f.MINIMUM%TYPE;
10: g_mid_val pay_grade_rules_f.mid_value%TYPE;
11: g_max_val pay_grade_rules_f.maximum%TYPE;
12:
13: --
14: --

Line 11: g_max_val pay_grade_rules_f.maximum%TYPE;

7: g_rate_id pay_grade_rules_f.rate_id%TYPE;
8: g_change_date DATE;
9: g_min_val pay_grade_rules_f.MINIMUM%TYPE;
10: g_mid_val pay_grade_rules_f.mid_value%TYPE;
11: g_max_val pay_grade_rules_f.maximum%TYPE;
12:
13: --
14: --
15: -- define private global cursor

Line 16: -- Cursor to get the min,max and mid value from pay_grade_rules_f

12:
13: --
14: --
15: -- define private global cursor
16: -- Cursor to get the min,max and mid value from pay_grade_rules_f
17: --
18: CURSOR g_csr_get_grade_values
19: IS
20: SELECT g.MINIMUM, g.mid_value, g.maximum

Line 21: FROM pay_grade_rules_f g

17: --
18: CURSOR g_csr_get_grade_values
19: IS
20: SELECT g.MINIMUM, g.mid_value, g.maximum
21: FROM pay_grade_rules_f g
22: WHERE g.grade_or_spinal_point_id = g_grade_id
23: AND g.rate_id = g_rate_id
24: AND g_change_date BETWEEN g.effective_start_date AND g.effective_end_date;
25: