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.BEN_EXT_THREAD dependencies on PAY_DATETRACKED_EVENTS

Line 2830: ,pay_datetracked_events pde

2826: cursor c_non_asg_crit is
2827: select 'X'
2828: from ben_ext_crit_typ ect
2829: ,ben_ext_crit_val ecv
2830: ,pay_datetracked_events pde
2831: ,pay_dated_tables pdt
2832: where ect.ext_crit_prfl_id = p_ext_crit_prfl_id
2833: and ect.crit_typ_cd = 'CPE'
2834: and ecv.ext_crit_typ_id = ect.ext_crit_typ_id

Line 2854: ,pay_datetracked_events pde

2850: cursor c_non_asg_tabel_id is
2851: select pde.dated_table_id,pde.business_group_id ,pde.LEGISLATION_CODE,pde.update_type
2852: from ben_ext_crit_typ ect
2853: ,ben_ext_crit_val ecv
2854: ,pay_datetracked_events pde
2855: ,pay_dated_tables pdt
2856: where ect.ext_crit_prfl_id = p_ext_crit_prfl_id
2857: and ect.crit_typ_cd = 'CPE'
2858: and ecv.ext_crit_typ_id = ect.ext_crit_typ_id

Line 4238: ' from pay_datetracked_events pde, ' ||

4234: -- END for Pensrv
4235: -- as per the babu sql
4236: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4237: ' (select pde.event_group_id ' ||
4238: ' from pay_datetracked_events pde, ' ||
4239: ' pay_event_updates peu ' ||
4240: -- BEGIN for Pensrv
4241: ' ,pay_dated_tables pdt '||
4242: -- END for Pensrv

Line 4304: ' from pay_datetracked_events pde, ' ||

4300: else
4301: -- as per the babu sql
4302: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4303: ' (select pde.event_group_id ' ||
4304: ' from pay_datetracked_events pde, ' ||
4305: ' pay_event_updates peu ' ||
4306: ' where ' ||
4307: --' and (pde.business_group_id = bg.organization_id OR (pde.business_group_id IS NULL ' ||
4308: --' and (pde.legislation_code is null or pde.legislation_code = bg.org_information9) ) ) ' ||