11: ) is
12: --
13: -- Declare cursors and local variables
14: --
15: l_rate_type pay_grade_rules_f.rate_type%TYPE;
16: l_proc varchar2(72) := g_package||'check_rate_type';
17: --
18: cursor csr_get_rate_type is
19: select grr.rate_type
16: l_proc varchar2(72) := g_package||'check_rate_type';
17: --
18: cursor csr_get_rate_type is
19: select grr.rate_type
20: from pay_grade_rules_f grr
21: where grr.grade_rule_id = p_grade_rule_id
22: and p_effective_date between grr.effective_start_date
23: and grr.effective_end_date;
24: --
79: --
80: -- Declare cursors and local variables
81: --
82: l_proc varchar2(72) := g_package||'create_grade_rate_value';
83: l_business_group_id pay_grade_rules_f.business_group_id%TYPE;
84: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
85: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
86: l_sequence pay_grade_rules_f.sequence%TYPE;
87: l_effective_date date;
80: -- Declare cursors and local variables
81: --
82: l_proc varchar2(72) := g_package||'create_grade_rate_value';
83: l_business_group_id pay_grade_rules_f.business_group_id%TYPE;
84: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
85: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
86: l_sequence pay_grade_rules_f.sequence%TYPE;
87: l_effective_date date;
88: l_grade_rule_id number;
81: --
82: l_proc varchar2(72) := g_package||'create_grade_rate_value';
83: l_business_group_id pay_grade_rules_f.business_group_id%TYPE;
84: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
85: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
86: l_sequence pay_grade_rules_f.sequence%TYPE;
87: l_effective_date date;
88: l_grade_rule_id number;
89: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
82: l_proc varchar2(72) := g_package||'create_grade_rate_value';
83: l_business_group_id pay_grade_rules_f.business_group_id%TYPE;
84: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
85: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
86: l_sequence pay_grade_rules_f.sequence%TYPE;
87: l_effective_date date;
88: l_grade_rule_id number;
89: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
90: --
85: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
86: l_sequence pay_grade_rules_f.sequence%TYPE;
87: l_effective_date date;
88: l_grade_rule_id number;
89: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
90: --
91: cursor csr_get_der_args is
92: select rat.business_group_id,
93: rat.sequence
225: ) is
226: --
227: -- Declare cursors and local variables
228: --
229: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
230: l_object_version_number_temp pay_grade_rules_f.object_version_number%TYPE;
231: l_proc varchar2(72) := g_package||'update_grade_rate_value';
232: l_effective_date date;
233: l_effective_start_date date;
226: --
227: -- Declare cursors and local variables
228: --
229: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
230: l_object_version_number_temp pay_grade_rules_f.object_version_number%TYPE;
231: l_proc varchar2(72) := g_package||'update_grade_rate_value';
232: l_effective_date date;
233: l_effective_start_date date;
234: l_effective_end_date date;
341: ) is
342: --
343: -- Declare cursors and local variables
344: --
345: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
346: l_object_version_number_temp pay_grade_rules_f.object_version_number%TYPE;
347: l_proc varchar2(72) := g_package||'delete_grade_rate_value';
348: l_effective_date date;
349: l_effective_start_date date;
342: --
343: -- Declare cursors and local variables
344: --
345: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
346: l_object_version_number_temp pay_grade_rules_f.object_version_number%TYPE;
347: l_proc varchar2(72) := g_package||'delete_grade_rate_value';
348: l_effective_date date;
349: l_effective_start_date date;
350: l_effective_end_date date;