APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_LER_BNFT_RSTRN_F

Line 373: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------

369: -- END OF BEN_BNFT_RSTRN_CTFN_F ----------------------
370: ---------------------------------------------------------------
371: ---
372: ---------------------------------------------------------------
373: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------
374: ---------------------------------------------------------------
375: cursor c_lbr_from_parent(c_PL_ID number) is
376: select distinct ler_bnft_rstrn_id
377: from BEN_LER_BNFT_RSTRN_F

Line 377: from BEN_LER_BNFT_RSTRN_F

373: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------
374: ---------------------------------------------------------------
375: cursor c_lbr_from_parent(c_PL_ID number) is
376: select distinct ler_bnft_rstrn_id
377: from BEN_LER_BNFT_RSTRN_F
378: where PL_ID = c_PL_ID ;
379: --
380: cursor c_lbr(c_ler_bnft_rstrn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
381: select lbr.*

Line 382: from BEN_LER_BNFT_RSTRN_F lbr

378: where PL_ID = c_PL_ID ;
379: --
380: cursor c_lbr(c_ler_bnft_rstrn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
381: select lbr.*
382: from BEN_LER_BNFT_RSTRN_F lbr
383: where lbr.ler_bnft_rstrn_id = c_ler_bnft_rstrn_id
384: -- and lbr.business_group_id = p_business_group_id
385: and not exists (
386: select /*+ */ null

Line 393: -- and trt.where_clause = 'BEN_LER_BNFT_RSTRN_F'

389: where copy_entity_txn_id = p_copy_entity_txn_id
390: -- and trt.table_route_id = cpe.table_route_id
391: and ( -- c_mirror_src_entity_result_id is null or
392: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
393: -- and trt.where_clause = 'BEN_LER_BNFT_RSTRN_F'
394: and cpe.table_alias = c_table_alias
395: and information1 = c_ler_bnft_rstrn_id
396: -- and information4 = lbr.business_group_id
397: and information2 = lbr.effective_start_date

Line 407: -- and trt.where_clause = 'BEN_LER_BNFT_RSTRN_F'

403: -- ,pqh_table_route trt
404: where copy_entity_txn_id = p_copy_entity_txn_id
405: -- and trt.table_route_id = cpe.table_route_id
406: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
407: -- and trt.where_clause = 'BEN_LER_BNFT_RSTRN_F'
408: and cpe.table_alias = c_table_alias
409: and information1 = c_ler_bnft_rstrn_id
410: -- and information4 = p_business_group_id
411: ;

Line 414: -- END OF BEN_LER_BNFT_RSTRN_F ----------------------

410: -- and information4 = p_business_group_id
411: ;
412: l_out_lbr_result_id number(15);
413: ---------------------------------------------------------------
414: -- END OF BEN_LER_BNFT_RSTRN_F ----------------------
415: ---------------------------------------------------------------
416: ---
417: ---------------------------------------------------------------
418: -- START OF BEN_ENRT_CTFN_F ----------------------

Line 3873: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------

3869: -- END OF BEN_BNFT_RSTRN_CTFN_F ----------------------
3870: ---------------------------------------------------------------
3871:
3872: ---------------------------------------------------------------
3873: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------
3874: ---------------------------------------------------------------
3875: --
3876: --
3877: for l_parent_rec in c_lbr_from_parent(l_PL_ID) loop

Line 4151: -- END OF BEN_LER_BNFT_RSTRN_F ----------------------

4147: -- END OF BEN_LER_BNFT_RSTRN_CTFN_F ----------------------
4148: ---------------------------------------------------------------
4149: end loop;
4150: ---------------------------------------------------------------
4151: -- END OF BEN_LER_BNFT_RSTRN_F ----------------------
4152: ---------------------------------------------------------------
4153:
4154: ---------------------------------------------------------------
4155: -- START OF BEN_ENRT_CTFN_F ----------------------