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_PRP_F

Line 1190: -- START OF BEN_PL_REGY_PRP_F ----------------------

1186: ---------------------------------------------------------------
1187: -- END OF BEN_PL_REGY_BOD_F ----------------------
1188: ---------------------------------------------------------------
1189: ---------------------------------------------------------------
1190: -- START OF BEN_PL_REGY_PRP_F ----------------------
1191: ---------------------------------------------------------------
1192: cursor c_prp_from_parent(c_PL_REGY_BOD_ID number) is
1193: select pl_regy_prps_id
1194: from BEN_PL_REGY_PRP_F

Line 1194: from BEN_PL_REGY_PRP_F

1190: -- START OF BEN_PL_REGY_PRP_F ----------------------
1191: ---------------------------------------------------------------
1192: cursor c_prp_from_parent(c_PL_REGY_BOD_ID number) is
1193: select pl_regy_prps_id
1194: from BEN_PL_REGY_PRP_F
1195: where PL_REGY_BOD_ID = c_PL_REGY_BOD_ID ;
1196: --
1197: cursor c_prp(c_pl_regy_prps_id number,c_mirror_src_entity_result_id number,
1198: c_table_alias varchar2) is

Line 1200: from BEN_PL_REGY_PRP_F prp

1196: --
1197: cursor c_prp(c_pl_regy_prps_id number,c_mirror_src_entity_result_id number,
1198: c_table_alias varchar2) is
1199: select prp.*
1200: from BEN_PL_REGY_PRP_F prp
1201: where prp.pl_regy_prps_id = c_pl_regy_prps_id
1202: -- and prp.business_group_id = p_business_group_id
1203: and not exists (
1204: select /*+ */ null

Line 1211: -- and trt.where_clause = 'BEN_PL_REGY_PRP_F'

1207: where copy_entity_txn_id = p_copy_entity_txn_id
1208: -- and trt.table_route_id = cpe.table_route_id
1209: and ( -- c_mirror_src_entity_result_id is null or
1210: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1211: -- and trt.where_clause = 'BEN_PL_REGY_PRP_F'
1212: and cpe.table_alias = c_table_alias
1213: and information1 = c_pl_regy_prps_id
1214: -- and information4 = prp.business_group_id
1215: and information2 = prp.effective_start_date

Line 1221: -- END OF BEN_PL_REGY_PRP_F ----------------------

1217: );
1218: l_pl_regy_prps_id number(15);
1219: l_out_prp_result_id number(15);
1220: ---------------------------------------------------------------
1221: -- END OF BEN_PL_REGY_PRP_F ----------------------
1222: ---------------------------------------------------------------
1223: ---------------------------------------------------------------
1224: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
1225: ---------------------------------------------------------------

Line 3003: -- START OF BEN_PL_REGY_PRP_F ----------------------

2999: --
3000: end loop;
3001: --
3002: ---------------------------------------------------------------
3003: -- START OF BEN_PL_REGY_PRP_F ----------------------
3004: ---------------------------------------------------------------
3005: --
3006: for l_parent_rec in c_prp_from_parent(l_PL_REGY_BOD_ID) loop
3007: --

Line 3096: -- END OF BEN_PL_REGY_PRP_F ----------------------

3092: end loop;
3093: --
3094: end loop;
3095: ---------------------------------------------------------------
3096: -- END OF BEN_PL_REGY_PRP_F ----------------------
3097: ---------------------------------------------------------------
3098: end loop;
3099: ---------------------------------------------------------------
3100: -- END OF BEN_PL_REGY_BOD_F ----------------------

Line 6547: -- START OF BEN_PL_REGY_PRP_F ----------------------

6543: ---------------------------------------------------------------
6544: -- END OF BEN_PL_REGY_BOD_F ----------------------
6545: ---------------------------------------------------------------
6546: ---------------------------------------------------------------
6547: -- START OF BEN_PL_REGY_PRP_F ----------------------
6548: ---------------------------------------------------------------
6549: cursor c_prp_from_parent(c_PL_REGY_BOD_ID number) is
6550: select pl_regy_prps_id
6551: from BEN_PL_REGY_PRP_F

Line 6551: from BEN_PL_REGY_PRP_F

6547: -- START OF BEN_PL_REGY_PRP_F ----------------------
6548: ---------------------------------------------------------------
6549: cursor c_prp_from_parent(c_PL_REGY_BOD_ID number) is
6550: select pl_regy_prps_id
6551: from BEN_PL_REGY_PRP_F
6552: where PL_REGY_BOD_ID = c_PL_REGY_BOD_ID ;
6553: --
6554: cursor c_prp(c_pl_regy_prps_id number,c_mirror_src_entity_result_id number,
6555: c_table_alias varchar2) is

Line 6557: from BEN_PL_REGY_PRP_F prp

6553: --
6554: cursor c_prp(c_pl_regy_prps_id number,c_mirror_src_entity_result_id number,
6555: c_table_alias varchar2) is
6556: select prp.*
6557: from BEN_PL_REGY_PRP_F prp
6558: where prp.pl_regy_prps_id = c_pl_regy_prps_id
6559: -- and prp.business_group_id = p_business_group_id
6560: and not exists (
6561: select /*+ */ null

Line 6568: -- and trt.where_clause = 'BEN_PL_REGY_PRP_F'

6564: where copy_entity_txn_id = p_copy_entity_txn_id
6565: -- and trt.table_route_id = cpe.table_route_id
6566: and ( -- c_mirror_src_entity_result_id is null or
6567: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6568: -- and trt.where_clause = 'BEN_PL_REGY_PRP_F'
6569: and cpe.table_alias = c_table_alias
6570: and information1 = c_pl_regy_prps_id
6571: -- and information4 = prp.business_group_id
6572: and information2 = prp.effective_start_date

Line 6578: -- END OF BEN_PL_REGY_PRP_F ----------------------

6574: );
6575: l_pl_regy_prps_id number(15);
6576: l_out_prp_result_id number(15);
6577: ---------------------------------------------------------------
6578: -- END OF BEN_PL_REGY_PRP_F ----------------------
6579: ---------------------------------------------------------------
6580: ---------------------------------------------------------------
6581: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
6582: ---------------------------------------------------------------

Line 8870: -- START OF BEN_PL_REGY_PRP_F ----------------------

8866: --
8867: end loop;
8868: --
8869: ---------------------------------------------------------------
8870: -- START OF BEN_PL_REGY_PRP_F ----------------------
8871: ---------------------------------------------------------------
8872: --
8873: for l_parent_rec in c_prp_from_parent(l_PL_REGY_BOD_ID) loop
8874: --

Line 8963: -- END OF BEN_PL_REGY_PRP_F ----------------------

8959: end loop;
8960: --
8961: end loop;
8962: ---------------------------------------------------------------
8963: -- END OF BEN_PL_REGY_PRP_F ----------------------
8964: ---------------------------------------------------------------
8965: end loop;
8966: ---------------------------------------------------------------
8967: -- END OF BEN_PL_REGY_BOD_F ----------------------