37: p_end_date in VARCHAR2,
38: p_bus_grp_id in pay_element_types_f.business_group_id%type,
39: p_assignment_set_id in Number )
40: is
41: l_ben_start_date_id pay_input_values_f.input_value_id%type;
42: l_ben_end_date_id pay_input_values_f.input_value_id%type;
43: l_element_name pay_element_types_f.element_name%type;
44: l_count NUMBER default 0;
45: l_effective_start_date_dummy DATE;
38: p_bus_grp_id in pay_element_types_f.business_group_id%type,
39: p_assignment_set_id in Number )
40: is
41: l_ben_start_date_id pay_input_values_f.input_value_id%type;
42: l_ben_end_date_id pay_input_values_f.input_value_id%type;
43: l_element_name pay_element_types_f.element_name%type;
44: l_count NUMBER default 0;
45: l_effective_start_date_dummy DATE;
46: l_effective_end_date_dummy DATE;
57: cursor csr_get_benefit_date_id(v_ben_date_type VARCHAR2,
58: v_element_type_id pay_element_types_f.element_type_id%type)
59: is
60: select input_value_id
61: from pay_input_values_f piv
62: where piv.element_type_id = v_element_type_id
63: and piv.NAME = v_ben_date_type;
64:
65: cursor csr_get_del_element_entry_id(v_ben_start_date_id pay_input_values_f.input_value_id%type,
61: from pay_input_values_f piv
62: where piv.element_type_id = v_element_type_id
63: and piv.NAME = v_ben_date_type;
64:
65: cursor csr_get_del_element_entry_id(v_ben_start_date_id pay_input_values_f.input_value_id%type,
66: v_start_date VARCHAR2,
67: v_ben_end_date_id pay_input_values_f.input_value_id%type,
68: v_end_date VARCHAR2,
69: v_bus_grp_id pay_element_types_f.business_group_id%type,
63: and piv.NAME = v_ben_date_type;
64:
65: cursor csr_get_del_element_entry_id(v_ben_start_date_id pay_input_values_f.input_value_id%type,
66: v_start_date VARCHAR2,
67: v_ben_end_date_id pay_input_values_f.input_value_id%type,
68: v_end_date VARCHAR2,
69: v_bus_grp_id pay_element_types_f.business_group_id%type,
70: v_element_type_id pay_element_types_f.element_type_id%type)
71: is
91: from per_all_assignments_f paa
92: where paa.assignment_id = pee.assignment_id
93: and paa.business_group_id = v_bus_grp_id);
94:
95: cursor csr_del_entries_assignset(v_ben_start_date_id pay_input_values_f.input_value_id%type,
96: v_start_date VARCHAR2,
97: v_ben_end_date_id pay_input_values_f.input_value_id%type,
98: v_end_date VARCHAR2,
99: v_bus_grp_id pay_element_types_f.business_group_id%type,
93: and paa.business_group_id = v_bus_grp_id);
94:
95: cursor csr_del_entries_assignset(v_ben_start_date_id pay_input_values_f.input_value_id%type,
96: v_start_date VARCHAR2,
97: v_ben_end_date_id pay_input_values_f.input_value_id%type,
98: v_end_date VARCHAR2,
99: v_bus_grp_id pay_element_types_f.business_group_id%type,
100: v_element_type_id pay_element_types_f.element_type_id%type,
101: v_assignment_set_id Number)