APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_LER_CHG_PL_NIP_ENRT_F

Line 498: -- START OF BEN_LER_CHG_PL_NIP_ENRT_F ----------------------

494: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------
495: ---------------------------------------------------------------
496: ---
497: ---------------------------------------------------------------
498: -- START OF BEN_LER_CHG_PL_NIP_ENRT_F ----------------------
499: ---------------------------------------------------------------
500: cursor c_lpe_from_parent(c_PL_ID number) is
501: select distinct ler_chg_pl_nip_enrt_id
502: from BEN_LER_CHG_PL_NIP_ENRT_F

Line 502: from BEN_LER_CHG_PL_NIP_ENRT_F

498: -- START OF BEN_LER_CHG_PL_NIP_ENRT_F ----------------------
499: ---------------------------------------------------------------
500: cursor c_lpe_from_parent(c_PL_ID number) is
501: select distinct ler_chg_pl_nip_enrt_id
502: from BEN_LER_CHG_PL_NIP_ENRT_F
503: where PL_ID = c_PL_ID ;
504: --
505: cursor c_lpe(c_ler_chg_pl_nip_enrt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
506: select lpe.*

Line 507: from BEN_LER_CHG_PL_NIP_ENRT_F lpe

503: where PL_ID = c_PL_ID ;
504: --
505: cursor c_lpe(c_ler_chg_pl_nip_enrt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
506: select lpe.*
507: from BEN_LER_CHG_PL_NIP_ENRT_F lpe
508: where lpe.ler_chg_pl_nip_enrt_id = c_ler_chg_pl_nip_enrt_id
509: -- and lpe.business_group_id = p_business_group_id
510: and not exists (
511: select /*+ */ null

Line 518: -- and trt.where_clause = 'BEN_LER_CHG_PL_NIP_ENRT_F'

514: where copy_entity_txn_id = p_copy_entity_txn_id
515: -- and trt.table_route_id = cpe.table_route_id
516: and ( -- c_mirror_src_entity_result_id is null or
517: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
518: -- and trt.where_clause = 'BEN_LER_CHG_PL_NIP_ENRT_F'
519: and cpe.table_alias = c_table_alias
520: and information1 = c_ler_chg_pl_nip_enrt_id
521: -- and information4 = lpe.business_group_id
522: and information2 = lpe.effective_start_date

Line 532: -- and trt.where_clause = 'BEN_LER_CHG_PL_NIP_ENRT_F'

528: -- ,pqh_table_route trt
529: where copy_entity_txn_id = p_copy_entity_txn_id
530: -- and trt.table_route_id = cpe.table_route_id
531: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
532: -- and trt.where_clause = 'BEN_LER_CHG_PL_NIP_ENRT_F'
533: and cpe.table_alias = c_table_alias
534: and information1 = c_ler_chg_pl_nip_enrt_id
535: -- and information4 = p_business_group_id
536: ;

Line 540: -- END OF BEN_LER_CHG_PL_NIP_ENRT_F ----------------------

536: ;
537:
538: l_out_lpe_result_id number(15);
539: ---------------------------------------------------------------
540: -- END OF BEN_LER_CHG_PL_NIP_ENRT_F ----------------------
541: ---------------------------------------------------------------
542: ---
543: ---------------------------------------------------------------
544: -- START OF BEN_LER_RQRS_ENRT_CTFN_F ----------------------

Line 4543: -- START OF BEN_LER_CHG_PL_NIP_ENRT_F ----------------------

4539: ---------------------------------------------------------------
4540: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------
4541: ---------------------------------------------------------------
4542: ---------------------------------------------------------------
4543: -- START OF BEN_LER_CHG_PL_NIP_ENRT_F ----------------------
4544: ---------------------------------------------------------------
4545: --
4546: --
4547: for l_parent_rec in c_lpe_from_parent(l_PL_ID) loop

Line 4695: -- END OF BEN_LER_CHG_PL_NIP_ENRT_F ----------------------

4691: );
4692: end loop;
4693: end loop;
4694: ---------------------------------------------------------------
4695: -- END OF BEN_LER_CHG_PL_NIP_ENRT_F ----------------------
4696: ---------------------------------------------------------------
4697: ---------------------------------------------------------------
4698: -- START OF BEN_LER_RQRS_ENRT_CTFN_F ----------------------
4699: ---------------------------------------------------------------