APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_LBR_MMBR_RT_F

Line 6287: -- START OF BEN_LBR_MMBR_RT_F ----------------------

6283: ---------------------------------------------------------------
6284: -- END OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
6285: ---------------------------------------------------------------
6286: ---------------------------------------------------------------
6287: -- START OF BEN_LBR_MMBR_RT_F ----------------------
6288: ---------------------------------------------------------------
6289: cursor c_lmm_from_parent(c_VRBL_RT_PRFL_ID number) is
6290: select lbr_mmbr_rt_id
6291: from BEN_LBR_MMBR_RT_F

Line 6291: from BEN_LBR_MMBR_RT_F

6287: -- START OF BEN_LBR_MMBR_RT_F ----------------------
6288: ---------------------------------------------------------------
6289: cursor c_lmm_from_parent(c_VRBL_RT_PRFL_ID number) is
6290: select lbr_mmbr_rt_id
6291: from BEN_LBR_MMBR_RT_F
6292: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6293: --
6294: cursor c_lmm(c_lbr_mmbr_rt_id number,c_mirror_src_entity_result_id number,
6295: c_table_alias varchar2 ) is

Line 6297: from BEN_LBR_MMBR_RT_F lmm

6293: --
6294: cursor c_lmm(c_lbr_mmbr_rt_id number,c_mirror_src_entity_result_id number,
6295: c_table_alias varchar2 ) is
6296: select lmm.*
6297: from BEN_LBR_MMBR_RT_F lmm
6298: where lmm.lbr_mmbr_rt_id = c_lbr_mmbr_rt_id
6299: -- and lmm.business_group_id = p_business_group_id
6300: and not exists (
6301: select /* */ null

Line 6308: -- and trt.where_clause = 'BEN_LBR_MMBR_RT_F'

6304: where copy_entity_txn_id = p_copy_entity_txn_id
6305: -- and trt.table_route_id = cpe.table_route_id
6306: and ( -- c_mirror_src_entity_result_id is null or
6307: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6308: -- and trt.where_clause = 'BEN_LBR_MMBR_RT_F'
6309: and cpe.table_alias = c_table_alias
6310: and information1 = c_lbr_mmbr_rt_id
6311: -- and information4 = lmm.business_group_id
6312: and information2 = lmm.effective_start_date

Line 6317: -- END OF BEN_LBR_MMBR_RT_F ----------------------

6313: and information3 = lmm.effective_end_date);
6314: l_lbr_mmbr_rt_id number(15);
6315: l_out_lmm_result_id number(15);
6316: ---------------------------------------------------------------
6317: -- END OF BEN_LBR_MMBR_RT_F ----------------------
6318: ---------------------------------------------------------------
6319: ---------------------------------------------------------------
6320: -- START OF BEN_LGL_ENTY_RT_F ----------------------
6321: ---------------------------------------------------------------

Line 9860: -- START OF BEN_LBR_MMBR_RT_F ----------------------

9856: ---------------------------------------------------------------
9857: -- END OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
9858: ---------------------------------------------------------------
9859: ---------------------------------------------------------------
9860: -- START OF BEN_LBR_MMBR_RT_F ----------------------
9861: ---------------------------------------------------------------
9862: --
9863: for l_parent_rec in c_lmm_from_parent(l_VRBL_RT_PRFL_ID) loop
9864: --

Line 9960: -- END OF BEN_LBR_MMBR_RT_F ----------------------

9956: end loop;
9957: --
9958: end loop;
9959: ---------------------------------------------------------------
9960: -- END OF BEN_LBR_MMBR_RT_F ----------------------
9961: ---------------------------------------------------------------
9962: ---------------------------------------------------------------
9963: -- START OF BEN_LGL_ENTY_RT_F ----------------------
9964: ---------------------------------------------------------------