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 327: l_houserentinfo_entry_id pay_element_entries_f.element_entry_id%type :=-999;

323: p_year_end in date,
324: p_entry_id_type_flag out nocopy varchar2 ,
325: p_entry_end_date out nocopy date ) return number
326: is
327: l_houserentinfo_entry_id pay_element_entries_f.element_entry_id%type :=-999;
328:
329: l_entry_id_type_flag varchar2(2) ;
330: --
331: -- Note on usage of this flag

Line 343: ,pay_element_entries_f pee

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'
347: and piv.name = 'JAN'

Line 363: ,pay_element_entries_f pee

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'
367: and piv.name = 'JAN'

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

498: -- IN : --
499: -- --
500: --------------------------------------------------------------------------
501: PROCEDURE get_monthly_rent
502: (p_element_entry_id in pay_element_entries_f.element_entry_id%type ,
503: p_effective_date in date ,
504: p_entry_type_flag in varchar2,
505: p_entry_end_date in date ,
506: p_payroll_id in pay_all_payrolls_f.payroll_id%type,

Line 516: ,pay_element_entries_f pee

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'
520: and piv.name = 'JAN'

Line 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

528: and l_prev_effective_date between piv.effective_start_date and piv.effective_end_date
529: and l_prev_effective_date between pee.effective_start_date and pee.effective_end_date ;
530:
531:
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,

Line 535: from pay_element_entries_f pee,

531:
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

Line 554: l_prev_element_entry_id pay_element_entries_f.element_entry_id%type :=-999;

550: l_date_offset number;
551: l_rent_paid number;
552: l_month varchar2(6);
553: l_prev_house_rent_entry_date date;
554: l_prev_element_entry_id pay_element_entries_f.element_entry_id%type :=-999;
555: l_pub_sect_flag VARCHAR2(20);
556:
557: BEGIN
558: l_procedure := g_package ||'get_monthly_rent';

Line 606: from pay_element_entries_f pee,

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

Line 659: from pay_element_entries_f pee,

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

Line 959: from pay_element_entries_f

955: from dual
956: where exists
957: (
958: select element_entry_id
959: from pay_element_entries_f
960: where element_entry_id=p_element_entry_id
961: and effective_start_date between p_year_start
962: and p_year_end
963: having count(element_entry_id) > 1

Line 967: from pay_element_entries_f

963: having count(element_entry_id) > 1
964: group by element_entry_id
965: union
966: select element_entry_id
967: from pay_element_entries_f
968: where element_entry_id=p_element_entry_id
969: and effective_start_date > p_year_start
970: and effective_start_date < p_year_end
971: );

Line 1136: l_hri_entry_id pay_element_entries_f.element_entry_id%type;

1132: l_taxable_hra_curr NUMBER ;
1133: l_taxable_hra_proj NUMBER ;
1134: l_exemption_on_hra NUMBER ;
1135: l_metro_status varchar2(1);
1136: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
1137: l_ret_tax_hra_def_bal_id pay_defined_balances.defined_balance_id%type; -- Bug 11821281
1138: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;
1139: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;
1140: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;

Line 2007: from pay_element_entries_f pee,

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

Line 2020: l_hri_entry_id pay_element_entries_f.element_entry_id%type;

2016: and p_date_earned between pee.effective_start_date and pee.effective_end_date
2017: and p_date_earned between piv.effective_start_date and piv.effective_end_date;
2018:
2019:
2020: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
2021: l_rent_paid varchar2(10);
2022: l_year_start date;
2023: l_year_end date;
2024: l_entry_type_flag varchar2(2) ;

Line 2128: FROM pay_element_entries_f

2124: IS
2125: SELECT element_entry_id
2126: ,object_version_number
2127: ,effective_start_date
2128: FROM pay_element_entries_f
2129: WHERE assignment_id = p_assignment_id
2130: AND element_link_id = c_element_link_id
2131: AND p_effective_date BETWEEN effective_start_date
2132: AND effective_end_date ;

Line 2215: FROM pay_element_entries_f pee

2211:
2212: CURSOR c_get_earliest_start_Date
2213: IS
2214: SELECT MIN(pee.effective_start_date)
2215: FROM pay_element_entries_f pee
2216: WHERE pee.element_entry_id =p_element_entry_id
2217: AND pee.assignment_id =p_assignment_id
2218: AND pee.element_type_id =p_element_type_id;
2219:

Line 2405: l_hri_entry_id pay_element_entries_f.element_entry_id%type;

2401: l_rent_paid_tbl t_rent_paid ;
2402: l_month_tbl t_month ;
2403: l_year_start date;
2404: l_year_end date;
2405: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
2406: l_entry_type_flag varchar2(2) ;
2407: l_entry_end_date date;
2408:
2409: l3 number;

Line 2449: from pay_element_entries_f pee,

2445: ,c_effective_date DATE
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

Line 2642: pay_element_entries_f ee,

2638: IS
2639: SELECT ee.element_entry_id
2640: FROM pay_assignment_actions aa,
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

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

2717: and prr.status in ('P','PA')
2718: and paa.payroll_action_id =ppa.payroll_action_id
2719: and ppa.date_earned BETWEEN p_start_date and p_end_date;
2720:
2721: TYPE tab_entry_id IS TABLE OF pay_element_entries_f.element_entry_id%TYPE INDEX BY BINARY_INTEGER;
2722: l_element_entry_id tab_entry_id;
2723: l_curr_element_entry tab_entry_id;
2724:
2725: l_max_ltc NUMBER;