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_CMBN_AGE_LOS_PRTE_F

Line 1502: -- START OF BEN_ELIG_CMBN_AGE_LOS_PRTE_F ----------------------

1498: ---------------------------------------------------------------
1499: -- END OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------
1500: ---------------------------------------------------------------
1501: ---------------------------------------------------------------
1502: -- START OF BEN_ELIG_CMBN_AGE_LOS_PRTE_F ----------------------
1503: ---------------------------------------------------------------
1504: cursor c_ecp_from_parent(c_ELIGY_PRFL_ID number) is
1505: select distinct elig_cmbn_age_los_prte_id
1506: from BEN_ELIG_CMBN_AGE_LOS_PRTE_F

Line 1506: from BEN_ELIG_CMBN_AGE_LOS_PRTE_F

1502: -- START OF BEN_ELIG_CMBN_AGE_LOS_PRTE_F ----------------------
1503: ---------------------------------------------------------------
1504: cursor c_ecp_from_parent(c_ELIGY_PRFL_ID number) is
1505: select distinct elig_cmbn_age_los_prte_id
1506: from BEN_ELIG_CMBN_AGE_LOS_PRTE_F
1507: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1508: --
1509: cursor c_ecp(c_elig_cmbn_age_los_prte_id number,c_mirror_src_entity_result_id number ,
1510: c_table_alias varchar2 ) is

Line 1512: from BEN_ELIG_CMBN_AGE_LOS_PRTE_F ecp

1508: --
1509: cursor c_ecp(c_elig_cmbn_age_los_prte_id number,c_mirror_src_entity_result_id number ,
1510: c_table_alias varchar2 ) is
1511: select ecp.*
1512: from BEN_ELIG_CMBN_AGE_LOS_PRTE_F ecp
1513: where ecp.elig_cmbn_age_los_prte_id = c_elig_cmbn_age_los_prte_id
1514: -- and ecp.business_group_id = p_business_group_id
1515: and not exists (
1516: select /* */ null

Line 1523: -- and trt.where_clause = 'BEN_ELIG_CMBN_AGE_LOS_PRTE_F'

1519: where copy_entity_txn_id = p_copy_entity_txn_id
1520: -- and trt.table_route_id = cpe.table_route_id
1521: and ( -- c_mirror_src_entity_result_id is null or
1522: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1523: -- and trt.where_clause = 'BEN_ELIG_CMBN_AGE_LOS_PRTE_F'
1524: and cpe.table_alias = c_table_alias
1525: and information1 = c_elig_cmbn_age_los_prte_id
1526: -- and information4 = ecp.business_group_id
1527: and information2 = ecp.effective_start_date

Line 1541: -- and trt.where_clause = 'BEN_ELIG_CMBN_AGE_LOS_PRTE_F'

1537: -- pqh_table_route trt
1538: where copy_entity_txn_id = p_copy_entity_txn_id
1539: -- and trt.table_route_id = cpe.table_route_id
1540: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
1541: -- and trt.where_clause = 'BEN_ELIG_CMBN_AGE_LOS_PRTE_F'
1542: and cpe.table_alias = c_table_alias
1543: and information1 = c_elig_cmbn_age_los_prte_id
1544: -- and information4 = p_business_group_id
1545: ;

Line 1547: -- END OF BEN_ELIG_CMBN_AGE_LOS_PRTE_F ----------------------

1543: and information1 = c_elig_cmbn_age_los_prte_id
1544: -- and information4 = p_business_group_id
1545: ;
1546: ---------------------------------------------------------------
1547: -- END OF BEN_ELIG_CMBN_AGE_LOS_PRTE_F ----------------------
1548: ---------------------------------------------------------------
1549: ---------------------------------------------------------------
1550: -- START OF BEN_ELIG_COMP_LVL_PRTE_F ----------------------
1551: ---------------------------------------------------------------

Line 4977: -- START OF BEN_ELIG_CMBN_AGE_LOS_PRTE_F ----------------------

4973: ---------------------------------------------------------------
4974: -- END OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------
4975: ---------------------------------------------------------------
4976: ---------------------------------------------------------------
4977: -- START OF BEN_ELIG_CMBN_AGE_LOS_PRTE_F ----------------------
4978: ---------------------------------------------------------------
4979: --
4980: for l_parent_rec in c_ecp_from_parent(l_ELIGY_PRFL_ID) loop
4981: --

Line 5098: -- END OF BEN_ELIG_CMBN_AGE_LOS_PRTE_F ----------------------

5094: );
5095: end loop;
5096: end loop;
5097: ---------------------------------------------------------------
5098: -- END OF BEN_ELIG_CMBN_AGE_LOS_PRTE_F ----------------------
5099: ---------------------------------------------------------------
5100: ---------------------------------------------------------------
5101: -- START OF BEN_ELIG_COMP_LVL_PRTE_F ----------------------
5102: ---------------------------------------------------------------