APPS.BEN_EXT_THREAD dependencies on PAY_DATED_TABLES

Line 2829: ,pay_dated_tables pdt

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
2833: and pde.event_group_id = to_number(ecv.val_1)

Line 2853: ,pay_dated_tables pdt

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
2857: and pde.event_group_id = to_number(ecv.val_1)

Line 2872: l_dated_table_id pay_dated_tables.dated_table_id%type ;

2868: ;
2869:
2870: l_result varchar2(1) ;
2871: l_dummy varchar2(1) ;
2872: l_dated_table_id pay_dated_tables.dated_table_id%type ;
2873: l_update_type varchar2(10) ;
2874: l_legislation_code varchar2(35) ;
2875: l_sql varchar2(4000) ;
2876: l_adv_sql varchar2(4000) ;

Line 4239: ' ,pay_dated_tables pdt '||

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
4241: ' where ' ||
4242: --' and (pde.business_group_id = bg.organization_id OR (pde.business_group_id IS NULL ' ||
4243: --' and (pde.legislation_code is null or pde.legislation_code = bg.org_information9) ) ) ' ||