162: CURSOR csr_ele_entry (p_element_link NUMBER, p_inp_val NUMBER)IS
163: SELECT pee.element_entry_id,
164: object_version_number
165: FROM pay_element_entries_f pee,
166: pay_element_entry_values_f pev
167: WHERE pee.assignment_id = p_assignment_id
168: AND l_session_date BETWEEN pee.effective_start_date AND pee.effective_end_date
169: AND pee.element_link_id = p_element_link
170: AND pev.element_entry_id = pee.element_entry_id
235: decode(decode(eev6.SCREEN_ENTRY_VALUE,'Y','Y','N','N','YY','Y','NY','N','N'),'Y','Y',decode(eev3.SCREEN_ENTRY_VALUE,'Y','Y','N')) ,
236: eev7.SCREEN_ENTRY_VALUE ,
237: pee.entry_information1
238: FROM pay_element_entries_f pee ,
239: pay_element_entry_values_f eev0 ,
240: pay_element_entry_values_f eev1 ,
241: pay_element_entry_values_f eev2 ,
242: pay_element_entry_values_f eev3 ,
243: pay_element_entry_values_f eev4 ,
236: eev7.SCREEN_ENTRY_VALUE ,
237: pee.entry_information1
238: FROM pay_element_entries_f pee ,
239: pay_element_entry_values_f eev0 ,
240: pay_element_entry_values_f eev1 ,
241: pay_element_entry_values_f eev2 ,
242: pay_element_entry_values_f eev3 ,
243: pay_element_entry_values_f eev4 ,
244: pay_element_entry_values_f eev5 ,
237: pee.entry_information1
238: FROM pay_element_entries_f pee ,
239: pay_element_entry_values_f eev0 ,
240: pay_element_entry_values_f eev1 ,
241: pay_element_entry_values_f eev2 ,
242: pay_element_entry_values_f eev3 ,
243: pay_element_entry_values_f eev4 ,
244: pay_element_entry_values_f eev5 ,
245: pay_element_entry_values_f eev6 ,
238: FROM pay_element_entries_f pee ,
239: pay_element_entry_values_f eev0 ,
240: pay_element_entry_values_f eev1 ,
241: pay_element_entry_values_f eev2 ,
242: pay_element_entry_values_f eev3 ,
243: pay_element_entry_values_f eev4 ,
244: pay_element_entry_values_f eev5 ,
245: pay_element_entry_values_f eev6 ,
246: pay_element_entry_values_f eev7 ,
239: pay_element_entry_values_f eev0 ,
240: pay_element_entry_values_f eev1 ,
241: pay_element_entry_values_f eev2 ,
242: pay_element_entry_values_f eev3 ,
243: pay_element_entry_values_f eev4 ,
244: pay_element_entry_values_f eev5 ,
245: pay_element_entry_values_f eev6 ,
246: pay_element_entry_values_f eev7 ,
247: hr_lookups hrl0 ,
240: pay_element_entry_values_f eev1 ,
241: pay_element_entry_values_f eev2 ,
242: pay_element_entry_values_f eev3 ,
243: pay_element_entry_values_f eev4 ,
244: pay_element_entry_values_f eev5 ,
245: pay_element_entry_values_f eev6 ,
246: pay_element_entry_values_f eev7 ,
247: hr_lookups hrl0 ,
248: hr_lookups hrl1 ,
241: pay_element_entry_values_f eev2 ,
242: pay_element_entry_values_f eev3 ,
243: pay_element_entry_values_f eev4 ,
244: pay_element_entry_values_f eev5 ,
245: pay_element_entry_values_f eev6 ,
246: pay_element_entry_values_f eev7 ,
247: hr_lookups hrl0 ,
248: hr_lookups hrl1 ,
249: hr_lookups hrl2 ,
242: pay_element_entry_values_f eev3 ,
243: pay_element_entry_values_f eev4 ,
244: pay_element_entry_values_f eev5 ,
245: pay_element_entry_values_f eev6 ,
246: pay_element_entry_values_f eev7 ,
247: hr_lookups hrl0 ,
248: hr_lookups hrl1 ,
249: hr_lookups hrl2 ,
250: hr_lookups hrl3 ,
803: CURSOR csr_ele_entry (p_element_link NUMBER, p_inp_val NUMBER)IS
804: SELECT pee.element_entry_id
805: ,object_version_number
806: FROM pay_element_entries_f pee,
807: pay_element_entry_values_f pev
808: WHERE pee.assignment_id = p_assignment_id
809: AND l_session_date BETWEEN pee.effective_start_date AND pee.effective_end_date
810: AND pee.element_link_id = p_element_link
811: AND pev.element_entry_id = pee.element_entry_id
817: CURSOR get_prev_tfn_super_value(p_element_entry_id NUMBER,
818: p_spr_flag_input_value_id NUMBER,
819: p_effective_start_date DATE) IS
820: SELECT nvl(screen_entry_value,'N')
821: FROM pay_element_entry_values_f
822: WHERE element_entry_id = p_element_entry_id
823: AND input_value_id = p_spr_flag_input_value_id
824: AND p_effective_start_date between effective_start_date and effective_end_date;
825: