APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_RPTG_GRP

Line 885: -- START OF BEN_RPTG_GRP ----------------------

881: ---------------------------------------------------------------
882: -- END OF BEN_REGN_F ----------------------
883: ---------------------------------------------------------------
884: ---------------------------------------------------------------
885: -- START OF BEN_RPTG_GRP ----------------------
886: ---------------------------------------------------------------
887: cursor c_bnr_from_parent(c_PL_REGN_ID number) is
888: select rptg_grp_id
889: from BEN_PL_REGN_F

Line 895: from BEN_RPTG_GRP bnr

891: --
892: cursor c_bnr(c_rptg_grp_id number,c_mirror_src_entity_result_id number,
893: c_table_alias varchar2) is
894: select bnr.*
895: from BEN_RPTG_GRP bnr
896: where bnr.rptg_grp_id = c_rptg_grp_id
897: -- and bnr.business_group_id = p_business_group_id
898: and not exists (
899: select /*+ */ null

Line 906: -- and trt.where_clause = 'BEN_RPTG_GRP'

902: where copy_entity_txn_id = p_copy_entity_txn_id
903: -- and trt.table_route_id = cpe.table_route_id
904: and ( -- c_mirror_src_entity_result_id is null or
905: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
906: -- and trt.where_clause = 'BEN_RPTG_GRP'
907: and cpe.table_alias = c_table_alias
908: and information1 = c_rptg_grp_id
909: -- and information4 = bnr.business_group_id
910: );

Line 913: -- END OF BEN_RPTG_GRP ----------------------

909: -- and information4 = bnr.business_group_id
910: );
911: l_out_bnr_result_id number(15);
912: ---------------------------------------------------------------
913: -- END OF BEN_RPTG_GRP ----------------------
914: ---------------------------------------------------------------
915: ---------------------------------------------------------------
916: -- START OF BEN_WV_PRTN_RSN_CTFN_PL_F ----------------------
917: ---------------------------------------------------------------

Line 2573: -- START OF BEN_RPTG_GRP ----------------------

2569: -- END OF BEN_REGN_F ----------------------
2570: ---------------------------------------------------------------
2571: --
2572: ---------------------------------------------------------------
2573: -- START OF BEN_RPTG_GRP ----------------------
2574: ---------------------------------------------------------------
2575: --
2576: for l_parent_rec in c_bnr_from_parent(l_PL_REGN_ID) loop
2577: --

Line 3115: -- END OF BEN_RPTG_GRP ----------------------

3111: ---------------------------------------------------------------
3112: --
3113: end loop;
3114: ---------------------------------------------------------------
3115: -- END OF BEN_RPTG_GRP ----------------------
3116: ---------------------------------------------------------------
3117: end loop;
3118: ---------------------------------------------------------------
3119: -- END OF BEN_PL_REGN_F ----------------------

Line 6160: -- START OF BEN_RPTG_GRP ----------------------

6156: ---------------------------------------------------------------
6157: -- END OF BEN_POPL_ORG_ROLE_F ----------------------
6158: ---------------------------------------------------------------
6159: ---------------------------------------------------------------
6160: -- START OF BEN_RPTG_GRP ----------------------
6161: ---------------------------------------------------------------
6162: cursor c_bnr_from_parent(c_POPL_RPTG_GRP_ID number) is
6163: select rptg_grp_id
6164: from BEN_POPL_RPTG_GRP_F

Line 6170: from BEN_RPTG_GRP bnr

6166: --
6167: cursor c_bnr(c_rptg_grp_id number,c_mirror_src_entity_result_id number,
6168: c_table_alias varchar2) is
6169: select bnr.*
6170: from BEN_RPTG_GRP bnr
6171: where bnr.rptg_grp_id = c_rptg_grp_id
6172: -- and bnr.business_group_id = p_business_group_id
6173: and not exists (
6174: select /*+ */ null

Line 6181: -- and trt.where_clause = 'BEN_RPTG_GRP'

6177: where copy_entity_txn_id = p_copy_entity_txn_id
6178: -- and trt.table_route_id = cpe.table_route_id
6179: and ( -- c_mirror_src_entity_result_id is null or
6180: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6181: -- and trt.where_clause = 'BEN_RPTG_GRP'
6182: and cpe.table_alias = c_table_alias
6183: and information1 = c_rptg_grp_id
6184: -- and information4 = bnr.business_group_id
6185: );

Line 6188: -- END OF BEN_RPTG_GRP ----------------------

6184: -- and information4 = bnr.business_group_id
6185: );
6186: l_out_bnr_result_id number(15);
6187: ---------------------------------------------------------------
6188: -- END OF BEN_RPTG_GRP ----------------------
6189: ---------------------------------------------------------------
6190: ---------------------------------------------------------------
6191: -- START OF BEN_LEE_RSN_F ----------------------
6192: ---------------------------------------------------------------

Line 8440: -- START OF BEN_RPTG_GRP ----------------------

8436: end if;
8437: end loop;
8438: --
8439: ---------------------------------------------------------------
8440: -- START OF BEN_RPTG_GRP ----------------------
8441: ---------------------------------------------------------------
8442: --
8443: for l_parent_rec in c_bnr_from_parent(l_POPL_RPTG_GRP_ID) loop
8444: --

Line 8980: -- END OF BEN_RPTG_GRP ----------------------

8976: -- END OF BEN_POPL_RPTG_GRP_F ----------------------
8977: ---------------------------------------------------------------
8978: end loop;
8979: ---------------------------------------------------------------
8980: -- END OF BEN_RPTG_GRP ----------------------
8981: ---------------------------------------------------------------
8982: end loop;
8983: ---------------------------------------------------------------
8984: -- END OF BEN_POPL_RPTG_GRP_F ----------------------