219: IS
220: l_procedure VARCHAR2(100);
221: l_message VARCHAR2(250);
222: l_element_entry_id NUMBER;
223: l_element_name pay_element_types_f.element_name %TYPE;
224: l_ele_name pay_element_types_f.element_name %TYPE;
225: l_check_assg_extra_info NUMBER ;
226:
227: CURSOR c_element_name IS
220: l_procedure VARCHAR2(100);
221: l_message VARCHAR2(250);
222: l_element_entry_id NUMBER;
223: l_element_name pay_element_types_f.element_name %TYPE;
224: l_ele_name pay_element_types_f.element_name %TYPE;
225: l_check_assg_extra_info NUMBER ;
226:
227: CURSOR c_element_name IS
228: SELECT pet.element_information1
225: l_check_assg_extra_info NUMBER ;
226:
227: CURSOR c_element_name IS
228: SELECT pet.element_information1
229: FROM pay_element_types_f pet
230: WHERE pet.element_type_id = p_element_type_id_o
231: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;
232:
233: --
233: --
234:
235: CURSOR c_other_loan_element(p_element_name VARCHAR2) IS
236: SELECT pee.element_entry_id
237: FROM pay_element_types_f pet
238: ,pay_element_entries_f pee
239: WHERE pet.element_type_id =pee.element_type_id
240: AND pee.assignment_id = p_assignment_id_o
241: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
243: AND pet.element_information1 = p_element_name;
244:
245: CURSOR c_ele_name IS
246: SELECT pet.element_name
247: FROM pay_element_types_f pet
248: WHERE pet.element_type_id = p_element_type_id_o
249: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;
250:
251: