[Home] [Help]
130: ,per_all_assignments_f asg2
131: ,per_all_people_f per
132: ,pay_element_links_f el
133: ,pay_element_types_f et
134: ,pay_input_values_f iv1
135: ,pay_element_entries_f ee
136: ,pay_element_entry_values_f eev1
137: WHERE asg1.assignment_id = p_assignment_id
138: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
155: ORDER BY ee.element_entry_id;
156: --
157: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
158: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
159: eename pay_input_values_f.name%TYPE );
160: l_rec l_record;
161: TYPE l_table is table of l_record index by BINARY_INTEGER;
162: l_tab l_table;
163:
261: element_rec element_csr%ROWTYPE;
262: --
263: CURSOR input_val_csr(p_element_type_id IN NUMBER, p_name In VARCHAR2) IS
264: SELECT input_value_id
265: FROM pay_input_values_f
266: WHERE element_type_id = p_element_type_id
267: AND name = p_name
268: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
269: AND nvl(legislation_code, 'DK') = 'DK'
378: element_rec element_csr%ROWTYPE;
379: --
380: CURSOR input_val_csr(p_element_type_id IN NUMBER, p_name In VARCHAR2) IS
381: SELECT input_value_id
382: FROM pay_input_values_f
383: WHERE element_type_id = p_element_type_id
384: AND name = p_name
385: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
386: AND nvl(legislation_code, 'DK') = 'DK'
757: CURSOR check_run_id (p_assg_id number, p_run_id VARCHAR2) IS
758: SELECT 1
759: FROM per_all_assignments_f asg1
760: ,pay_element_types_f et
761: ,pay_input_values_f iv1
762: ,pay_element_entries_f ee
763: ,pay_element_entry_values_f eev1
764: WHERE asg1.assignment_id = p_assg_id
765: -- AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date