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_TYP_OPT_TYP_F

Line 11660: -- START OF BEN_PL_TYP_OPT_TYP_F ----------------------

11656: ---------------------------------------------------------------
11657: -- END OF BEN_DSGN_RQMT_F ----------------------
11658: ---------------------------------------------------------------
11659: ---------------------------------------------------------------
11660: -- START OF BEN_PL_TYP_OPT_TYP_F ----------------------
11661: ---------------------------------------------------------------
11662: cursor c_pon1_from_parent(c_OPT_ID number) is
11663: select pl_typ_opt_typ_id
11664: from BEN_PL_TYP_OPT_TYP_F

Line 11664: from BEN_PL_TYP_OPT_TYP_F

11660: -- START OF BEN_PL_TYP_OPT_TYP_F ----------------------
11661: ---------------------------------------------------------------
11662: cursor c_pon1_from_parent(c_OPT_ID number) is
11663: select pl_typ_opt_typ_id
11664: from BEN_PL_TYP_OPT_TYP_F
11665: where OPT_ID = c_OPT_ID ;
11666: --
11667: cursor c_pon1(c_pl_typ_opt_typ_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
11668: select pon.*

Line 11669: from BEN_PL_TYP_OPT_TYP_F pon

11665: where OPT_ID = c_OPT_ID ;
11666: --
11667: cursor c_pon1(c_pl_typ_opt_typ_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
11668: select pon.*
11669: from BEN_PL_TYP_OPT_TYP_F pon
11670: where pon.pl_typ_opt_typ_id = c_pl_typ_opt_typ_id
11671: -- and pon.business_group_id = p_business_group_id
11672: and not exists (
11673: select /*+ */ null

Line 11680: -- and trt.where_clause = 'BEN_PL_TYP_OPT_TYP_F'

11676: where copy_entity_txn_id = p_copy_entity_txn_id
11677: -- and trt.table_route_id = cpe.table_route_id
11678: and ( -- c_mirror_src_entity_result_id is null or
11679: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
11680: -- and trt.where_clause = 'BEN_PL_TYP_OPT_TYP_F'
11681: and cpe.table_alias = c_table_alias
11682: and information1 = c_pl_typ_opt_typ_id
11683: -- and information4 = pon.business_group_id
11684: and information2 = pon.effective_start_date

Line 11690: -- END OF BEN_PL_TYP_OPT_TYP_F ----------------------

11686: );
11687: l_pl_typ_opt_typ_id number(15);
11688: l_out_pon_result_id number(15);
11689: ---------------------------------------------------------------
11690: -- END OF BEN_PL_TYP_OPT_TYP_F ----------------------
11691: ---------------------------------------------------------------
11692: ---------------------------------------------------------------
11693: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
11694: ---------------------------------------------------------------

Line 11726: from BEN_PL_TYP_OPT_TYP_F

11722: -- START OF BEN_PL_TYP_F ----------------------
11723: ---------------------------------------------------------------
11724: cursor c_ptp1_from_parent(c_PL_TYP_OPT_TYP_ID number) is
11725: select distinct pl_typ_id
11726: from BEN_PL_TYP_OPT_TYP_F
11727: where PL_TYP_OPT_TYP_ID = c_PL_TYP_OPT_TYP_ID ;
11728: --
11729: ---------------------------------------------------------------
11730: -- END OF BEN_PL_TYP_F ----------------------

Line 12168: -- START OF BEN_PL_TYP_OPT_TYP_F ----------------------

12164: ---------------------------------------------------------------
12165: -- END OF BEN_DSGN_RQMT_F ----------------------
12166: ---------------------------------------------------------------
12167: ---------------------------------------------------------------
12168: -- START OF BEN_PL_TYP_OPT_TYP_F ----------------------
12169: ---------------------------------------------------------------
12170: --
12171: for l_parent_rec in c_pon1_from_parent(l_OPT_ID) loop
12172: --

Line 12283: -- END OF BEN_PL_TYP_OPT_TYP_F ----------------------

12279: -- END OF BEN_PL_TYP_F ----------------------
12280: ---------------------------------------------------------------
12281: end loop;
12282: ---------------------------------------------------------------
12283: -- END OF BEN_PL_TYP_OPT_TYP_F ----------------------
12284: ---------------------------------------------------------------
12285:
12286: end if;
12287: ---------------------------------------------------------------