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 2828: ,pay_datetracked_events pde

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

Line 2852: ,pay_datetracked_events pde

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

Line 4236: ' from pay_datetracked_events pde, ' ||

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

Line 4302: ' from pay_datetracked_events pde, ' ||

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