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_ENRT_PERD_FOR_PL_F

Line 6305: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------

6301: ---------------------------------------------------------------
6302: -- END OF BEN_YR_PERD ----------------------
6303: ---------------------------------------------------------------
6304: ---------------------------------------------------------------
6305: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------
6306: ---------------------------------------------------------------
6307: cursor c_erp_from_parent(c_ENRT_PERD_ID number, c_pgm_id number) is
6308: select ERP.enrt_perd_for_pl_id
6309: from BEN_ENRT_PERD_FOR_PL_F ERP

Line 6309: from BEN_ENRT_PERD_FOR_PL_F ERP

6305: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------
6306: ---------------------------------------------------------------
6307: cursor c_erp_from_parent(c_ENRT_PERD_ID number, c_pgm_id number) is
6308: select ERP.enrt_perd_for_pl_id
6309: from BEN_ENRT_PERD_FOR_PL_F ERP
6310: where ENRT_PERD_ID = c_ENRT_PERD_ID
6311: and exists (select null
6312: from ben_plip_f plip
6313: where plip.pl_id = ERP.pl_id

Line 6320: from BEN_ENRT_PERD_FOR_PL_F erp

6316: plip.effective_start_date and plip.effective_end_date);
6317: --
6318: cursor c_erp(c_enrt_perd_for_pl_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
6319: select erp.*
6320: from BEN_ENRT_PERD_FOR_PL_F erp
6321: where erp.enrt_perd_for_pl_id = c_enrt_perd_for_pl_id
6322: -- and erp.business_group_id = p_business_group_id
6323: and not exists (
6324: select /*+ */ null

Line 6331: -- and trt.where_clause = 'BEN_ENRT_PERD_FOR_PL_F'

6327: where copy_entity_txn_id = p_copy_entity_txn_id
6328: -- and trt.table_route_id = cpe.table_route_id
6329: and ( -- c_mirror_src_entity_result_id is null or
6330: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6331: -- and trt.where_clause = 'BEN_ENRT_PERD_FOR_PL_F'
6332: and cpe.table_alias = c_table_alias
6333: and information1 = c_enrt_perd_for_pl_id
6334: -- and information4 = erp.business_group_id
6335: and information2 = erp.effective_start_date

Line 6340: -- END OF BEN_ENRT_PERD_FOR_PL_F ----------------------

6336: and information3 = erp.effective_end_date
6337: );
6338: l_out_erp_result_id number(15);
6339: ---------------------------------------------------------------
6340: -- END OF BEN_ENRT_PERD_FOR_PL_F ----------------------
6341: ---------------------------------------------------------------
6342: ---------------------------------------------------------------
6343: -- START OF BEN_SCHEDD_ENRT_RL_F ----------------------
6344: ---------------------------------------------------------------

Line 6409: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------

6405: ---------------------------------------------------------------
6406: -- END OF BEN_LEE_RSN_RL_F ----------------------
6407: ---------------------------------------------------------------
6408: ---------------------------------------------------------------
6409: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------
6410: ---------------------------------------------------------------
6411: cursor c_erp1_from_parent(c_LEE_RSN_ID number, c_pgm_id number) is
6412: select enrt_perd_for_pl_id
6413: from BEN_ENRT_PERD_FOR_PL_F ERP

Line 6413: from BEN_ENRT_PERD_FOR_PL_F ERP

6409: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------
6410: ---------------------------------------------------------------
6411: cursor c_erp1_from_parent(c_LEE_RSN_ID number, c_pgm_id number) is
6412: select enrt_perd_for_pl_id
6413: from BEN_ENRT_PERD_FOR_PL_F ERP
6414: where LEE_RSN_ID = c_LEE_RSN_ID
6415: and exists (select null
6416: from ben_plip_f plip
6417: where plip.pl_id = ERP.pl_id

Line 6424: from BEN_ENRT_PERD_FOR_PL_F erp

6420: plip.effective_start_date and plip.effective_end_date);
6421: --
6422: cursor c_erp1(c_enrt_perd_for_pl_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
6423: select erp.*
6424: from BEN_ENRT_PERD_FOR_PL_F erp
6425: where erp.enrt_perd_for_pl_id = c_enrt_perd_for_pl_id
6426: -- and erp.business_group_id = p_business_group_id
6427: and not exists (
6428: select /*+ */ null

Line 6435: -- and trt.where_clause = 'BEN_ENRT_PERD_FOR_PL_F'

6431: where copy_entity_txn_id = p_copy_entity_txn_id
6432: -- and trt.table_route_id = cpe.table_route_id
6433: and ( -- c_mirror_src_entity_result_id is null or
6434: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6435: -- and trt.where_clause = 'BEN_ENRT_PERD_FOR_PL_F'
6436: and cpe.table_alias = c_table_alias
6437: and information1 = c_enrt_perd_for_pl_id
6438: -- and information4 = erp.business_group_id
6439: and information2 = erp.effective_start_date

Line 6445: -- END OF BEN_ENRT_PERD_FOR_PL_F ----------------------

6441: );
6442:
6443: l_out_erp1_result_id number(15);
6444: ---------------------------------------------------------------
6445: -- END OF BEN_ENRT_PERD_FOR_PL_F ----------------------
6446: ---------------------------------------------------------------
6447: ---------------------------------------------------------------
6448: -- START OF BEN_ACTN_TYP ----------------------
6449: ---------------------------------------------------------------

Line 7286: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------

7282: ---------------------------------------------------------------
7283: -- END OF BEN_YR_PERD ----------------------
7284: ---------------------------------------------------------------
7285: ---------------------------------------------------------------
7286: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------
7287: ---------------------------------------------------------------
7288: --
7289: for l_parent_rec in c_erp_from_parent(l_ENRT_PERD_ID, p_pgm_id) loop
7290: --

Line 7437: -- END OF BEN_ENRT_PERD_FOR_PL_F ----------------------

7433: end loop;
7434: --
7435: end loop;
7436: ---------------------------------------------------------------
7437: -- END OF BEN_ENRT_PERD_FOR_PL_F ----------------------
7438: ---------------------------------------------------------------
7439: ---------------------------------------------------------------
7440: -- START OF BEN_SCHEDD_ENRT_RL_F ----------------------
7441: ---------------------------------------------------------------

Line 7757: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------

7753: ,p_effective_date => p_effective_date
7754: );
7755: end loop;
7756: ---------------------------------------------------------------
7757: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------
7758: ---------------------------------------------------------------
7759: --
7760: for l_parent_rec in c_erp1_from_parent(l_LEE_RSN_ID, p_pgm_id) loop
7761: --

Line 7859: -- END OF BEN_ENRT_PERD_FOR_PL_F ----------------------

7855: end loop;
7856: --
7857: end loop;
7858: ---------------------------------------------------------------
7859: -- END OF BEN_ENRT_PERD_FOR_PL_F ----------------------
7860: ---------------------------------------------------------------
7861: ---------------------------------------------------------------
7862: -- START OF BEN_LEE_RSN_RL_F ----------------------
7863: ---------------------------------------------------------------