5: (p_grade_rule_id number
6: ,p_effective_date date
7: ) is
8: select grr.rate_type
9: from pay_grade_rules_f grr
10: where grr.grade_rule_id = p_grade_rule_id
11: and p_effective_date between grr.effective_start_date
12: and grr.effective_end_date;
13: --
21: ) is
22: --
23: -- Declare cursors and local variables
24: --
25: l_rate_type pay_grade_rules_f.rate_type%TYPE;
26: l_proc varchar2(72) := g_package||'check_rate_type';
27: --
28: cursor csr_get_rate_type is
29: select grr.rate_type
26: l_proc varchar2(72) := g_package||'check_rate_type';
27: --
28: cursor csr_get_rate_type is
29: select grr.rate_type
30: from pay_grade_rules_f grr
31: where grr.grade_rule_id = p_grade_rule_id
32: and p_effective_date between grr.effective_start_date
33: and grr.effective_end_date;
34: --
85: --
86: -- Declare cursors and local variables
87: --
88: l_proc varchar2(72) := g_package||'create_pay_scale_value';
89: l_business_group_id pay_grade_rules_f.business_group_id%TYPE;
90: l_sequence pay_grade_rules_f.sequence%TYPE;
91: l_effective_date date;
92: l_grade_rule_id number;
93: l_object_version_number number;
86: -- Declare cursors and local variables
87: --
88: l_proc varchar2(72) := g_package||'create_pay_scale_value';
89: l_business_group_id pay_grade_rules_f.business_group_id%TYPE;
90: l_sequence pay_grade_rules_f.sequence%TYPE;
91: l_effective_date date;
92: l_grade_rule_id number;
93: l_object_version_number number;
94: l_effective_start_date date;
231: ) is
232: --
233: -- Declare cursors and local variables
234: --
235: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
236: l_object_version_number_temp pay_grade_rules_f.object_version_number%TYPE;
237: l_proc varchar2(72) := g_package||'update_pay_scale_value';
238: l_effective_date date;
239: l_effective_start_date date;
232: --
233: -- Declare cursors and local variables
234: --
235: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
236: l_object_version_number_temp pay_grade_rules_f.object_version_number%TYPE;
237: l_proc varchar2(72) := g_package||'update_pay_scale_value';
238: l_effective_date date;
239: l_effective_start_date date;
240: l_effective_end_date date;
351: ) is
352: --
353: -- Declare cursors and local variables
354: --
355: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
356: l_object_version_number_temp pay_grade_rules_f.object_version_number%TYPE;
357: l_proc varchar2(72) := g_package||'delete_pay_scale_value';
358: l_effective_date date;
359: l_effective_start_date date;
352: --
353: -- Declare cursors and local variables
354: --
355: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
356: l_object_version_number_temp pay_grade_rules_f.object_version_number%TYPE;
357: l_proc varchar2(72) := g_package||'delete_pay_scale_value';
358: l_effective_date date;
359: l_effective_start_date date;
360: l_effective_end_date date;