APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_MRTL_STAT_CVG_F

Line 12491: -- START OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------

12487: ---------------------------------------------------------------
12488: -- END OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------
12489: ---------------------------------------------------------------
12490: ---------------------------------------------------------------
12491: -- START OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------
12492: ---------------------------------------------------------------
12493: cursor c_ems_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12494: select elig_mrtl_stat_cvg_id
12495: from BEN_ELIG_MRTL_STAT_CVG_F

Line 12495: from BEN_ELIG_MRTL_STAT_CVG_F

12491: -- START OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------
12492: ---------------------------------------------------------------
12493: cursor c_ems_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12494: select elig_mrtl_stat_cvg_id
12495: from BEN_ELIG_MRTL_STAT_CVG_F
12496: where DPNT_CVG_ELIGY_PRFL_ID = c_DPNT_CVG_ELIGY_PRFL_ID ;
12497: --
12498: cursor c_ems(c_elig_mrtl_stat_cvg_id number,c_mirror_src_entity_result_id number ,
12499: c_table_alias varchar2 ) is

Line 12501: from BEN_ELIG_MRTL_STAT_CVG_F ems

12497: --
12498: cursor c_ems(c_elig_mrtl_stat_cvg_id number,c_mirror_src_entity_result_id number ,
12499: c_table_alias varchar2 ) is
12500: select ems.*
12501: from BEN_ELIG_MRTL_STAT_CVG_F ems
12502: where ems.elig_mrtl_stat_cvg_id = c_elig_mrtl_stat_cvg_id
12503: -- and ems.business_group_id = p_business_group_id
12504: and not exists (
12505: select /* */ null

Line 12512: -- and trt.where_clause = 'BEN_ELIG_MRTL_STAT_CVG_F'

12508: where copy_entity_txn_id = p_copy_entity_txn_id
12509: -- and trt.table_route_id = cpe.table_route_id
12510: and ( -- c_mirror_src_entity_result_id is null or
12511: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12512: -- and trt.where_clause = 'BEN_ELIG_MRTL_STAT_CVG_F'
12513: and cpe.table_alias = c_table_alias
12514: and information1 = c_elig_mrtl_stat_cvg_id
12515: -- and information4 = ems.business_group_id
12516: and information2 = ems.effective_start_date

Line 12522: -- END OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------

12518: );
12519: l_elig_mrtl_stat_cvg_id number(15);
12520: l_out_ems_result_id number(15);
12521: ---------------------------------------------------------------
12522: -- END OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------
12523: ---------------------------------------------------------------
12524: ---------------------------------------------------------------
12525: -- START OF BEN_ELIG_PSTL_CD_R_RNG_CVG_F ----------------------
12526: ---------------------------------------------------------------

Line 13505: -- START OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------

13501: ---------------------------------------------------------------
13502: -- END OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------
13503: ---------------------------------------------------------------
13504: ---------------------------------------------------------------
13505: -- START OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------
13506: ---------------------------------------------------------------
13507: --
13508: for l_parent_rec in c_ems_from_parent(l_DPNT_CVG_ELIGY_PRFL_ID) loop
13509: --

Line 13631: -- END OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------

13627: end loop;
13628: --
13629: end loop;
13630: ---------------------------------------------------------------
13631: -- END OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------
13632: ---------------------------------------------------------------
13633: ---------------------------------------------------------------
13634: -- START OF BEN_ELIG_PSTL_CD_R_RNG_CVG_F ----------------------
13635: ---------------------------------------------------------------