APPS.PAY_IN_TAX_UTILS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 222: ,pay_element_entry_values_f pev

218: select pee.element_entry_id,pee.effective_end_date
219: from pay_element_types_f pet
220: ,pay_input_values_f piv
221: ,pay_element_entries_f pee
222: ,pay_element_entry_values_f pev
223: ,pay_assignment_actions pac
224: where pet.element_name ='House Rent Information'
225: and piv.name = 'JAN'
226: and pet.legislation_code ='IN'

Line 242: ,pay_element_entry_values_f pev

238: select pee.element_entry_id,pee.effective_end_date
239: from pay_element_types_f pet
240: ,pay_input_values_f piv
241: ,pay_element_entries_f pee
242: ,pay_element_entry_values_f pev
243: ,pay_assignment_actions pac
244: where pet.element_name ='House Rent Information'
245: and piv.name = 'JAN'
246: and pet.legislation_code ='IN'

Line 404: pay_element_entry_values_f pev,

400: bulk collect into
401: p_rent_paid ,
402: p_month
403: from pay_element_entries_f pee,
404: pay_element_entry_values_f pev,
405: pay_input_values_f piv
406: where pee.element_entry_id = p_element_entry_id
407: and pev.element_entry_id = pee.element_entry_id
408: and pee.element_type_id = piv.element_type_id

Line 1597: pay_element_entry_values_f pev,

1593:
1594: Cursor c_act_rent_paid(l_element_entry_id IN number,l_curr_mon IN Varchar2) is
1595: select pev.screen_entry_value
1596: from pay_element_entries_f pee,
1597: pay_element_entry_values_f pev,
1598: pay_input_values_f piv
1599: where pee.element_entry_id = l_element_entry_id
1600: and pev.element_entry_id = pee.element_entry_id
1601: and pee.element_type_id = piv.element_type_id

Line 2210: pay_element_entry_values_f peev

2206: pay_payroll_actions pa,
2207: pay_element_entries_f ee,
2208: pay_element_links_f el,
2209: pay_element_types_f et,
2210: pay_element_entry_values_f peev
2211: WHERE aa.payroll_action_id = pa.payroll_action_id
2212: AND aa.assignment_id = ee.assignment_id
2213: and ee.element_entry_id = peev.element_entry_id
2214: and peev.input_value_id = p_input_value_id

Line 2236: FROM pay_element_entry_values_f peev

2232: /* Cursor to find the screen entry value */
2233: CURSOR c_entry_values(l_entry_id NUMBER
2234: ,l_input_value_id NUMBER) IS
2235: SELECT peev.screen_entry_value
2236: FROM pay_element_entry_values_f peev
2237: WHERE peev.element_entry_id = l_entry_id
2238: AND peev.input_value_id = l_input_value_id
2239: AND p_date_earned between peev.effective_start_date and peev.effective_end_date;
2240: