APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_DPNT_CVRD_OTHR_PGM_RT_F

Line 7515: -- START OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------

7511: ---------------------------------------------------------------
7512: -- END OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------
7513: ---------------------------------------------------------------
7514: ---------------------------------------------------------------
7515: -- START OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------
7516: ---------------------------------------------------------------
7517: cursor c_dop_from_parent(c_VRBL_RT_PRFL_ID number) is
7518: select dpnt_cvrd_othr_pgm_rt_id
7519: from BEN_DPNT_CVRD_OTHR_PGM_RT_F

Line 7519: from BEN_DPNT_CVRD_OTHR_PGM_RT_F

7515: -- START OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------
7516: ---------------------------------------------------------------
7517: cursor c_dop_from_parent(c_VRBL_RT_PRFL_ID number) is
7518: select dpnt_cvrd_othr_pgm_rt_id
7519: from BEN_DPNT_CVRD_OTHR_PGM_RT_F
7520: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7521: --
7522: cursor c_dop(c_dpnt_cvrd_othr_pgm_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7523: select dop.*

Line 7524: from BEN_DPNT_CVRD_OTHR_PGM_RT_F dop

7520: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7521: --
7522: cursor c_dop(c_dpnt_cvrd_othr_pgm_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7523: select dop.*
7524: from BEN_DPNT_CVRD_OTHR_PGM_RT_F dop
7525: where dop.dpnt_cvrd_othr_pgm_rt_id = c_dpnt_cvrd_othr_pgm_rt_id
7526: --and dop.business_group_id = p_business_group_id
7527: and not exists (
7528: select /* */ null

Line 7535: -- and trt.where_clause = 'BEN_DPNT_CVRD_OTHR_PGM_RT_F'

7531: where copy_entity_txn_id = p_copy_entity_txn_id
7532: -- and trt.table_route_id = cpe.table_route_id
7533: and ( -- c_mirror_src_entity_result_id is null or
7534: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7535: -- and trt.where_clause = 'BEN_DPNT_CVRD_OTHR_PGM_RT_F'
7536: and cpe.table_alias = c_table_alias
7537: and information1 = c_dpnt_cvrd_othr_pgm_rt_id
7538: -- and information4 = dop.business_group_id
7539: and information2 = dop.effective_start_date

Line 7544: -- END OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------

7540: and information3 = dop.effective_end_date);
7541: l_dpnt_cvrd_othr_pgm_rt_id number(15);
7542: l_out_dop_result_id number(15);
7543: ---------------------------------------------------------------
7544: -- END OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------
7545: ---------------------------------------------------------------
7546: ---------------------------------------------------------------
7547: -- START OF BEN_PRTT_ANTHR_PL_RT_F ----------------------
7548: ---------------------------------------------------------------

Line 13748: -- START OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------

13744: ---------------------------------------------------------------
13745: -- END OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------
13746: ---------------------------------------------------------------
13747: ---------------------------------------------------------------
13748: -- START OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------
13749: ---------------------------------------------------------------
13750: --
13751: for l_parent_rec in c_dop_from_parent(l_VRBL_RT_PRFL_ID) loop
13752: --

Line 13848: -- END OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------

13844: end loop;
13845: --
13846: end loop;
13847: ---------------------------------------------------------------
13848: -- END OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------
13849: ---------------------------------------------------------------
13850: ---------------------------------------------------------------
13851: -- START OF BEN_PRTT_ANTHR_PL_RT_F ----------------------
13852: ---------------------------------------------------------------