APPS.PAY_IN_TAX_UTILS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 344: ,pay_element_entry_values_f pev

340: select pee.element_entry_id,pee.effective_end_date
341: from pay_element_types_f pet
342: ,pay_input_values_f piv
343: ,pay_element_entries_f pee
344: ,pay_element_entry_values_f pev
345: ,pay_assignment_actions pac
346: where pet.element_name ='House Rent Information'
347: and piv.name = 'JAN'
348: and pet.legislation_code ='IN'

Line 364: ,pay_element_entry_values_f pev

360: select pee.element_entry_id,pee.effective_end_date
361: from pay_element_types_f pet
362: ,pay_input_values_f piv
363: ,pay_element_entries_f pee
364: ,pay_element_entry_values_f pev
365: ,pay_assignment_actions pac
366: where pet.element_name ='House Rent Information'
367: and piv.name = 'JAN'
368: and pet.legislation_code ='IN'

Line 517: ,pay_element_entry_values_f pev

513: select pee.element_entry_id
514: from pay_element_types_f pet
515: ,pay_input_values_f piv
516: ,pay_element_entries_f pee
517: ,pay_element_entry_values_f pev
518: ,pay_assignment_actions pac
519: where pet.element_name ='House Rent Information'
520: and piv.name = 'JAN'
521: and pet.legislation_code ='IN'

Line 536: pay_element_entry_values_f pev,

532: cursor get_mar_month_rent (l_effective_date in date, p_element_entry_id in pay_element_entries_f.element_entry_id%type) is
533: select nvl(pev.screen_entry_value,0)
534: ,piv.name
535: from pay_element_entries_f pee,
536: pay_element_entry_values_f pev,
537: pay_input_values_f piv
538: where pee.element_entry_id = p_element_entry_id
539: and pev.element_entry_id = pee.element_entry_id
540: and pee.element_type_id = piv.element_type_id

Line 607: pay_element_entry_values_f pev,

603: bulk collect into
604: p_rent_paid ,
605: p_month
606: from pay_element_entries_f pee,
607: pay_element_entry_values_f pev,
608: pay_input_values_f piv
609: where pee.element_entry_id = p_element_entry_id
610: and pev.element_entry_id = pee.element_entry_id
611: and pee.element_type_id = piv.element_type_id

Line 660: pay_element_entry_values_f pev,

656: bulk collect into
657: p_rent_paid ,
658: p_month
659: from pay_element_entries_f pee,
660: pay_element_entry_values_f pev,
661: pay_input_values_f piv
662: where pee.element_entry_id = p_element_entry_id
663: and pev.element_entry_id = pee.element_entry_id
664: and pee.element_type_id = piv.element_type_id

Line 2008: pay_element_entry_values_f pev,

2004:
2005: Cursor c_act_rent_paid(l_element_entry_id IN number,l_curr_mon IN Varchar2) is
2006: select pev.screen_entry_value
2007: from pay_element_entries_f pee,
2008: pay_element_entry_values_f pev,
2009: pay_input_values_f piv
2010: where pee.element_entry_id = l_element_entry_id
2011: and pev.element_entry_id = pee.element_entry_id
2012: and pee.element_type_id = piv.element_type_id

Line 2450: pay_element_entry_values_f pev,

2446: ,c_element_name IN VARCHAR2
2447: ,c_input_name IN VARCHAR2) IS
2448: select pev.screen_entry_value
2449: from pay_element_entries_f pee,
2450: pay_element_entry_values_f pev,
2451: pay_input_values_f piv,
2452: pay_element_types_f pet
2453: ,pay_assignment_actions paa
2454: where pev.element_entry_id = pee.element_entry_id

Line 2645: pay_element_entry_values_f peev

2641: pay_payroll_actions pa,
2642: pay_element_entries_f ee,
2643: pay_element_links_f el,
2644: pay_element_types_f et,
2645: pay_element_entry_values_f peev
2646: WHERE aa.payroll_action_id = pa.payroll_action_id
2647: AND aa.assignment_id = ee.assignment_id
2648: and ee.element_entry_id = peev.element_entry_id
2649: and peev.input_value_id = p_input_value_id

Line 2672: FROM pay_element_entry_values_f peev

2668: /* Cursor to find the screen entry value */
2669: CURSOR c_entry_values(l_entry_id NUMBER
2670: ,l_input_value_id NUMBER) IS
2671: SELECT peev.screen_entry_value
2672: FROM pay_element_entry_values_f peev
2673: WHERE peev.element_entry_id = l_entry_id
2674: AND peev.input_value_id = l_input_value_id
2675: AND p_date_earned between peev.effective_start_date and peev.effective_end_date;
2676: