DBA Data[Home] [Help]

APPS.HR_AU_TAX_API dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 178: pay_element_entry_values_f pev

174: CURSOR csr_ele_entry (p_element_link NUMBER, p_inp_val NUMBER)IS
175: SELECT pee.element_entry_id,
176: object_version_number
177: FROM pay_element_entries_f pee,
178: pay_element_entry_values_f pev
179: WHERE pee.assignment_id = p_assignment_id
180: AND l_session_date BETWEEN pee.effective_start_date AND pee.effective_end_date
181: AND pee.element_link_id = p_element_link
182: AND pev.element_entry_id = pee.element_entry_id

Line 254: pay_element_entry_values_f eev0 ,

250: eev7.SCREEN_ENTRY_VALUE ,
251: eev8.screen_entry_value ,
252: pee.entry_information1
253: FROM pay_element_entries_f pee ,
254: pay_element_entry_values_f eev0 ,
255: pay_element_entry_values_f eev1 ,
256: pay_element_entry_values_f eev2 ,
257: pay_element_entry_values_f eev3 ,
258: pay_element_entry_values_f eev4 ,

Line 255: pay_element_entry_values_f eev1 ,

251: eev8.screen_entry_value ,
252: pee.entry_information1
253: FROM pay_element_entries_f pee ,
254: pay_element_entry_values_f eev0 ,
255: pay_element_entry_values_f eev1 ,
256: pay_element_entry_values_f eev2 ,
257: pay_element_entry_values_f eev3 ,
258: pay_element_entry_values_f eev4 ,
259: pay_element_entry_values_f eev5 ,

Line 256: pay_element_entry_values_f eev2 ,

252: pee.entry_information1
253: FROM pay_element_entries_f pee ,
254: pay_element_entry_values_f eev0 ,
255: pay_element_entry_values_f eev1 ,
256: pay_element_entry_values_f eev2 ,
257: pay_element_entry_values_f eev3 ,
258: pay_element_entry_values_f eev4 ,
259: pay_element_entry_values_f eev5 ,
260: pay_element_entry_values_f eev6 ,

Line 257: pay_element_entry_values_f eev3 ,

253: FROM pay_element_entries_f pee ,
254: pay_element_entry_values_f eev0 ,
255: pay_element_entry_values_f eev1 ,
256: pay_element_entry_values_f eev2 ,
257: pay_element_entry_values_f eev3 ,
258: pay_element_entry_values_f eev4 ,
259: pay_element_entry_values_f eev5 ,
260: pay_element_entry_values_f eev6 ,
261: pay_element_entry_values_f eev7 ,

Line 258: pay_element_entry_values_f eev4 ,

254: pay_element_entry_values_f eev0 ,
255: pay_element_entry_values_f eev1 ,
256: pay_element_entry_values_f eev2 ,
257: pay_element_entry_values_f eev3 ,
258: pay_element_entry_values_f eev4 ,
259: pay_element_entry_values_f eev5 ,
260: pay_element_entry_values_f eev6 ,
261: pay_element_entry_values_f eev7 ,
262: pay_element_entry_values_f eev8 ,

Line 259: pay_element_entry_values_f eev5 ,

255: pay_element_entry_values_f eev1 ,
256: pay_element_entry_values_f eev2 ,
257: pay_element_entry_values_f eev3 ,
258: pay_element_entry_values_f eev4 ,
259: pay_element_entry_values_f eev5 ,
260: pay_element_entry_values_f eev6 ,
261: pay_element_entry_values_f eev7 ,
262: pay_element_entry_values_f eev8 ,
263: hr_lookups hrl0 ,

Line 260: pay_element_entry_values_f eev6 ,

256: pay_element_entry_values_f eev2 ,
257: pay_element_entry_values_f eev3 ,
258: pay_element_entry_values_f eev4 ,
259: pay_element_entry_values_f eev5 ,
260: pay_element_entry_values_f eev6 ,
261: pay_element_entry_values_f eev7 ,
262: pay_element_entry_values_f eev8 ,
263: hr_lookups hrl0 ,
264: hr_lookups hrl1 ,

Line 261: pay_element_entry_values_f eev7 ,

257: pay_element_entry_values_f eev3 ,
258: pay_element_entry_values_f eev4 ,
259: pay_element_entry_values_f eev5 ,
260: pay_element_entry_values_f eev6 ,
261: pay_element_entry_values_f eev7 ,
262: pay_element_entry_values_f eev8 ,
263: hr_lookups hrl0 ,
264: hr_lookups hrl1 ,
265: hr_lookups hrl2 ,

Line 262: pay_element_entry_values_f eev8 ,

258: pay_element_entry_values_f eev4 ,
259: pay_element_entry_values_f eev5 ,
260: pay_element_entry_values_f eev6 ,
261: pay_element_entry_values_f eev7 ,
262: pay_element_entry_values_f eev8 ,
263: hr_lookups hrl0 ,
264: hr_lookups hrl1 ,
265: hr_lookups hrl2 ,
266: hr_lookups hrl3 ,

Line 846: pay_element_entry_values_f pev

842: CURSOR csr_ele_entry (p_element_link NUMBER, p_inp_val NUMBER)IS
843: SELECT pee.element_entry_id
844: ,object_version_number
845: FROM pay_element_entries_f pee,
846: pay_element_entry_values_f pev
847: WHERE pee.assignment_id = p_assignment_id
848: AND l_session_date BETWEEN pee.effective_start_date AND pee.effective_end_date
849: AND pee.element_link_id = p_element_link
850: AND pev.element_entry_id = pee.element_entry_id

Line 860: FROM pay_element_entry_values_f

856: CURSOR get_prev_tfn_super_value(p_element_entry_id NUMBER,
857: p_spr_flag_input_value_id NUMBER,
858: p_effective_start_date DATE) IS
859: SELECT nvl(screen_entry_value,'N')
860: FROM pay_element_entry_values_f
861: WHERE element_entry_id = p_element_entry_id
862: AND input_value_id = p_spr_flag_input_value_id
863: AND p_effective_start_date between effective_start_date and effective_end_date;
864: