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_REGN_F

Line 851: -- START OF BEN_REGN_F ----------------------

847: ---------------------------------------------------------------
848: -- END OF BEN_PL_REGN_F ----------------------
849: ---------------------------------------------------------------
850: ---------------------------------------------------------------
851: -- START OF BEN_REGN_F ----------------------
852: ---------------------------------------------------------------
853: cursor c_reg_from_parent(c_PL_REGN_ID number) is
854: select regn_id
855: from BEN_PL_REGN_F

Line 861: from BEN_REGN_F reg

857: --
858: cursor c_reg(c_regn_id number,c_mirror_src_entity_result_id number,
859: c_table_alias varchar2) is
860: select reg.*
861: from BEN_REGN_F reg
862: where reg.regn_id = c_regn_id
863: -- and reg.business_group_id = p_business_group_id
864: and not exists (
865: select /*+ */ null

Line 872: -- and trt.where_clause = 'BEN_REGN_F'

868: where copy_entity_txn_id = p_copy_entity_txn_id
869: -- and trt.table_route_id = cpe.table_route_id
870: and ( -- c_mirror_src_entity_result_id is null or
871: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
872: -- and trt.where_clause = 'BEN_REGN_F'
873: and cpe.table_alias = c_table_alias
874: and information1 = c_regn_id
875: -- and information4 = reg.business_group_id
876: and information2 = reg.effective_start_date

Line 882: -- END OF BEN_REGN_F ----------------------

878: );
879:
880: l_out_reg_result_id number(15);
881: ---------------------------------------------------------------
882: -- END OF BEN_REGN_F ----------------------
883: ---------------------------------------------------------------
884: ---------------------------------------------------------------
885: -- START OF BEN_RPTG_GRP ----------------------
886: ---------------------------------------------------------------

Line 1257: -- START OF BEN_REGN_F ----------------------

1253: ---------------------------------------------------------------
1254: -- END OF BEN_POPL_RPTG_GRP_F ----------------------
1255: ---------------------------------------------------------------
1256: ---------------------------------------------------------------
1257: -- START OF BEN_REGN_F ----------------------
1258: ---------------------------------------------------------------
1259: cursor c_reg1_from_parent(c_PL_REGN_ID number) is
1260: select regn_id
1261: from BEN_PL_REGN_F

Line 1267: from BEN_REGN_F reg

1263: --
1264: cursor c_reg1(c_regn_id number,c_mirror_src_entity_result_id number,
1265: c_table_alias varchar2) is
1266: select reg.*
1267: from BEN_REGN_F reg
1268: where reg.regn_id = c_regn_id
1269: -- and reg.business_group_id = p_business_group_id
1270: and not exists (
1271: select /*+ */ null

Line 1278: -- and trt.where_clause = 'BEN_REGN_F'

1274: where copy_entity_txn_id = p_copy_entity_txn_id
1275: -- and trt.table_route_id = cpe.table_route_id
1276: and ( -- c_mirror_src_entity_result_id is null or
1277: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1278: -- and trt.where_clause = 'BEN_REGN_F'
1279: and cpe.table_alias = c_table_alias
1280: and information1 = c_regn_id
1281: -- and information4 = reg.business_group_id
1282: and information2 = reg.effective_start_date

Line 1287: -- END OF BEN_REGN_F ----------------------

1283: and information3 = reg.effective_end_date
1284: );
1285: l_out_reg1_result_id number(15);
1286: ---------------------------------------------------------------
1287: -- END OF BEN_REGN_F ----------------------
1288: ---------------------------------------------------------------
1289:
1290: cursor c_object_exists(c_pk_id number,
1291: c_table_alias varchar2) is

Line 1306: l_regn_name ben_regn_f.name%type;

1302: l_table_route_id number(15);
1303: l_mirror_src_entity_result_id number(15);
1304: l_result_type_cd varchar2(30);
1305: l_information5 ben_copy_entity_results.information5%type;
1306: l_regn_name ben_regn_f.name%type;
1307: --
1308: l_pl_id number(15);
1309: l_popl_yr_perd_id number(15);
1310: l_yr_perd_id number(15);

Line 2323: -- Records for Regulations (BEN_REGN_F) will not created in the Target Business Group

2319:
2320: /* NOT REQUIRED AS create_REG_rows will handle this
2321: --
2322: -- Store the Regulation name in information185
2323: -- Records for Regulations (BEN_REGN_F) will not created in the Target Business Group
2324: -- The copy process will try and map the Regulation name to the ones existing in the
2325: -- Target Business Group and if a match is found, then that Regulation Id will be used
2326: -- for creating Plan Regulation (BEN_PL_REGN) records.
2327:

Line 2465: -- START OF BEN_REGN_F ----------------------

2461: --
2462: end loop;
2463:
2464: ---------------------------------------------------------------
2465: -- START OF BEN_REGN_F ----------------------
2466: ---------------------------------------------------------------
2467: --
2468: for l_parent_rec in c_reg_from_parent(l_PL_REGN_ID) loop
2469: --

Line 2569: -- END OF BEN_REGN_F ----------------------

2565: end loop;
2566: --
2567: end loop;
2568: ---------------------------------------------------------------
2569: -- END OF BEN_REGN_F ----------------------
2570: ---------------------------------------------------------------
2571: --
2572: ---------------------------------------------------------------
2573: -- START OF BEN_RPTG_GRP ----------------------

Line 2715: -- Records for Regulations (BEN_REGN_F) will not created in the Target Business Group

2711:
2712: /* NOT REQUIRED AS create_REG_rows will handle this
2713: --
2714: -- Store the Regulation name in information185
2715: -- Records for Regulations (BEN_REGN_F) will not created in the Target Business Group
2716: -- The copy process will try and map the Regulation name to the ones existing in the
2717: -- Target Business Group and if a match is found, then that Regulation Id will be used
2718: -- for creating Plan Regulation (BEN_PL_REGN) records.
2719:

Line 2797: -- START OF BEN_REGN_F ----------------------

2793: --
2794: end loop;
2795: --
2796: ---------------------------------------------------------------
2797: -- START OF BEN_REGN_F ----------------------
2798: ---------------------------------------------------------------
2799: --
2800: for l_parent_rec in c_reg_from_parent(l_PL_REGN_ID1) loop
2801: --

Line 2900: -- END OF BEN_REGN_F ----------------------

2896: end loop;
2897: --
2898: end loop;
2899: ---------------------------------------------------------------
2900: -- END OF BEN_REGN_F ----------------------
2901: ---------------------------------------------------------------
2902: end loop;
2903: ---------------------------------------------------------------
2904: -- END OF BEN_PL_REGN_F ----------------------

Line 6613: -- START OF BEN_REGN_F ----------------------

6609: ---------------------------------------------------------------
6610: -- END OF BEN_POPL_RPTG_GRP_F ----------------------
6611: ---------------------------------------------------------------
6612: ---------------------------------------------------------------
6613: -- START OF BEN_REGN_F ----------------------
6614: ---------------------------------------------------------------
6615: cursor c_reg_from_parent(c_PL_REGN_ID number) is
6616: select regn_id
6617: from BEN_PL_REGN_F

Line 6623: from BEN_REGN_F reg

6619: --
6620: cursor c_reg(c_regn_id number,c_mirror_src_entity_result_id number,
6621: c_table_alias varchar2) is
6622: select reg.*
6623: from BEN_REGN_F reg
6624: where reg.regn_id = c_regn_id
6625: -- and reg.business_group_id = p_business_group_id
6626: and not exists (
6627: select /*+ */ null

Line 6634: -- and trt.where_clause = 'BEN_REGN_F'

6630: where copy_entity_txn_id = p_copy_entity_txn_id
6631: -- and trt.table_route_id = cpe.table_route_id
6632: and ( -- c_mirror_src_entity_result_id is null or
6633: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6634: -- and trt.where_clause = 'BEN_REGN_F'
6635: and cpe.table_alias = c_table_alias
6636: and information1 = c_regn_id
6637: -- and information4 = reg.business_group_id
6638: and information2 = reg.effective_start_date

Line 6644: -- END OF BEN_REGN_F ----------------------

6640: );
6641: l_regn_id number(15);
6642: l_out_reg_result_id number(15);
6643: ---------------------------------------------------------------
6644: -- END OF BEN_REGN_F ----------------------
6645: ---------------------------------------------------------------
6646:
6647: cursor c_object_exists(c_pk_id number,
6648: c_table_alias varchar2) is

Line 6663: l_regn_name ben_regn_f.name%type;

6659: l_table_route_id number(15);
6660: l_mirror_src_entity_result_id number(15):= p_copy_entity_result_id;
6661: l_result_type_cd varchar2(30);
6662: l_information5 ben_copy_entity_results.information5%type;
6663: l_regn_name ben_regn_f.name%type;
6664: --
6665: l_pl_id number(15);
6666: l_popl_yr_perd_id number(15);
6667: l_yr_perd_id number(15);

Line 8581: -- Records for Regulations (BEN_REGN_F) will not created in the Target Business Group

8577: /* NOT REQUIRED AS create_REG_rows will handle this
8578: --
8579: --
8580: -- Store the Regulation name in information185
8581: -- Records for Regulations (BEN_REGN_F) will not created in the Target Business Group
8582: -- The copy process will try and map the Regulation name to the ones existing in the
8583: -- Target Business Group and if a match is found, then that Regulation Id will be used
8584: -- for creating Plan Regulation (BEN_PL_REGN) records.
8585:

Line 8664: -- START OF BEN_REGN_F ----------------------

8660: --
8661: end loop;
8662: --
8663: ---------------------------------------------------------------
8664: -- START OF BEN_REGN_F ----------------------
8665: ---------------------------------------------------------------
8666: --
8667: for l_parent_rec in c_reg_from_parent(l_PL_REGN_ID) loop
8668: --

Line 8767: -- END OF BEN_REGN_F ----------------------

8763: end loop;
8764: --
8765: end loop;
8766: ---------------------------------------------------------------
8767: -- END OF BEN_REGN_F ----------------------
8768: ---------------------------------------------------------------
8769: end loop;
8770: ---------------------------------------------------------------
8771: -- END OF BEN_PL_REGN_F ----------------------