eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_TAX_UTILS dependencies on PAY_INPUT_VALUES_F

Line 342: ,pay_input_values_f piv

338: cursor c_ele_id
339: is
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'

Line 362: ,pay_input_values_f piv

358: cursor c_ele_id_latest
359: is
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'

Line 515: ,pay_input_values_f piv

511:
512: cursor get_house_rent_entry_id(l_prev_effective_date in date) is
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'

Line 537: pay_input_values_f piv

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
541: and piv.name = 'MAR'

Line 608: pay_input_values_f piv

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
612: and pev.input_value_id = piv.input_value_id

Line 661: pay_input_values_f piv

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
665: and pev.input_value_id = piv.input_value_id

Line 2009: pay_input_values_f piv

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
2013: and pev.input_value_id = piv.input_value_id

Line 2423: l_input_name pay_input_values_f.name%TYPE;

2419: l_hra number;
2420: l_curr_period_num number;
2421: l_80gg_flag VARCHAR2(3);
2422: l_element_name pay_element_types_f.element_name %TYPE;
2423: l_input_name pay_input_values_f.name%TYPE;
2424:
2425: CURSOR c_claim_80gg_flag(c_assignment_action_id NUMBER
2426: ,c_element_name IN VARCHAR2
2427: ,c_input_name IN VARCHAR2) IS

Line 2431: pay_input_values_f piv,

2427: ,c_input_name IN VARCHAR2) IS
2428: SELECT prv.result_value
2429: FROM pay_run_result_values prv,
2430: pay_run_results prr,
2431: pay_input_values_f piv,
2432: pay_element_types_f pet
2433: WHERE prv.run_result_id = prr.run_result_id
2434: AND prr.assignment_action_id = c_assignment_action_id
2435: AND prr.element_type_id = pet.element_type_id

Line 2451: pay_input_values_f piv,

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
2455: and pee.element_type_id = piv.element_type_id

Line 2681: FROM pay_input_values_f piv

2677: /* Cursor to find input value id given the element and input value name*/
2678: CURSOR c_input_value_id(p_input_name VARCHAR2)
2679: IS
2680: SELECT piv.input_value_id
2681: FROM pay_input_values_f piv
2682: WHERE piv.element_type_id = p_element_type_id
2683: AND piv.NAME = p_input_name
2684: AND p_date_earned BETWEEN piv.effective_start_date AND piv.effective_end_date;
2685: