[Home] [Help]
128: , iv1.name
129: FROM per_all_assignments_f asg1
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
275: --
276:
277: CURSOR link_csr(p_element_type_id IN NUMBER) IS
278: SELECT links.element_link_id
279: FROM pay_element_links_f links, per_all_assignments_f assign
280: WHERE links.element_type_id = p_element_type_id
281: AND links.business_group_id=p_business_group_id
282: AND assign.assignment_id=p_assignment_id
283: AND (( links.payroll_id is not null
395: --
396:
397: CURSOR link_csr(p_element_type_id IN NUMBER) IS
398: SELECT links.element_link_id
399: FROM pay_element_links_f links, per_all_assignments_f assign
400: WHERE links.element_type_id = p_element_type_id
401: AND links.business_group_id=p_business_group_id
402: AND assign.assignment_id=p_assignment_id
403: AND (( links.payroll_id is not null
744:
745: CURSOR csr_ele_link(p_element_name pay_element_types_f.element_name%type,
746: p_payroll_id pay_payrolls_f.payroll_id%type ) IS
747: SELECT pel.ELEMENT_LINK_ID
748: FROM pay_element_links_f pel ,pay_element_types_f pet
749: WHERE pel.ELEMENT_TYPE_ID = pet.element_type_id
750: AND nvl(pel.PAYROLL_ID,p_payroll_id) = p_payroll_id
751: AND pet.element_name = p_element_name
752: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
794: l_last_yr VARCHAR2(10);
795: l_curr_entit_yr VARCHAR2(10);
796: l_action_info_id NUMBER;
797: l_ovn NUMBER;
798: l_ele_link_id pay_element_links_f.element_link_id%type;
799: l_payroll_exists NUMBER;
800: l_assignment_id per_all_assignments_f.assignment_id%type;
801:
802: wrong_entit_year EXCEPTION;