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_ELEMENT_ENTRIES_F

Line 205: l_houserentinfo_entry_id pay_element_entries_f.element_entry_id%type :=-999;

201: p_year_end in date,
202: p_entry_id_type_flag out nocopy varchar2 ,
203: p_entry_end_date out nocopy date ) return number
204: is
205: l_houserentinfo_entry_id pay_element_entries_f.element_entry_id%type :=-999;
206:
207: l_entry_id_type_flag varchar2(2) ;
208: --
209: -- Note on usage of this flag

Line 221: ,pay_element_entries_f pee

217: is
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'

Line 241: ,pay_element_entries_f pee

237: is
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'

Line 374: (p_element_entry_id in pay_element_entries_f.element_entry_id%type ,

370: -- IN : --
371: -- --
372: --------------------------------------------------------------------------
373: PROCEDURE get_monthly_rent
374: (p_element_entry_id in pay_element_entries_f.element_entry_id%type ,
375: p_effective_date in date ,
376: p_entry_type_flag in varchar2,
377: p_entry_end_date in date ,
378: p_payroll_id in pay_all_payrolls_f.payroll_id%type,

Line 403: from pay_element_entries_f pee,

399: ,piv.name
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

Line 648: from pay_element_entries_f

644: from dual
645: where exists
646: (
647: select element_entry_id
648: from pay_element_entries_f
649: where element_entry_id=p_element_entry_id
650: and effective_start_date between p_year_start
651: and p_year_end
652: having count(element_entry_id) > 1

Line 656: from pay_element_entries_f

652: having count(element_entry_id) > 1
653: group by element_entry_id
654: union
655: select element_entry_id
656: from pay_element_entries_f
657: where element_entry_id=p_element_entry_id
658: and effective_start_date > p_year_start
659: and effective_start_date < p_year_end
660: );

Line 821: l_hri_entry_id pay_element_entries_f.element_entry_id%type;

817: l_taxable_hra_curr NUMBER ;
818: l_taxable_hra_proj NUMBER ;
819: l_exemption_on_hra NUMBER ;
820: l_metro_status varchar2(1);
821: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
822: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;
823: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;
824: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;
825: l_current_gre hr_soft_coding_keyflex.segment1%type;

Line 1596: from pay_element_entries_f pee,

1592: Return NUMBER is
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

Line 1609: l_hri_entry_id pay_element_entries_f.element_entry_id%type;

1605: and p_date_earned between pee.effective_start_date and pee.effective_end_date
1606: and p_date_earned between piv.effective_start_date and piv.effective_end_date;
1607:
1608:
1609: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
1610: l_rent_paid varchar2(10);
1611: l_year_start date;
1612: l_year_end date;
1613: l_entry_type_flag varchar2(2) ;

Line 1717: FROM pay_element_entries_f

1713: IS
1714: SELECT element_entry_id
1715: ,object_version_number
1716: ,effective_start_date
1717: FROM pay_element_entries_f
1718: WHERE assignment_id = p_assignment_id
1719: AND element_link_id = c_element_link_id
1720: AND p_effective_date BETWEEN effective_start_date
1721: AND effective_end_date ;

Line 1804: FROM pay_element_entries_f pee

1800:
1801: CURSOR c_get_earliest_start_Date
1802: IS
1803: SELECT MIN(pee.effective_start_date)
1804: FROM pay_element_entries_f pee
1805: WHERE pee.element_entry_id =p_element_entry_id
1806: AND pee.assignment_id =p_assignment_id
1807: AND pee.element_type_id =p_element_type_id;
1808:

Line 1994: l_hri_entry_id pay_element_entries_f.element_entry_id%type;

1990: l_rent_paid_tbl t_rent_paid ;
1991: l_month_tbl t_month ;
1992: l_year_start date;
1993: l_year_end date;
1994: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
1995: l_entry_type_flag varchar2(2) ;
1996: l_entry_end_date date;
1997:
1998: l3 number;

Line 2207: pay_element_entries_f ee,

2203: IS
2204: SELECT ee.element_entry_id
2205: FROM pay_assignment_actions aa,
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

Line 2285: TYPE tab_entry_id IS TABLE OF pay_element_entries_f.element_entry_id%TYPE INDEX BY BINARY_INTEGER;

2281: and prr.status in ('P','PA')
2282: and paa.payroll_action_id =ppa.payroll_action_id
2283: and ppa.date_earned BETWEEN p_start_date and p_end_date;
2284:
2285: TYPE tab_entry_id IS TABLE OF pay_element_entries_f.element_entry_id%TYPE INDEX BY BINARY_INTEGER;
2286: l_element_entry_id tab_entry_id;
2287: l_curr_element_entry tab_entry_id;
2288:
2289: l_max_ltc NUMBER;