APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_DSBLD_STAT_CVG_F

Line 12423: -- START OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------

12419: ---------------------------------------------------------------
12420: -- END OF BEN_ELIG_AGE_CVG_F ----------------------
12421: ---------------------------------------------------------------
12422: ---------------------------------------------------------------
12423: -- START OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------
12424: ---------------------------------------------------------------
12425: cursor c_edc_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12426: select elig_dsbld_stat_cvg_id
12427: from BEN_ELIG_DSBLD_STAT_CVG_F

Line 12427: from BEN_ELIG_DSBLD_STAT_CVG_F

12423: -- START OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------
12424: ---------------------------------------------------------------
12425: cursor c_edc_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12426: select elig_dsbld_stat_cvg_id
12427: from BEN_ELIG_DSBLD_STAT_CVG_F
12428: where DPNT_CVG_ELIGY_PRFL_ID = c_DPNT_CVG_ELIGY_PRFL_ID ;
12429: --
12430: cursor c_edc(c_elig_dsbld_stat_cvg_id number,c_mirror_src_entity_result_id number ,
12431: c_table_alias varchar2 ) is

Line 12433: from BEN_ELIG_DSBLD_STAT_CVG_F edc

12429: --
12430: cursor c_edc(c_elig_dsbld_stat_cvg_id number,c_mirror_src_entity_result_id number ,
12431: c_table_alias varchar2 ) is
12432: select edc.*
12433: from BEN_ELIG_DSBLD_STAT_CVG_F edc
12434: where edc.elig_dsbld_stat_cvg_id = c_elig_dsbld_stat_cvg_id
12435: -- and edc.business_group_id = p_business_group_id
12436: and not exists (
12437: select /* */ null

Line 12444: -- and trt.where_clause = 'BEN_ELIG_DSBLD_STAT_CVG_F'

12440: where copy_entity_txn_id = p_copy_entity_txn_id
12441: -- and trt.table_route_id = cpe.table_route_id
12442: and ( -- c_mirror_src_entity_result_id is null or
12443: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12444: -- and trt.where_clause = 'BEN_ELIG_DSBLD_STAT_CVG_F'
12445: and cpe.table_alias = c_table_alias
12446: and information1 = c_elig_dsbld_stat_cvg_id
12447: -- and information4 = edc.business_group_id
12448: and information2 = edc.effective_start_date

Line 12454: -- END OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------

12450: );
12451: l_elig_dsbld_stat_cvg_id number(15);
12452: l_out_edc_result_id number(15);
12453: ---------------------------------------------------------------
12454: -- END OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------
12455: ---------------------------------------------------------------
12456: ---------------------------------------------------------------
12457: -- START OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------
12458: ---------------------------------------------------------------

Line 13247: -- START OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------

13243: ---------------------------------------------------------------
13244: -- END OF BEN_ELIG_AGE_CVG_F ----------------------
13245: ---------------------------------------------------------------
13246: ---------------------------------------------------------------
13247: -- START OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------
13248: ---------------------------------------------------------------
13249: --
13250: for l_parent_rec in c_edc_from_parent(l_DPNT_CVG_ELIGY_PRFL_ID) loop
13251: --

Line 13372: -- END OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------

13368: end loop;
13369: --
13370: end loop;
13371: ---------------------------------------------------------------
13372: -- END OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------
13373: ---------------------------------------------------------------
13374: ---------------------------------------------------------------
13375: -- START OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------
13376: ---------------------------------------------------------------