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;
276: ) is
277: --
278: -- Declare cursors and local variables
279: --
280: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
281: l_object_version_number_temp pay_grade_rules_f.object_version_number%TYPE;
282: l_proc varchar2(72) := g_package||'update_pay_scale_value';
283: l_effective_date date;
284: l_effective_start_date date;
277: --
278: -- Declare cursors and local variables
279: --
280: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
281: l_object_version_number_temp pay_grade_rules_f.object_version_number%TYPE;
282: l_proc varchar2(72) := g_package||'update_pay_scale_value';
283: l_effective_date date;
284: l_effective_start_date date;
285: l_effective_end_date date;
288: l_rate_id pay_rates.rate_id%type;
289:
290: cursor c_get_rate_id is
291: select rate_id
292: from pay_grade_rules_f
293: where grade_rule_id = p_grade_rule_id;
294: -- End changes for bug 9328526
295:
296: --
466: ) is
467: --
468: -- Declare cursors and local variables
469: --
470: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
471: l_object_version_number_temp pay_grade_rules_f.object_version_number%TYPE;
472: l_proc varchar2(72) := g_package||'delete_pay_scale_value';
473: l_effective_date date;
474: l_effective_start_date date;
467: --
468: -- Declare cursors and local variables
469: --
470: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
471: l_object_version_number_temp pay_grade_rules_f.object_version_number%TYPE;
472: l_proc varchar2(72) := g_package||'delete_pay_scale_value';
473: l_effective_date date;
474: l_effective_start_date date;
475: l_effective_end_date date;
478: l_rate_id pay_rates.rate_id%type;
479:
480: cursor c_get_rate_id is
481: select rate_id
482: from pay_grade_rules_f
483: where grade_rule_id = p_grade_rule_id;
484: -- End changes for bug 9328526
485:
486: --