APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_WV_PRTN_RSN_CTFN_PL_F

Line 916: -- START OF BEN_WV_PRTN_RSN_CTFN_PL_F ----------------------

912: ---------------------------------------------------------------
913: -- END OF BEN_RPTG_GRP ----------------------
914: ---------------------------------------------------------------
915: ---------------------------------------------------------------
916: -- START OF BEN_WV_PRTN_RSN_CTFN_PL_F ----------------------
917: ---------------------------------------------------------------
918: cursor c_wcn_from_parent(c_WV_PRTN_RSN_PL_ID number) is
919: select wv_prtn_rsn_ctfn_pl_id
920: from BEN_WV_PRTN_RSN_CTFN_PL_F

Line 920: from BEN_WV_PRTN_RSN_CTFN_PL_F

916: -- START OF BEN_WV_PRTN_RSN_CTFN_PL_F ----------------------
917: ---------------------------------------------------------------
918: cursor c_wcn_from_parent(c_WV_PRTN_RSN_PL_ID number) is
919: select wv_prtn_rsn_ctfn_pl_id
920: from BEN_WV_PRTN_RSN_CTFN_PL_F
921: where WV_PRTN_RSN_PL_ID = c_WV_PRTN_RSN_PL_ID ;
922: --
923: cursor c_wcn(c_wv_prtn_rsn_ctfn_pl_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
924: select wcn.*

Line 925: from BEN_WV_PRTN_RSN_CTFN_PL_F wcn

921: where WV_PRTN_RSN_PL_ID = c_WV_PRTN_RSN_PL_ID ;
922: --
923: cursor c_wcn(c_wv_prtn_rsn_ctfn_pl_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
924: select wcn.*
925: from BEN_WV_PRTN_RSN_CTFN_PL_F wcn
926: where wcn.wv_prtn_rsn_ctfn_pl_id = c_wv_prtn_rsn_ctfn_pl_id
927: -- and wcn.business_group_id = p_business_group_id
928: and not exists (
929: select /*+ */ null

Line 936: -- and trt.where_clause = 'BEN_WV_PRTN_RSN_CTFN_PL_F'

932: where copy_entity_txn_id = p_copy_entity_txn_id
933: -- and trt.table_route_id = cpe.table_route_id
934: and ( -- c_mirror_src_entity_result_id is null or
935: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
936: -- and trt.where_clause = 'BEN_WV_PRTN_RSN_CTFN_PL_F'
937: and cpe.table_alias = c_table_alias
938: and information1 = c_wv_prtn_rsn_ctfn_pl_id
939: -- and information4 = wcn.business_group_id
940: and information2 = wcn.effective_start_date

Line 946: -- END OF BEN_WV_PRTN_RSN_CTFN_PL_F ----------------------

942: );
943:
944: l_out_wcn_result_id number(15);
945: ---------------------------------------------------------------
946: -- END OF BEN_WV_PRTN_RSN_CTFN_PL_F ----------------------
947: ---------------------------------------------------------------
948: ---------------------------------------------------------------
949: -- START OF BEN_LER_BNFT_RSTRN_CTFN_F ----------------------
950: ---------------------------------------------------------------

Line 3642: -- START OF BEN_WV_PRTN_RSN_CTFN_PL_F ----------------------

3638:
3639: end loop;
3640: --
3641: ---------------------------------------------------------------
3642: -- START OF BEN_WV_PRTN_RSN_CTFN_PL_F ----------------------
3643: ---------------------------------------------------------------
3644: --
3645: for l_parent_rec in c_wcn_from_parent(l_WV_PRTN_RSN_PL_ID) loop
3646: --

Line 3752: -- END OF BEN_WV_PRTN_RSN_CTFN_PL_F ----------------------

3748: end loop;
3749: --
3750: end loop;
3751: ---------------------------------------------------------------
3752: -- END OF BEN_WV_PRTN_RSN_CTFN_PL_F ----------------------
3753: ---------------------------------------------------------------
3754: end loop;
3755: ---------------------------------------------------------------
3756: -- END OF BEN_WV_PRTN_RSN_PL_F ----------------------