APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_LER_BNFT_RSTRN_CTFN_F

Line 949: -- START OF BEN_LER_BNFT_RSTRN_CTFN_F ----------------------

945: ---------------------------------------------------------------
946: -- END OF BEN_WV_PRTN_RSN_CTFN_PL_F ----------------------
947: ---------------------------------------------------------------
948: ---------------------------------------------------------------
949: -- START OF BEN_LER_BNFT_RSTRN_CTFN_F ----------------------
950: ---------------------------------------------------------------
951: cursor c_lbc_from_parent(c_LER_BNFT_RSTRN_ID number) is
952: select ler_bnft_rstrn_ctfn_id
953: from BEN_LER_BNFT_RSTRN_CTFN_F

Line 953: from BEN_LER_BNFT_RSTRN_CTFN_F

949: -- START OF BEN_LER_BNFT_RSTRN_CTFN_F ----------------------
950: ---------------------------------------------------------------
951: cursor c_lbc_from_parent(c_LER_BNFT_RSTRN_ID number) is
952: select ler_bnft_rstrn_ctfn_id
953: from BEN_LER_BNFT_RSTRN_CTFN_F
954: where LER_BNFT_RSTRN_ID = c_LER_BNFT_RSTRN_ID ;
955: --
956: cursor c_lbc(c_ler_bnft_rstrn_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
957: select lbc.*

Line 958: from BEN_LER_BNFT_RSTRN_CTFN_F lbc

954: where LER_BNFT_RSTRN_ID = c_LER_BNFT_RSTRN_ID ;
955: --
956: cursor c_lbc(c_ler_bnft_rstrn_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
957: select lbc.*
958: from BEN_LER_BNFT_RSTRN_CTFN_F lbc
959: where lbc.ler_bnft_rstrn_ctfn_id = c_ler_bnft_rstrn_ctfn_id
960: -- and lbc.business_group_id = p_business_group_id
961: and not exists (
962: select /*+ */ null

Line 969: -- and trt.where_clause = 'BEN_LER_BNFT_RSTRN_CTFN_F'

965: where copy_entity_txn_id = p_copy_entity_txn_id
966: -- and trt.table_route_id = cpe.table_route_id
967: and ( -- c_mirror_src_entity_result_id is null or
968: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
969: -- and trt.where_clause = 'BEN_LER_BNFT_RSTRN_CTFN_F'
970: and cpe.table_alias = c_table_alias
971: and information1 = c_ler_bnft_rstrn_ctfn_id
972: -- and information4 = lbc.business_group_id
973: and information2 = lbc.effective_start_date

Line 979: -- END OF BEN_LER_BNFT_RSTRN_CTFN_F ----------------------

975: );
976:
977: l_out_lbc_result_id number(15);
978: ---------------------------------------------------------------
979: -- END OF BEN_LER_BNFT_RSTRN_CTFN_F ----------------------
980: ---------------------------------------------------------------
981: ---------------------------------------------------------------
982: -- START OF BEN_LER_ENRT_CTFN_F ----------------------
983: ---------------------------------------------------------------

Line 4039: -- START OF BEN_LER_BNFT_RSTRN_CTFN_F ----------------------

4035: );
4036: --
4037: end loop;
4038: ---------------------------------------------------------------
4039: -- START OF BEN_LER_BNFT_RSTRN_CTFN_F ----------------------
4040: ---------------------------------------------------------------
4041: --
4042: for l_parent_rec in c_lbc_from_parent(l_LER_BNFT_RSTRN_ID) loop
4043: --

Line 4147: -- END OF BEN_LER_BNFT_RSTRN_CTFN_F ----------------------

4143: end loop;
4144: --
4145: end loop;
4146: ---------------------------------------------------------------
4147: -- END OF BEN_LER_BNFT_RSTRN_CTFN_F ----------------------
4148: ---------------------------------------------------------------
4149: end loop;
4150: ---------------------------------------------------------------
4151: -- END OF BEN_LER_BNFT_RSTRN_F ----------------------