DBA Data[Home] [Help]

APPS.HR_AU_TAX_API dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 166: pay_element_entry_values_f pev

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

Line 239: pay_element_entry_values_f eev0 ,

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 ,

Line 240: pay_element_entry_values_f eev1 ,

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 ,

Line 241: pay_element_entry_values_f eev2 ,

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 ,

Line 242: pay_element_entry_values_f eev3 ,

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 ,

Line 243: pay_element_entry_values_f eev4 ,

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 ,

Line 244: pay_element_entry_values_f eev5 ,

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 ,

Line 245: pay_element_entry_values_f eev6 ,

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 ,

Line 246: pay_element_entry_values_f eev7 ,

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 ,

Line 807: pay_element_entry_values_f pev

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

Line 821: FROM pay_element_entry_values_f

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: