APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_BNFT_RSTRN_CTFN_F

Line 339: -- START OF BEN_BNFT_RSTRN_CTFN_F ----------------------

335: -- END OF BEN_WV_PRTN_RSN_PL_F ----------------------
336: ---------------------------------------------------------------
337:
338: ---------------------------------------------------------------
339: -- START OF BEN_BNFT_RSTRN_CTFN_F ----------------------
340: ---------------------------------------------------------------
341: cursor c_brc_from_parent(c_PL_ID number) is
342: select bnft_rstrn_ctfn_id
343: from BEN_BNFT_RSTRN_CTFN_F

Line 343: from BEN_BNFT_RSTRN_CTFN_F

339: -- START OF BEN_BNFT_RSTRN_CTFN_F ----------------------
340: ---------------------------------------------------------------
341: cursor c_brc_from_parent(c_PL_ID number) is
342: select bnft_rstrn_ctfn_id
343: from BEN_BNFT_RSTRN_CTFN_F
344: where PL_ID = c_PL_ID ;
345: --
346: cursor c_brc(c_bnft_rstrn_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
347: select brc.*

Line 348: from BEN_BNFT_RSTRN_CTFN_F brc

344: where PL_ID = c_PL_ID ;
345: --
346: cursor c_brc(c_bnft_rstrn_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
347: select brc.*
348: from BEN_BNFT_RSTRN_CTFN_F brc
349: where brc.bnft_rstrn_ctfn_id = c_bnft_rstrn_ctfn_id
350: -- and brc.business_group_id = p_business_group_id
351: and not exists (
352: select /*+ */ null

Line 359: -- and trt.where_clause = 'BEN_BNFT_RSTRN_CTFN_F'

355: where copy_entity_txn_id = p_copy_entity_txn_id
356: -- and trt.table_route_id = cpe.table_route_id
357: and ( -- c_mirror_src_entity_result_id is null or
358: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
359: -- and trt.where_clause = 'BEN_BNFT_RSTRN_CTFN_F'
360: and cpe.table_alias = c_table_alias
361: and information1 = c_bnft_rstrn_ctfn_id
362: -- and information4 = brc.business_group_id
363: and information2 = brc.effective_start_date

Line 369: -- END OF BEN_BNFT_RSTRN_CTFN_F ----------------------

365: );
366:
367: l_out_brc_result_id number(15);
368: ---------------------------------------------------------------
369: -- END OF BEN_BNFT_RSTRN_CTFN_F ----------------------
370: ---------------------------------------------------------------
371: ---
372: ---------------------------------------------------------------
373: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------

Line 3760: -- START OF BEN_BNFT_RSTRN_CTFN_F ----------------------

3756: -- END OF BEN_WV_PRTN_RSN_PL_F ----------------------
3757: ---------------------------------------------------------------
3758:
3759: ---------------------------------------------------------------
3760: -- START OF BEN_BNFT_RSTRN_CTFN_F ----------------------
3761: ---------------------------------------------------------------
3762: --
3763: --
3764: for l_parent_rec in c_brc_from_parent(l_PL_ID) loop

Line 3869: -- END OF BEN_BNFT_RSTRN_CTFN_F ----------------------

3865: --
3866:
3867: end loop;
3868: ---------------------------------------------------------------
3869: -- END OF BEN_BNFT_RSTRN_CTFN_F ----------------------
3870: ---------------------------------------------------------------
3871:
3872: ---------------------------------------------------------------
3873: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------