eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_PL_REGY_BOD_F

Line 1156: -- START OF BEN_PL_REGY_BOD_F ----------------------

1152: ---------------------------------------------------------------
1153: -- END OF BEN_PL_REGN_F ----------------------
1154: ---------------------------------------------------------------
1155: ---------------------------------------------------------------
1156: -- START OF BEN_PL_REGY_BOD_F ----------------------
1157: ---------------------------------------------------------------
1158: cursor c_prb_from_parent(c_RPTG_GRP_ID number) is
1159: select pl_regy_bod_id
1160: from BEN_PL_REGY_BOD_F

Line 1160: from BEN_PL_REGY_BOD_F

1156: -- START OF BEN_PL_REGY_BOD_F ----------------------
1157: ---------------------------------------------------------------
1158: cursor c_prb_from_parent(c_RPTG_GRP_ID number) is
1159: select pl_regy_bod_id
1160: from BEN_PL_REGY_BOD_F
1161: where RPTG_GRP_ID = c_RPTG_GRP_ID ;
1162: --
1163: cursor c_prb(c_pl_regy_bod_id number,c_mirror_src_entity_result_id number,
1164: c_table_alias varchar2) is

Line 1166: from BEN_PL_REGY_BOD_F prb

1162: --
1163: cursor c_prb(c_pl_regy_bod_id number,c_mirror_src_entity_result_id number,
1164: c_table_alias varchar2) is
1165: select prb.*
1166: from BEN_PL_REGY_BOD_F prb
1167: where prb.pl_regy_bod_id = c_pl_regy_bod_id
1168: -- and prb.business_group_id = p_business_group_id
1169: and not exists (
1170: select /*+ */ null

Line 1177: -- and trt.where_clause = 'BEN_PL_REGY_BOD_F'

1173: where copy_entity_txn_id = p_copy_entity_txn_id
1174: -- and trt.table_route_id = cpe.table_route_id
1175: and ( -- c_mirror_src_entity_result_id is null or
1176: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1177: -- and trt.where_clause = 'BEN_PL_REGY_BOD_F'
1178: and cpe.table_alias = c_table_alias
1179: and information1 = c_pl_regy_bod_id
1180: -- and information4 = prb.business_group_id
1181: and information2 = prb.effective_start_date

Line 1187: -- END OF BEN_PL_REGY_BOD_F ----------------------

1183: );
1184: l_pl_regy_bod_id number(15);
1185: l_out_prb_result_id number(15);
1186: ---------------------------------------------------------------
1187: -- END OF BEN_PL_REGY_BOD_F ----------------------
1188: ---------------------------------------------------------------
1189: ---------------------------------------------------------------
1190: -- START OF BEN_PL_REGY_PRP_F ----------------------
1191: ---------------------------------------------------------------

Line 2907: -- START OF BEN_PL_REGY_BOD_F ----------------------

2903: ---------------------------------------------------------------
2904: -- END OF BEN_PL_REGN_F ----------------------
2905: ---------------------------------------------------------------
2906: ---------------------------------------------------------------
2907: -- START OF BEN_PL_REGY_BOD_F ----------------------
2908: ---------------------------------------------------------------
2909: --
2910: for l_parent_rec in c_prb_from_parent(l_RPTG_GRP_ID) loop
2911: --

Line 3100: -- END OF BEN_PL_REGY_BOD_F ----------------------

3096: -- END OF BEN_PL_REGY_PRP_F ----------------------
3097: ---------------------------------------------------------------
3098: end loop;
3099: ---------------------------------------------------------------
3100: -- END OF BEN_PL_REGY_BOD_F ----------------------
3101: ---------------------------------------------------------------
3102: ---------------------------------------------------------------
3103: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
3104: ---------------------------------------------------------------

Line 6513: -- START OF BEN_PL_REGY_BOD_F ----------------------

6509: ---------------------------------------------------------------
6510: -- END OF BEN_PL_REGN_F ----------------------
6511: ---------------------------------------------------------------
6512: ---------------------------------------------------------------
6513: -- START OF BEN_PL_REGY_BOD_F ----------------------
6514: ---------------------------------------------------------------
6515: cursor c_prb_from_parent(c_RPTG_GRP_ID number) is
6516: select pl_regy_bod_id
6517: from BEN_PL_REGY_BOD_F

Line 6517: from BEN_PL_REGY_BOD_F

6513: -- START OF BEN_PL_REGY_BOD_F ----------------------
6514: ---------------------------------------------------------------
6515: cursor c_prb_from_parent(c_RPTG_GRP_ID number) is
6516: select pl_regy_bod_id
6517: from BEN_PL_REGY_BOD_F
6518: where RPTG_GRP_ID = c_RPTG_GRP_ID ;
6519: --
6520: cursor c_prb(c_pl_regy_bod_id number,c_mirror_src_entity_result_id number,
6521: c_table_alias varchar2) is

Line 6523: from BEN_PL_REGY_BOD_F prb

6519: --
6520: cursor c_prb(c_pl_regy_bod_id number,c_mirror_src_entity_result_id number,
6521: c_table_alias varchar2) is
6522: select prb.*
6523: from BEN_PL_REGY_BOD_F prb
6524: where prb.pl_regy_bod_id = c_pl_regy_bod_id
6525: -- and prb.business_group_id = p_business_group_id
6526: and not exists (
6527: select /*+ */ null

Line 6534: -- and trt.where_clause = 'BEN_PL_REGY_BOD_F'

6530: where copy_entity_txn_id = p_copy_entity_txn_id
6531: -- and trt.table_route_id = cpe.table_route_id
6532: and ( -- c_mirror_src_entity_result_id is null or
6533: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6534: -- and trt.where_clause = 'BEN_PL_REGY_BOD_F'
6535: and cpe.table_alias = c_table_alias
6536: and information1 = c_pl_regy_bod_id
6537: -- and information4 = prb.business_group_id
6538: and information2 = prb.effective_start_date

Line 6544: -- END OF BEN_PL_REGY_BOD_F ----------------------

6540: );
6541: l_pl_regy_bod_id number(15);
6542: l_out_prb_result_id number(15);
6543: ---------------------------------------------------------------
6544: -- END OF BEN_PL_REGY_BOD_F ----------------------
6545: ---------------------------------------------------------------
6546: ---------------------------------------------------------------
6547: -- START OF BEN_PL_REGY_PRP_F ----------------------
6548: ---------------------------------------------------------------

Line 8774: -- START OF BEN_PL_REGY_BOD_F ----------------------

8770: ---------------------------------------------------------------
8771: -- END OF BEN_PL_REGN_F ----------------------
8772: ---------------------------------------------------------------
8773: ---------------------------------------------------------------
8774: -- START OF BEN_PL_REGY_BOD_F ----------------------
8775: ---------------------------------------------------------------
8776: --
8777: for l_parent_rec in c_prb_from_parent(l_RPTG_GRP_ID) loop
8778: --

Line 8967: -- END OF BEN_PL_REGY_BOD_F ----------------------

8963: -- END OF BEN_PL_REGY_PRP_F ----------------------
8964: ---------------------------------------------------------------
8965: end loop;
8966: ---------------------------------------------------------------
8967: -- END OF BEN_PL_REGY_BOD_F ----------------------
8968: ---------------------------------------------------------------
8969: ---------------------------------------------------------------
8970: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
8971: ---------------------------------------------------------------