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_ELPRO_MODULE dependencies on BEN_ELIG_BENFTS_GRP_PRTE_F

Line 1386: -- START OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------

1382: ---------------------------------------------------------------
1383: -- END OF BEN_ELIG_ASNT_SET_PRTE_F ----------------------
1384: ---------------------------------------------------------------
1385: ---------------------------------------------------------------
1386: -- START OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------
1387: ---------------------------------------------------------------
1388: cursor c_ebn_from_parent(c_ELIGY_PRFL_ID number) is
1389: select distinct elig_benfts_grp_prte_id
1390: from BEN_ELIG_BENFTS_GRP_PRTE_F

Line 1390: from BEN_ELIG_BENFTS_GRP_PRTE_F

1386: -- START OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------
1387: ---------------------------------------------------------------
1388: cursor c_ebn_from_parent(c_ELIGY_PRFL_ID number) is
1389: select distinct elig_benfts_grp_prte_id
1390: from BEN_ELIG_BENFTS_GRP_PRTE_F
1391: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1392: --
1393: cursor c_ebn(c_elig_benfts_grp_prte_id number,c_mirror_src_entity_result_id number ,
1394: c_table_alias varchar2 ) is

Line 1396: from BEN_ELIG_BENFTS_GRP_PRTE_F ebn

1392: --
1393: cursor c_ebn(c_elig_benfts_grp_prte_id number,c_mirror_src_entity_result_id number ,
1394: c_table_alias varchar2 ) is
1395: select ebn.*
1396: from BEN_ELIG_BENFTS_GRP_PRTE_F ebn
1397: where ebn.elig_benfts_grp_prte_id = c_elig_benfts_grp_prte_id
1398: -- and ebn.business_group_id = p_business_group_id
1399: and not exists (
1400: select /* */ null

Line 1407: -- and trt.where_clause = 'BEN_ELIG_BENFTS_GRP_PRTE_F'

1403: where copy_entity_txn_id = p_copy_entity_txn_id
1404: -- and trt.table_route_id = cpe.table_route_id
1405: and ( -- c_mirror_src_entity_result_id is null or
1406: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1407: -- and trt.where_clause = 'BEN_ELIG_BENFTS_GRP_PRTE_F'
1408: and cpe.table_alias = c_table_alias
1409: and information1 = c_elig_benfts_grp_prte_id
1410: -- and information4 = ebn.business_group_id
1411: and information2 = ebn.effective_start_date

Line 1425: -- and trt.where_clause = 'BEN_ELIG_BENFTS_GRP_PRTE_F'

1421: -- pqh_table_route trt
1422: where copy_entity_txn_id = p_copy_entity_txn_id
1423: -- and trt.table_route_id = cpe.table_route_id
1424: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
1425: -- and trt.where_clause = 'BEN_ELIG_BENFTS_GRP_PRTE_F'
1426: and cpe.table_alias = c_table_alias
1427: and information1 = c_elig_benfts_grp_prte_id
1428: -- and information4 = p_business_group_id
1429: ;

Line 1431: -- END OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------

1427: and information1 = c_elig_benfts_grp_prte_id
1428: -- and information4 = p_business_group_id
1429: ;
1430: ---------------------------------------------------------------
1431: -- END OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------
1432: ---------------------------------------------------------------
1433: ---------------------------------------------------------------
1434: -- START OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------
1435: ---------------------------------------------------------------

Line 4642: -- START OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------

4638: ---------------------------------------------------------------
4639: -- END OF BEN_ELIG_ASNT_SET_PRTE_F ----------------------
4640: ---------------------------------------------------------------
4641: ---------------------------------------------------------------
4642: -- START OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------
4643: ---------------------------------------------------------------
4644: --
4645: for l_parent_rec in c_ebn_from_parent(l_ELIGY_PRFL_ID) loop
4646: --

Line 4757: -- END OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------

4753: );
4754: end loop;
4755: end loop;
4756: ---------------------------------------------------------------
4757: -- END OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------
4758: ---------------------------------------------------------------
4759: ---------------------------------------------------------------
4760: -- START OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------
4761: ---------------------------------------------------------------