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_POPL_RPTG_GRP_F

Line 1224: -- START OF BEN_POPL_RPTG_GRP_F ----------------------

1220: ---------------------------------------------------------------
1221: -- END OF BEN_PL_REGY_PRP_F ----------------------
1222: ---------------------------------------------------------------
1223: ---------------------------------------------------------------
1224: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
1225: ---------------------------------------------------------------
1226: cursor c_rgr1_from_parent(c_RPTG_GRP_ID number) is
1227: select popl_rptg_grp_id
1228: from BEN_POPL_RPTG_GRP_F

Line 1228: from BEN_POPL_RPTG_GRP_F

1224: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
1225: ---------------------------------------------------------------
1226: cursor c_rgr1_from_parent(c_RPTG_GRP_ID number) is
1227: select popl_rptg_grp_id
1228: from BEN_POPL_RPTG_GRP_F
1229: where RPTG_GRP_ID = c_RPTG_GRP_ID ;
1230: --
1231: cursor c_rgr1(c_popl_rptg_grp_id number,c_mirror_src_entity_result_id number,
1232: c_table_alias varchar2) is

Line 1234: from BEN_POPL_RPTG_GRP_F rgr

1230: --
1231: cursor c_rgr1(c_popl_rptg_grp_id number,c_mirror_src_entity_result_id number,
1232: c_table_alias varchar2) is
1233: select rgr.*
1234: from BEN_POPL_RPTG_GRP_F rgr
1235: where rgr.popl_rptg_grp_id = c_popl_rptg_grp_id
1236: -- and rgr.business_group_id = p_business_group_id
1237: and not exists (
1238: select /*+ */ null

Line 1245: -- and trt.where_clause = 'BEN_POPL_RPTG_GRP_F'

1241: where copy_entity_txn_id = p_copy_entity_txn_id
1242: -- and trt.table_route_id = cpe.table_route_id
1243: and ( -- c_mirror_src_entity_result_id is null or
1244: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1245: -- and trt.where_clause = 'BEN_POPL_RPTG_GRP_F'
1246: and cpe.table_alias = c_table_alias
1247: and information1 = c_popl_rptg_grp_id
1248: -- and information4 = rgr.business_group_id
1249: and information2 = rgr.effective_start_date

Line 1254: -- END OF BEN_POPL_RPTG_GRP_F ----------------------

1250: and information3 = rgr.effective_end_date
1251: );
1252: l_popl_rptg_grp_id number(15);
1253: ---------------------------------------------------------------
1254: -- END OF BEN_POPL_RPTG_GRP_F ----------------------
1255: ---------------------------------------------------------------
1256: ---------------------------------------------------------------
1257: -- START OF BEN_REGN_F ----------------------
1258: ---------------------------------------------------------------

Line 3103: -- START OF BEN_POPL_RPTG_GRP_F ----------------------

3099: ---------------------------------------------------------------
3100: -- END OF BEN_PL_REGY_BOD_F ----------------------
3101: ---------------------------------------------------------------
3102: ---------------------------------------------------------------
3103: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
3104: ---------------------------------------------------------------
3105: --
3106: /* NOT REQUIRED HERE
3107:

Line 3110: -- END OF BEN_POPL_RPTG_GRP_F ----------------------

3106: /* NOT REQUIRED HERE
3107:
3108: */
3109: ---------------------------------------------------------------
3110: -- END OF BEN_POPL_RPTG_GRP_F ----------------------
3111: ---------------------------------------------------------------
3112: --
3113: end loop;
3114: ---------------------------------------------------------------

Line 6080: -- START OF BEN_POPL_RPTG_GRP_F ----------------------

6076: ---------------------------------------------------------------
6077: -- END OF BEN_POPL_YR_PERD ----------------------
6078: ---------------------------------------------------------------
6079: ---------------------------------------------------------------
6080: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
6081: ---------------------------------------------------------------
6082: cursor c_rgr_from_parent(c_PL_ID number, c_PGM_ID number ) is
6083: select popl_rptg_grp_id
6084: from BEN_POPL_RPTG_GRP_F

Line 6084: from BEN_POPL_RPTG_GRP_F

6080: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
6081: ---------------------------------------------------------------
6082: cursor c_rgr_from_parent(c_PL_ID number, c_PGM_ID number ) is
6083: select popl_rptg_grp_id
6084: from BEN_POPL_RPTG_GRP_F
6085: -- where PL_ID = c_PL_ID ;
6086: where ( c_PL_ID is not null and c_PL_ID = PL_ID ) or
6087: ( c_PGM_ID is not null and c_PGM_ID = PGM_ID);
6088: --

Line 6092: from BEN_POPL_RPTG_GRP_F rgr

6088: --
6089: cursor c_rgr(c_popl_rptg_grp_id number,c_mirror_src_entity_result_id number,
6090: c_table_alias varchar2) is
6091: select rgr.*
6092: from BEN_POPL_RPTG_GRP_F rgr
6093: where rgr.popl_rptg_grp_id = c_popl_rptg_grp_id
6094: -- and rgr.business_group_id = p_business_group_id
6095: and not exists (
6096: select /*+ */ null

Line 6103: -- and trt.where_clause = 'BEN_POPL_RPTG_GRP_F'

6099: where copy_entity_txn_id = p_copy_entity_txn_id
6100: -- and trt.table_route_id = cpe.table_route_id
6101: and ( -- c_mirror_src_entity_result_id is null or
6102: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6103: -- and trt.where_clause = 'BEN_POPL_RPTG_GRP_F'
6104: and cpe.table_alias = c_table_alias
6105: and information1 = c_popl_rptg_grp_id
6106: -- and information4 = rgr.business_group_id
6107: and information2 = rgr.effective_start_date

Line 6112: -- END OF BEN_POPL_RPTG_GRP_F ----------------------

6108: and information3 = rgr.effective_end_date
6109: );
6110: l_out_rgr_result_id number(15);
6111: ---------------------------------------------------------------
6112: -- END OF BEN_POPL_RPTG_GRP_F ----------------------
6113: ---------------------------------------------------------------
6114: ---
6115: ---------------------------------------------------------------
6116: -- START OF BEN_YR_PERD ----------------------

Line 6164: from BEN_POPL_RPTG_GRP_F

6160: -- START OF BEN_RPTG_GRP ----------------------
6161: ---------------------------------------------------------------
6162: cursor c_bnr_from_parent(c_POPL_RPTG_GRP_ID number) is
6163: select rptg_grp_id
6164: from BEN_POPL_RPTG_GRP_F
6165: where POPL_RPTG_GRP_ID = c_POPL_RPTG_GRP_ID ;
6166: --
6167: cursor c_bnr(c_rptg_grp_id number,c_mirror_src_entity_result_id number,
6168: c_table_alias varchar2) is

Line 6581: -- START OF BEN_POPL_RPTG_GRP_F ----------------------

6577: ---------------------------------------------------------------
6578: -- END OF BEN_PL_REGY_PRP_F ----------------------
6579: ---------------------------------------------------------------
6580: ---------------------------------------------------------------
6581: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
6582: ---------------------------------------------------------------
6583: cursor c_rgr1_from_parent(c_RPTG_GRP_ID number) is
6584: select popl_rptg_grp_id
6585: from BEN_POPL_RPTG_GRP_F

Line 6585: from BEN_POPL_RPTG_GRP_F

6581: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
6582: ---------------------------------------------------------------
6583: cursor c_rgr1_from_parent(c_RPTG_GRP_ID number) is
6584: select popl_rptg_grp_id
6585: from BEN_POPL_RPTG_GRP_F
6586: where RPTG_GRP_ID = c_RPTG_GRP_ID ;
6587: --
6588: cursor c_rgr1(c_popl_rptg_grp_id number,c_mirror_src_entity_result_id number,
6589: c_table_alias varchar2) is

Line 6591: from BEN_POPL_RPTG_GRP_F rgr

6587: --
6588: cursor c_rgr1(c_popl_rptg_grp_id number,c_mirror_src_entity_result_id number,
6589: c_table_alias varchar2) is
6590: select rgr.*
6591: from BEN_POPL_RPTG_GRP_F rgr
6592: where rgr.popl_rptg_grp_id = c_popl_rptg_grp_id
6593: -- and rgr.business_group_id = p_business_group_id
6594: and not exists (
6595: select /*+ */ null

Line 6602: -- and trt.where_clause = 'BEN_POPL_RPTG_GRP_F'

6598: where copy_entity_txn_id = p_copy_entity_txn_id
6599: -- and trt.table_route_id = cpe.table_route_id
6600: and ( -- c_mirror_src_entity_result_id is null or
6601: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6602: -- and trt.where_clause = 'BEN_POPL_RPTG_GRP_F'
6603: and cpe.table_alias = c_table_alias
6604: and information1 = c_popl_rptg_grp_id
6605: -- and information4 = rgr.business_group_id
6606: and information2 = rgr.effective_start_date

Line 6610: -- END OF BEN_POPL_RPTG_GRP_F ----------------------

6606: and information2 = rgr.effective_start_date
6607: and information3 = rgr.effective_end_date
6608: );
6609: ---------------------------------------------------------------
6610: -- END OF BEN_POPL_RPTG_GRP_F ----------------------
6611: ---------------------------------------------------------------
6612: ---------------------------------------------------------------
6613: -- START OF BEN_REGN_F ----------------------
6614: ---------------------------------------------------------------

Line 8346: -- START OF BEN_POPL_RPTG_GRP_F ----------------------

8342: -- END OF BEN_POPL_YR_PERD ----------------------
8343: ---------------------------------------------------------------
8344: ---------------------------------------------------------------
8345: ---------------------------------------------------------------
8346: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
8347: ---------------------------------------------------------------
8348: --
8349: --
8350: for l_parent_rec in c_rgr_from_parent(p_pl_id,p_pgm_id) loop

Line 8970: -- START OF BEN_POPL_RPTG_GRP_F ----------------------

8966: ---------------------------------------------------------------
8967: -- END OF BEN_PL_REGY_BOD_F ----------------------
8968: ---------------------------------------------------------------
8969: ---------------------------------------------------------------
8970: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
8971: ---------------------------------------------------------------
8972: --
8973: /* NOT REQUIRED HERE
8974: */

Line 8976: -- END OF BEN_POPL_RPTG_GRP_F ----------------------

8972: --
8973: /* NOT REQUIRED HERE
8974: */
8975: ---------------------------------------------------------------
8976: -- END OF BEN_POPL_RPTG_GRP_F ----------------------
8977: ---------------------------------------------------------------
8978: end loop;
8979: ---------------------------------------------------------------
8980: -- END OF BEN_RPTG_GRP ----------------------

Line 8984: -- END OF BEN_POPL_RPTG_GRP_F ----------------------

8980: -- END OF BEN_RPTG_GRP ----------------------
8981: ---------------------------------------------------------------
8982: end loop;
8983: ---------------------------------------------------------------
8984: -- END OF BEN_POPL_RPTG_GRP_F ----------------------
8985: ---------------------------------------------------------------
8986: --
8987: hr_utility.set_location('Entering:'|| l_proc, 10);
8988: --