APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_DSGNTR_ENRLD_CVG_F

Line 12341: -- START OF BEN_DSGNTR_ENRLD_CVG_F ----------------------

12337: ---------------------------------------------------------------
12338: -- END OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------
12339: ---------------------------------------------------------------
12340: ---------------------------------------------------------------
12341: -- START OF BEN_DSGNTR_ENRLD_CVG_F ----------------------
12342: ---------------------------------------------------------------
12343: cursor c_dec_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12344: select dsgntr_enrld_cvg_id
12345: from BEN_DSGNTR_ENRLD_CVG_F

Line 12345: from BEN_DSGNTR_ENRLD_CVG_F

12341: -- START OF BEN_DSGNTR_ENRLD_CVG_F ----------------------
12342: ---------------------------------------------------------------
12343: cursor c_dec_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12344: select dsgntr_enrld_cvg_id
12345: from BEN_DSGNTR_ENRLD_CVG_F
12346: where DPNT_CVG_ELIGY_PRFL_ID = c_DPNT_CVG_ELIGY_PRFL_ID ;
12347: --
12348: cursor c_dec(c_dsgntr_enrld_cvg_id number,c_mirror_src_entity_result_id number ,
12349: c_table_alias varchar2 ) is

Line 12351: from BEN_DSGNTR_ENRLD_CVG_F dec

12347: --
12348: cursor c_dec(c_dsgntr_enrld_cvg_id number,c_mirror_src_entity_result_id number ,
12349: c_table_alias varchar2 ) is
12350: select dec.*
12351: from BEN_DSGNTR_ENRLD_CVG_F dec
12352: where dec.dsgntr_enrld_cvg_id = c_dsgntr_enrld_cvg_id
12353: -- and dec.business_group_id = p_business_group_id
12354: and not exists (
12355: select /* */ null

Line 12362: -- and trt.where_clause = 'BEN_DSGNTR_ENRLD_CVG_F'

12358: where copy_entity_txn_id = p_copy_entity_txn_id
12359: -- and trt.table_route_id = cpe.table_route_id
12360: and ( -- c_mirror_src_entity_result_id is null or
12361: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12362: -- and trt.where_clause = 'BEN_DSGNTR_ENRLD_CVG_F'
12363: and cpe.table_alias = c_table_alias
12364: and information1 = c_dsgntr_enrld_cvg_id
12365: -- and information4 = dec.business_group_id
12366: and information2 = dec.effective_start_date

Line 12372: -- END OF BEN_DSGNTR_ENRLD_CVG_F ----------------------

12368: );
12369: l_dsgntr_enrld_cvg_id number(15);
12370: l_out_dec_result_id number(15);
12371: ---------------------------------------------------------------
12372: -- END OF BEN_DSGNTR_ENRLD_CVG_F ----------------------
12373: ---------------------------------------------------------------
12374: ---------------------------------------------------------------
12375: -- START OF BEN_ELIG_AGE_CVG_F ----------------------
12376: ---------------------------------------------------------------

Line 12999: -- START OF BEN_DSGNTR_ENRLD_CVG_F ----------------------

12995: ---------------------------------------------------------------
12996: -- END OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------
12997: ---------------------------------------------------------------
12998: ---------------------------------------------------------------
12999: -- START OF BEN_DSGNTR_ENRLD_CVG_F ----------------------
13000: ---------------------------------------------------------------
13001: --
13002: for l_parent_rec in c_dec_from_parent(l_DPNT_CVG_ELIGY_PRFL_ID) loop
13003: --

Line 13096: -- END OF BEN_DSGNTR_ENRLD_CVG_F ----------------------

13092: end loop;
13093: --
13094: end loop;
13095: ---------------------------------------------------------------
13096: -- END OF BEN_DSGNTR_ENRLD_CVG_F ----------------------
13097: ---------------------------------------------------------------
13098: ---------------------------------------------------------------
13099: -- START OF BEN_ELIG_AGE_CVG_F ----------------------
13100: ---------------------------------------------------------------