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_DSGN_RQMT_F

Line 1049: -- START OF BEN_DSGN_RQMT_F ----------------------

1045: ---------------------------------------------------------------
1046: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
1047: ---------------------------------------------------------------
1048: ---------------------------------------------------------------
1049: -- START OF BEN_DSGN_RQMT_F ----------------------
1050: ---------------------------------------------------------------
1051: cursor c_ddr3_from_parent(c_PL_ID number) is
1052: select dsgn_rqmt_id
1053: from BEN_DSGN_RQMT_F

Line 1053: from BEN_DSGN_RQMT_F

1049: -- START OF BEN_DSGN_RQMT_F ----------------------
1050: ---------------------------------------------------------------
1051: cursor c_ddr3_from_parent(c_PL_ID number) is
1052: select dsgn_rqmt_id
1053: from BEN_DSGN_RQMT_F
1054: where PL_ID = c_PL_ID ;
1055: --
1056: cursor c_ddr3(c_dsgn_rqmt_id number,c_mirror_src_entity_result_id number,
1057: c_table_alias varchar2) is

Line 1059: from BEN_DSGN_RQMT_F ddr

1055: --
1056: cursor c_ddr3(c_dsgn_rqmt_id number,c_mirror_src_entity_result_id number,
1057: c_table_alias varchar2) is
1058: select ddr.*
1059: from BEN_DSGN_RQMT_F ddr
1060: where ddr.dsgn_rqmt_id = c_dsgn_rqmt_id
1061: -- and ddr.business_group_id = p_business_group_id
1062: and not exists (
1063: select /*+ */ null

Line 1070: -- and trt.where_clause = 'BEN_DSGN_RQMT_F'

1066: where copy_entity_txn_id = p_copy_entity_txn_id
1067: -- and trt.table_route_id = cpe.table_route_id
1068: and ( -- c_mirror_src_entity_result_id is null or
1069: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1070: -- and trt.where_clause = 'BEN_DSGN_RQMT_F'
1071: and cpe.table_alias = c_table_alias
1072: and information1 = c_dsgn_rqmt_id
1073: -- and information4 = ddr.business_group_id
1074: and information2 = ddr.effective_start_date

Line 1078: l_ddr3_dsgn_rqmt_esd ben_dsgn_rqmt_f.effective_start_date%type;

1074: and information2 = ddr.effective_start_date
1075: and information3 = ddr.effective_end_date
1076: );
1077:
1078: l_ddr3_dsgn_rqmt_esd ben_dsgn_rqmt_f.effective_start_date%type;
1079:
1080: ---------------------------------------------------------------
1081: -- END OF BEN_DSGN_RQMT_F ----------------------
1082: ---------------------------------------------------------------

Line 1081: -- END OF BEN_DSGN_RQMT_F ----------------------

1077:
1078: l_ddr3_dsgn_rqmt_esd ben_dsgn_rqmt_f.effective_start_date%type;
1079:
1080: ---------------------------------------------------------------
1081: -- END OF BEN_DSGN_RQMT_F ----------------------
1082: ---------------------------------------------------------------
1083: ---------------------------------------------------------------
1084: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
1085: ---------------------------------------------------------------

Line 5582: -- START OF BEN_DSGN_RQMT_F ----------------------

5578: ---------------------------------------------------------------
5579: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
5580: ---------------------------------------------------------------
5581: ---------------------------------------------------------------
5582: -- START OF BEN_DSGN_RQMT_F ----------------------
5583: ---------------------------------------------------------------
5584: --
5585: for l_parent_rec in c_ddr3_from_parent(l_PL_ID) loop
5586: --

Line 5784: -- END OF BEN_DSGN_RQMT_F ----------------------

5780: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
5781: ---------------------------------------------------------------
5782: end loop;
5783: ---------------------------------------------------------------
5784: -- END OF BEN_DSGN_RQMT_F ----------------------
5785: ---------------------------------------------------------------
5786: for l_parent_rec in c_cop1_from_parent(l_PL_ID) loop
5787: --
5788: create_oipl_result

Line 10123: -- START OF BEN_DSGN_RQMT_F ----------------------

10119: ---------------------------------------------------------------
10120: -- END OF BEN_OIPL_F ----------------------
10121: ---------------------------------------------------------------
10122: ---------------------------------------------------------------
10123: -- START OF BEN_DSGN_RQMT_F ----------------------
10124: ---------------------------------------------------------------
10125: cursor c_ddr1_from_parent(c_OIPL_ID number) is
10126: select dsgn_rqmt_id
10127: from BEN_DSGN_RQMT_F

Line 10127: from BEN_DSGN_RQMT_F

10123: -- START OF BEN_DSGN_RQMT_F ----------------------
10124: ---------------------------------------------------------------
10125: cursor c_ddr1_from_parent(c_OIPL_ID number) is
10126: select dsgn_rqmt_id
10127: from BEN_DSGN_RQMT_F
10128: where OIPL_ID = c_OIPL_ID ;
10129: --
10130: cursor c_ddr1(c_dsgn_rqmt_id number,c_mirror_src_entity_result_id number,
10131: c_table_alias varchar2) is

Line 10133: from BEN_DSGN_RQMT_F ddr

10129: --
10130: cursor c_ddr1(c_dsgn_rqmt_id number,c_mirror_src_entity_result_id number,
10131: c_table_alias varchar2) is
10132: select ddr.*
10133: from BEN_DSGN_RQMT_F ddr
10134: where ddr.dsgn_rqmt_id = c_dsgn_rqmt_id
10135: -- and ddr.business_group_id = p_business_group_id
10136: and not exists (
10137: select /*+ */ null

Line 10144: -- and trt.where_clause = 'BEN_DSGN_RQMT_F'

10140: where copy_entity_txn_id = p_copy_entity_txn_id
10141: -- and trt.table_route_id = cpe.table_route_id
10142: and ( -- c_mirror_src_entity_result_id is null or
10143: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10144: -- and trt.where_clause = 'BEN_DSGN_RQMT_F'
10145: and cpe.table_alias = c_table_alias
10146: and information1 = c_dsgn_rqmt_id
10147: -- and information4 = ddr.business_group_id
10148: and information2 = ddr.effective_start_date

Line 10153: l_ddr1_dsgn_rqmt_esd ben_dsgn_rqmt_f.effective_start_date%type;

10149: and information3 = ddr.effective_end_date
10150: );
10151: l_dsgn_rqmt_id number(15);
10152: l_out_ddr_result_id number(15);
10153: l_ddr1_dsgn_rqmt_esd ben_dsgn_rqmt_f.effective_start_date%type;
10154: ---------------------------------------------------------------
10155: -- END OF BEN_DSGN_RQMT_F ----------------------
10156: ---------------------------------------------------------------
10157: ---------------------------------------------------------------

Line 10155: -- END OF BEN_DSGN_RQMT_F ----------------------

10151: l_dsgn_rqmt_id number(15);
10152: l_out_ddr_result_id number(15);
10153: l_ddr1_dsgn_rqmt_esd ben_dsgn_rqmt_f.effective_start_date%type;
10154: ---------------------------------------------------------------
10155: -- END OF BEN_DSGN_RQMT_F ----------------------
10156: ---------------------------------------------------------------
10157: ---------------------------------------------------------------
10158: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
10159: ---------------------------------------------------------------

Line 10691: -- START OF BEN_DSGN_RQMT_F ----------------------

10687: ,p_parent_entity_result_id => l_out_cop_result_id
10688: ) ;
10689:
10690: ---------------------------------------------------------------
10691: -- START OF BEN_DSGN_RQMT_F ----------------------
10692: ---------------------------------------------------------------
10693: --
10694: for l_parent_rec in c_ddr1_from_parent(l_OIPL_ID) loop
10695: --

Line 10893: -- END OF BEN_DSGN_RQMT_F ----------------------

10889: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
10890: ---------------------------------------------------------------
10891: end loop;
10892: ---------------------------------------------------------------
10893: -- END OF BEN_DSGN_RQMT_F ----------------------
10894: ---------------------------------------------------------------
10895: ---------------------------------------------------------------
10896: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
10897: ---------------------------------------------------------------

Line 11626: -- START OF BEN_DSGN_RQMT_F ----------------------

11622: ---------------------------------------------------------------
11623: -- END OF BEN_OPT_F ----------------------
11624: ---------------------------------------------------------------
11625: ---------------------------------------------------------------
11626: -- START OF BEN_DSGN_RQMT_F ----------------------
11627: ---------------------------------------------------------------
11628: cursor c_ddr2_from_parent(c_OPT_ID number) is
11629: select dsgn_rqmt_id
11630: from BEN_DSGN_RQMT_F

Line 11630: from BEN_DSGN_RQMT_F

11626: -- START OF BEN_DSGN_RQMT_F ----------------------
11627: ---------------------------------------------------------------
11628: cursor c_ddr2_from_parent(c_OPT_ID number) is
11629: select dsgn_rqmt_id
11630: from BEN_DSGN_RQMT_F
11631: where OPT_ID = c_OPT_ID ;
11632: --
11633: cursor c_ddr2(c_dsgn_rqmt_id number,c_mirror_src_entity_result_id number,
11634: c_table_alias varchar2) is

Line 11636: from BEN_DSGN_RQMT_F ddr

11632: --
11633: cursor c_ddr2(c_dsgn_rqmt_id number,c_mirror_src_entity_result_id number,
11634: c_table_alias varchar2) is
11635: select ddr.*
11636: from BEN_DSGN_RQMT_F ddr
11637: where ddr.dsgn_rqmt_id = c_dsgn_rqmt_id
11638: -- and ddr.business_group_id = p_business_group_id
11639: and not exists (
11640: select /*+ */ null

Line 11647: -- and trt.where_clause = 'BEN_DSGN_RQMT_F'

11643: where copy_entity_txn_id = p_copy_entity_txn_id
11644: -- and trt.table_route_id = cpe.table_route_id
11645: and ( -- c_mirror_src_entity_result_id is null or
11646: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
11647: -- and trt.where_clause = 'BEN_DSGN_RQMT_F'
11648: and cpe.table_alias = c_table_alias
11649: and information1 = c_dsgn_rqmt_id
11650: -- and information4 = ddr.business_group_id
11651: and information2 = ddr.effective_start_date

Line 11655: l_ddr2_dsgn_rqmt_esd ben_dsgn_rqmt_f.effective_start_date%type;

11651: and information2 = ddr.effective_start_date
11652: and information3 = ddr.effective_end_date
11653: );
11654:
11655: l_ddr2_dsgn_rqmt_esd ben_dsgn_rqmt_f.effective_start_date%type;
11656: ---------------------------------------------------------------
11657: -- END OF BEN_DSGN_RQMT_F ----------------------
11658: ---------------------------------------------------------------
11659: ---------------------------------------------------------------

Line 11657: -- END OF BEN_DSGN_RQMT_F ----------------------

11653: );
11654:
11655: l_ddr2_dsgn_rqmt_esd ben_dsgn_rqmt_f.effective_start_date%type;
11656: ---------------------------------------------------------------
11657: -- END OF BEN_DSGN_RQMT_F ----------------------
11658: ---------------------------------------------------------------
11659: ---------------------------------------------------------------
11660: -- START OF BEN_PL_TYP_OPT_TYP_F ----------------------
11661: ---------------------------------------------------------------

Line 11964: -- START OF BEN_DSGN_RQMT_F ----------------------

11960: --
11961: ) ;
11962: --
11963: ---------------------------------------------------------------
11964: -- START OF BEN_DSGN_RQMT_F ----------------------
11965: ---------------------------------------------------------------
11966: --
11967: for l_parent_rec in c_ddr2_from_parent(l_OPT_ID) loop
11968: --

Line 12165: -- END OF BEN_DSGN_RQMT_F ----------------------

12161: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
12162: ---------------------------------------------------------------
12163: end loop;
12164: ---------------------------------------------------------------
12165: -- END OF BEN_DSGN_RQMT_F ----------------------
12166: ---------------------------------------------------------------
12167: ---------------------------------------------------------------
12168: -- START OF BEN_PL_TYP_OPT_TYP_F ----------------------
12169: ---------------------------------------------------------------