APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_NO_OTHR_CVG_RT_F

Line 7739: -- START OF BEN_NO_OTHR_CVG_RT_F ----------------------

7735: ---------------------------------------------------------------
7736: -- END OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------
7737: ---------------------------------------------------------------
7738: ---------------------------------------------------------------
7739: -- START OF BEN_NO_OTHR_CVG_RT_F ----------------------
7740: ---------------------------------------------------------------
7741: cursor c_noc_from_parent(c_VRBL_RT_PRFL_ID number) is
7742: select no_othr_cvg_rt_id
7743: from BEN_NO_OTHR_CVG_RT_F

Line 7743: from BEN_NO_OTHR_CVG_RT_F

7739: -- START OF BEN_NO_OTHR_CVG_RT_F ----------------------
7740: ---------------------------------------------------------------
7741: cursor c_noc_from_parent(c_VRBL_RT_PRFL_ID number) is
7742: select no_othr_cvg_rt_id
7743: from BEN_NO_OTHR_CVG_RT_F
7744: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7745: --
7746: cursor c_noc(c_no_othr_cvg_rt_id number,c_mirror_src_entity_result_id number, c_table_alias varchar2 ) is
7747: select noc.*

Line 7748: from BEN_NO_OTHR_CVG_RT_F noc

7744: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7745: --
7746: cursor c_noc(c_no_othr_cvg_rt_id number,c_mirror_src_entity_result_id number, c_table_alias varchar2 ) is
7747: select noc.*
7748: from BEN_NO_OTHR_CVG_RT_F noc
7749: where noc.no_othr_cvg_rt_id = c_no_othr_cvg_rt_id
7750: --and noc.business_group_id = p_business_group_id
7751: and not exists (
7752: select /* */ null

Line 7759: -- and trt.where_clause = 'BEN_NO_OTHR_CVG_RT_F'

7755: where copy_entity_txn_id = p_copy_entity_txn_id
7756: -- and trt.table_route_id = cpe.table_route_id
7757: and ( -- c_mirror_src_entity_result_id is null or
7758: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7759: -- and trt.where_clause = 'BEN_NO_OTHR_CVG_RT_F'
7760: and cpe.table_alias = c_table_alias
7761: and information1 = c_no_othr_cvg_rt_id
7762: -- and information4 = noc.business_group_id
7763: and information2 = noc.effective_start_date

Line 7768: -- END OF BEN_NO_OTHR_CVG_RT_F ----------------------

7764: and information3 = noc.effective_end_date);
7765: l_no_othr_cvg_rt_id number(15);
7766: l_out_noc_result_id number(15);
7767: ---------------------------------------------------------------
7768: -- END OF BEN_NO_OTHR_CVG_RT_F ----------------------
7769: ---------------------------------------------------------------
7770: ---------------------------------------------------------------
7771: -- START OF BEN_OPTD_MDCR_RT_F ----------------------
7772: ---------------------------------------------------------------

Line 14463: -- START OF BEN_NO_OTHR_CVG_RT_F ----------------------

14459: ---------------------------------------------------------------
14460: -- END OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------
14461: ---------------------------------------------------------------
14462: ---------------------------------------------------------------
14463: -- START OF BEN_NO_OTHR_CVG_RT_F ----------------------
14464: ---------------------------------------------------------------
14465: --
14466: for l_parent_rec in c_noc_from_parent(l_VRBL_RT_PRFL_ID) loop
14467: --

Line 14559: -- END OF BEN_NO_OTHR_CVG_RT_F ----------------------

14555: end loop;
14556: --
14557: end loop;
14558: ---------------------------------------------------------------
14559: -- END OF BEN_NO_OTHR_CVG_RT_F ----------------------
14560: ---------------------------------------------------------------
14561: ---------------------------------------------------------------
14562: -- START OF BEN_OPTD_MDCR_RT_F ----------------------
14563: ---------------------------------------------------------------