APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_DPNT_OTHR_PTIP_RT_F

Line 7804: -- START OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------

7800: ---------------------------------------------------------------
7801: -- END OF BEN_OPTD_MDCR_RT_F ----------------------
7802: ---------------------------------------------------------------
7803: ---------------------------------------------------------------
7804: -- START OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------
7805: ---------------------------------------------------------------
7806: cursor c_dot_from_parent(c_VRBL_RT_PRFL_ID number) is
7807: select dpnt_othr_ptip_rt_id
7808: from BEN_DPNT_OTHR_PTIP_RT_F

Line 7808: from BEN_DPNT_OTHR_PTIP_RT_F

7804: -- START OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------
7805: ---------------------------------------------------------------
7806: cursor c_dot_from_parent(c_VRBL_RT_PRFL_ID number) is
7807: select dpnt_othr_ptip_rt_id
7808: from BEN_DPNT_OTHR_PTIP_RT_F
7809: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7810: --
7811: cursor c_dot(c_dpnt_othr_ptip_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7812: select dot.*

Line 7813: from BEN_DPNT_OTHR_PTIP_RT_F dot

7809: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7810: --
7811: cursor c_dot(c_dpnt_othr_ptip_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7812: select dot.*
7813: from BEN_DPNT_OTHR_PTIP_RT_F dot
7814: where dot.dpnt_othr_ptip_rt_id = c_dpnt_othr_ptip_rt_id
7815: --and dot.business_group_id = p_business_group_id
7816: and not exists (
7817: select /* */ null

Line 7824: -- and trt.where_clause = 'BEN_DPNT_OTHR_PTIP_RT_F'

7820: where copy_entity_txn_id = p_copy_entity_txn_id
7821: -- and trt.table_route_id = cpe.table_route_id
7822: and ( -- c_mirror_src_entity_result_id is null or
7823: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7824: -- and trt.where_clause = 'BEN_DPNT_OTHR_PTIP_RT_F'
7825: and cpe.table_alias = c_table_alias
7826: and information1 = c_dpnt_othr_ptip_rt_id
7827: -- and information4 = dot.business_group_id
7828: and information2 = dot.effective_start_date

Line 7833: -- END OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------

7829: and information3 = dot.effective_end_date);
7830: l_dpnt_othr_ptip_rt_id number(15);
7831: l_out_dot_result_id number(15);
7832: ---------------------------------------------------------------
7833: -- END OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------
7834: ---------------------------------------------------------------
7835: ---------------------------------------------------------------
7836: -- START OF BEN_PERF_RTNG_RT_F ----------------------
7837: ---------------------------------------------------------------

Line 14662: -- START OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------

14658: ---------------------------------------------------------------
14659: -- END OF BEN_OPTD_MDCR_RT_F ----------------------
14660: ---------------------------------------------------------------
14661: ---------------------------------------------------------------
14662: -- START OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------
14663: ---------------------------------------------------------------
14664: --
14665: for l_parent_rec in c_dot_from_parent(l_VRBL_RT_PRFL_ID) loop
14666: --

Line 14759: -- END OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------

14755: end loop;
14756: --
14757: end loop;
14758: ---------------------------------------------------------------
14759: -- END OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------
14760: ---------------------------------------------------------------
14761: ---------------------------------------------------------------
14762: -- START OF BEN_PERF_RTNG_RT_F ----------------------
14763: ---------------------------------------------------------------