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_RLSHP_TYP

Line 1084: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------

1080: ---------------------------------------------------------------
1081: -- END OF BEN_DSGN_RQMT_F ----------------------
1082: ---------------------------------------------------------------
1083: ---------------------------------------------------------------
1084: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
1085: ---------------------------------------------------------------
1086: cursor c_drr3_from_parent(c_DSGN_RQMT_ID number) is
1087: select dsgn_rqmt_rlshp_typ_id
1088: from BEN_DSGN_RQMT_RLSHP_TYP

Line 1088: from BEN_DSGN_RQMT_RLSHP_TYP

1084: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
1085: ---------------------------------------------------------------
1086: cursor c_drr3_from_parent(c_DSGN_RQMT_ID number) is
1087: select dsgn_rqmt_rlshp_typ_id
1088: from BEN_DSGN_RQMT_RLSHP_TYP
1089: where DSGN_RQMT_ID = c_DSGN_RQMT_ID ;
1090: --
1091: cursor c_drr3(c_dsgn_rqmt_rlshp_typ_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
1092: select drr.*

Line 1093: from BEN_DSGN_RQMT_RLSHP_TYP drr

1089: where DSGN_RQMT_ID = c_DSGN_RQMT_ID ;
1090: --
1091: cursor c_drr3(c_dsgn_rqmt_rlshp_typ_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
1092: select drr.*
1093: from BEN_DSGN_RQMT_RLSHP_TYP drr
1094: where drr.dsgn_rqmt_rlshp_typ_id = c_dsgn_rqmt_rlshp_typ_id
1095: -- and drr.business_group_id = p_business_group_id
1096: and not exists (
1097: select /*+ */ null

Line 1104: -- and trt.where_clause = 'BEN_DSGN_RQMT_RLSHP_TYP'

1100: where copy_entity_txn_id = p_copy_entity_txn_id
1101: -- and trt.table_route_id = cpe.table_route_id
1102: and ( -- c_mirror_src_entity_result_id is null or
1103: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1104: -- and trt.where_clause = 'BEN_DSGN_RQMT_RLSHP_TYP'
1105: and cpe.table_alias = c_table_alias
1106: and information1 = c_dsgn_rqmt_rlshp_typ_id
1107: -- and information4 = drr.business_group_id
1108: );

Line 1111: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------

1107: -- and information4 = drr.business_group_id
1108: );
1109:
1110: ---------------------------------------------------------------
1111: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
1112: ---------------------------------------------------------------
1113: ---------------------------------------------------------------
1114: -- START OF BEN_OIPL_F ----------------------
1115: ---------------------------------------------------------------

Line 5692: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------

5688:
5689: end loop;
5690: --
5691: ---------------------------------------------------------------
5692: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
5693: ---------------------------------------------------------------
5694: --
5695: for l_parent_rec in c_drr3_from_parent(l_DSGN_RQMT_ID) loop
5696: --

Line 5780: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------

5776: end loop;
5777: --
5778: end loop;
5779: ---------------------------------------------------------------
5780: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
5781: ---------------------------------------------------------------
5782: end loop;
5783: ---------------------------------------------------------------
5784: -- END OF BEN_DSGN_RQMT_F ----------------------

Line 10158: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------

10154: ---------------------------------------------------------------
10155: -- END OF BEN_DSGN_RQMT_F ----------------------
10156: ---------------------------------------------------------------
10157: ---------------------------------------------------------------
10158: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
10159: ---------------------------------------------------------------
10160: cursor c_drr1_from_parent(c_DSGN_RQMT_ID number) is
10161: select dsgn_rqmt_rlshp_typ_id
10162: from BEN_DSGN_RQMT_RLSHP_TYP

Line 10162: from BEN_DSGN_RQMT_RLSHP_TYP

10158: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
10159: ---------------------------------------------------------------
10160: cursor c_drr1_from_parent(c_DSGN_RQMT_ID number) is
10161: select dsgn_rqmt_rlshp_typ_id
10162: from BEN_DSGN_RQMT_RLSHP_TYP
10163: where DSGN_RQMT_ID = c_DSGN_RQMT_ID ;
10164: --
10165: cursor c_drr1(c_dsgn_rqmt_rlshp_typ_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
10166: select drr.*

Line 10167: from BEN_DSGN_RQMT_RLSHP_TYP drr

10163: where DSGN_RQMT_ID = c_DSGN_RQMT_ID ;
10164: --
10165: cursor c_drr1(c_dsgn_rqmt_rlshp_typ_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
10166: select drr.*
10167: from BEN_DSGN_RQMT_RLSHP_TYP drr
10168: where drr.dsgn_rqmt_rlshp_typ_id = c_dsgn_rqmt_rlshp_typ_id
10169: -- and drr.business_group_id = p_business_group_id
10170: and not exists (
10171: select /*+ */ null

Line 10178: -- and trt.where_clause = 'BEN_DSGN_RQMT_RLSHP_TYP'

10174: where copy_entity_txn_id = p_copy_entity_txn_id
10175: -- and trt.table_route_id = cpe.table_route_id
10176: and ( -- c_mirror_src_entity_result_id is null or
10177: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10178: -- and trt.where_clause = 'BEN_DSGN_RQMT_RLSHP_TYP'
10179: and cpe.table_alias = c_table_alias
10180: and information1 = c_dsgn_rqmt_rlshp_typ_id
10181: -- and information4 = drr.business_group_id
10182: );

Line 10186: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------

10182: );
10183: l_dsgn_rqmt_rlshp_typ_id number(15);
10184: l_out_drr_result_id number(15);
10185: ---------------------------------------------------------------
10186: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
10187: ---------------------------------------------------------------
10188: ---------------------------------------------------------------
10189: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
10190: ---------------------------------------------------------------

Line 10801: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------

10797:
10798: end loop;
10799: --
10800: ---------------------------------------------------------------
10801: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
10802: ---------------------------------------------------------------
10803: --
10804: for l_parent_rec in c_drr1_from_parent(l_DSGN_RQMT_ID) loop
10805: --

Line 10889: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------

10885: end loop;
10886: --
10887: end loop;
10888: ---------------------------------------------------------------
10889: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
10890: ---------------------------------------------------------------
10891: end loop;
10892: ---------------------------------------------------------------
10893: -- END OF BEN_DSGN_RQMT_F ----------------------

Line 11693: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------

11689: ---------------------------------------------------------------
11690: -- END OF BEN_PL_TYP_OPT_TYP_F ----------------------
11691: ---------------------------------------------------------------
11692: ---------------------------------------------------------------
11693: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
11694: ---------------------------------------------------------------
11695: cursor c_drr2_from_parent(c_DSGN_RQMT_ID number) is
11696: select dsgn_rqmt_rlshp_typ_id
11697: from BEN_DSGN_RQMT_RLSHP_TYP

Line 11697: from BEN_DSGN_RQMT_RLSHP_TYP

11693: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
11694: ---------------------------------------------------------------
11695: cursor c_drr2_from_parent(c_DSGN_RQMT_ID number) is
11696: select dsgn_rqmt_rlshp_typ_id
11697: from BEN_DSGN_RQMT_RLSHP_TYP
11698: where DSGN_RQMT_ID = c_DSGN_RQMT_ID ;
11699: --
11700: cursor c_drr2(c_dsgn_rqmt_rlshp_typ_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
11701: select drr.*

Line 11702: from BEN_DSGN_RQMT_RLSHP_TYP drr

11698: where DSGN_RQMT_ID = c_DSGN_RQMT_ID ;
11699: --
11700: cursor c_drr2(c_dsgn_rqmt_rlshp_typ_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
11701: select drr.*
11702: from BEN_DSGN_RQMT_RLSHP_TYP drr
11703: where drr.dsgn_rqmt_rlshp_typ_id = c_dsgn_rqmt_rlshp_typ_id
11704: -- and drr.business_group_id = p_business_group_id
11705: and not exists (
11706: select /*+ */ null

Line 11713: -- and trt.where_clause = 'BEN_DSGN_RQMT_RLSHP_TYP'

11709: where copy_entity_txn_id = p_copy_entity_txn_id
11710: -- and trt.table_route_id = cpe.table_route_id
11711: and ( -- c_mirror_src_entity_result_id is null or
11712: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
11713: -- and trt.where_clause = 'BEN_DSGN_RQMT_RLSHP_TYP'
11714: and cpe.table_alias = c_table_alias
11715: and information1 = c_dsgn_rqmt_rlshp_typ_id
11716: -- and information4 = drr.business_group_id
11717: );

Line 11719: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------

11715: and information1 = c_dsgn_rqmt_rlshp_typ_id
11716: -- and information4 = drr.business_group_id
11717: );
11718: ---------------------------------------------------------------
11719: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
11720: ---------------------------------------------------------------
11721: ---------------------------------------------------------------
11722: -- START OF BEN_PL_TYP_F ----------------------
11723: ---------------------------------------------------------------

Line 12073: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------

12069:
12070: end loop;
12071: --
12072: ---------------------------------------------------------------
12073: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
12074: ---------------------------------------------------------------
12075: --
12076: for l_parent_rec in c_drr2_from_parent(l_DSGN_RQMT_ID) loop
12077: --

Line 12161: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------

12157: end loop;
12158: --
12159: end loop;
12160: ---------------------------------------------------------------
12161: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
12162: ---------------------------------------------------------------
12163: end loop;
12164: ---------------------------------------------------------------
12165: -- END OF BEN_DSGN_RQMT_F ----------------------