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_ELIG_TO_PRTE_RSN_F

Line 720: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

716: ---------------------------------------------------------------
717: -- END OF BEN_PL_DPNT_CVG_CTFN_F ----------------------
718: ---------------------------------------------------------------
719: ---------------------------------------------------------------
720: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
721: ---------------------------------------------------------------
722: cursor c_peo_from_parent(c_PL_ID number) is
723: select elig_to_prte_rsn_id
724: from BEN_ELIG_TO_PRTE_RSN_F

Line 724: from BEN_ELIG_TO_PRTE_RSN_F

720: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
721: ---------------------------------------------------------------
722: cursor c_peo_from_parent(c_PL_ID number) is
723: select elig_to_prte_rsn_id
724: from BEN_ELIG_TO_PRTE_RSN_F
725: where PL_ID = c_PL_ID ;
726: --
727: cursor c_peo(c_elig_to_prte_rsn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
728: select peo.*

Line 729: from BEN_ELIG_TO_PRTE_RSN_F peo

725: where PL_ID = c_PL_ID ;
726: --
727: cursor c_peo(c_elig_to_prte_rsn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
728: select peo.*
729: from BEN_ELIG_TO_PRTE_RSN_F peo
730: where peo.elig_to_prte_rsn_id = c_elig_to_prte_rsn_id
731: -- and peo.business_group_id = p_business_group_id
732: and not exists (
733: select /*+ */ null

Line 740: -- and trt.where_clause = 'BEN_ELIG_TO_PRTE_RSN_F'

736: where copy_entity_txn_id = p_copy_entity_txn_id
737: -- and trt.table_route_id = cpe.table_route_id
738: and ( -- c_mirror_src_entity_result_id is null or
739: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
740: -- and trt.where_clause = 'BEN_ELIG_TO_PRTE_RSN_F'
741: and cpe.table_alias = c_table_alias
742: and information1 = c_elig_to_prte_rsn_id
743: -- and information4 = peo.business_group_id
744: and information2 = peo.effective_start_date

Line 750: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

746: );
747:
748: l_out_peo_result_id number(15);
749: ---------------------------------------------------------------
750: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
751: ---------------------------------------------------------------
752: ---------------------------------------------------------------
753: -- START OF BEN_GD_OR_SVC_TYP ----------------------
754: ---------------------------------------------------------------

Line 5365: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

5361: -- END OF BEN_PL_DPNT_CVG_CTFN_F ----------------------
5362: ---------------------------------------------------------------
5363: ---------------------------------------------------------------
5364: ---------------------------------------------------------------
5365: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
5366: ---------------------------------------------------------------
5367: --
5368: --
5369: for l_parent_rec in c_peo_from_parent(l_PL_ID) loop

Line 5579: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

5575: end loop;
5576: --
5577: end loop;
5578: ---------------------------------------------------------------
5579: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
5580: ---------------------------------------------------------------
5581: ---------------------------------------------------------------
5582: -- START OF BEN_DSGN_RQMT_F ----------------------
5583: ---------------------------------------------------------------

Line 10189: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

10185: ---------------------------------------------------------------
10186: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
10187: ---------------------------------------------------------------
10188: ---------------------------------------------------------------
10189: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
10190: ---------------------------------------------------------------
10191: cursor c_peo1_from_parent(c_OIPL_ID number) is
10192: select elig_to_prte_rsn_id
10193: from BEN_ELIG_TO_PRTE_RSN_F

Line 10193: from BEN_ELIG_TO_PRTE_RSN_F

10189: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
10190: ---------------------------------------------------------------
10191: cursor c_peo1_from_parent(c_OIPL_ID number) is
10192: select elig_to_prte_rsn_id
10193: from BEN_ELIG_TO_PRTE_RSN_F
10194: where OIPL_ID = c_OIPL_ID ;
10195: --
10196: cursor c_peo1(c_elig_to_prte_rsn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
10197: select peo.*

Line 10198: from BEN_ELIG_TO_PRTE_RSN_F peo

10194: where OIPL_ID = c_OIPL_ID ;
10195: --
10196: cursor c_peo1(c_elig_to_prte_rsn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
10197: select peo.*
10198: from BEN_ELIG_TO_PRTE_RSN_F peo
10199: where peo.elig_to_prte_rsn_id = c_elig_to_prte_rsn_id
10200: -- and peo.business_group_id = p_business_group_id
10201: and not exists (
10202: select /*+ */ null

Line 10209: -- and trt.where_clause = 'BEN_ELIG_TO_PRTE_RSN_F'

10205: where copy_entity_txn_id = p_copy_entity_txn_id
10206: -- and trt.table_route_id = cpe.table_route_id
10207: and ( -- c_mirror_src_entity_result_id is null or
10208: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10209: -- and trt.where_clause = 'BEN_ELIG_TO_PRTE_RSN_F'
10210: and cpe.table_alias = c_table_alias
10211: and information1 = c_elig_to_prte_rsn_id
10212: -- and information4 = peo.business_group_id
10213: and information2 = peo.effective_start_date

Line 10218: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

10214: and information3 = peo.effective_end_date
10215: );
10216: l_out_peo_result_id number(15);
10217: ---------------------------------------------------------------
10218: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
10219: ---------------------------------------------------------------
10220: ---------------------------------------------------------------
10221: -- START OF BEN_LER_CHG_OIPL_ENRT_F ----------------------
10222: ---------------------------------------------------------------

Line 10896: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

10892: ---------------------------------------------------------------
10893: -- END OF BEN_DSGN_RQMT_F ----------------------
10894: ---------------------------------------------------------------
10895: ---------------------------------------------------------------
10896: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
10897: ---------------------------------------------------------------
10898: --
10899: for l_parent_rec in c_peo1_from_parent(l_OIPL_ID) loop
10900: --

Line 11024: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

11020: end loop;
11021: --
11022: end loop;
11023: ---------------------------------------------------------------
11024: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
11025: ---------------------------------------------------------------
11026: ---------------------------------------------------------------
11027: -- START OF BEN_LER_CHG_OIPL_ENRT_F ----------------------
11028: ---------------------------------------------------------------