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_PD_RATE_AND_CVG_MODULE dependencies on BEN_VRBL_RT_ELIG_PRFL_F

Line 5445: -- START OF BEN_VRBL_RT_ELIG_PRFL_F ----------------------

5441: l_proc varchar2(72) := g_package||'create_vrb_rt_elg_prf_results';
5442: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
5443: --
5444: ---------------------------------------------------------------
5445: -- START OF BEN_VRBL_RT_ELIG_PRFL_F ----------------------
5446: ---------------------------------------------------------------
5447: cursor c_vep_from_parent(c_VRBL_RT_PRFL_ID number) is
5448: select distinct vrbl_rt_elig_prfl_id
5449: from BEN_VRBL_RT_ELIG_PRFL_F

Line 5449: from BEN_VRBL_RT_ELIG_PRFL_F

5445: -- START OF BEN_VRBL_RT_ELIG_PRFL_F ----------------------
5446: ---------------------------------------------------------------
5447: cursor c_vep_from_parent(c_VRBL_RT_PRFL_ID number) is
5448: select distinct vrbl_rt_elig_prfl_id
5449: from BEN_VRBL_RT_ELIG_PRFL_F
5450: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
5451: --
5452: cursor c_vep(c_vrbl_rt_elig_prfl_id number,c_mirror_src_entity_result_id number,
5453: c_table_alias varchar2 ) is

Line 5455: from BEN_VRBL_RT_ELIG_PRFL_F vep

5451: --
5452: cursor c_vep(c_vrbl_rt_elig_prfl_id number,c_mirror_src_entity_result_id number,
5453: c_table_alias varchar2 ) is
5454: select vep.*
5455: from BEN_VRBL_RT_ELIG_PRFL_F vep
5456: where vep.vrbl_rt_elig_prfl_id = c_vrbl_rt_elig_prfl_id
5457: -- and vep.business_group_id = p_business_group_id
5458: and not exists (
5459: select /* */ null

Line 5466: -- and trt.where_clause = 'BEN_VRBL_RT_ELIG_PRFL_F'

5462: where copy_entity_txn_id = p_copy_entity_txn_id
5463: -- and trt.table_route_id = cpe.table_route_id
5464: and ( -- c_mirror_src_entity_result_id is null or
5465: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5466: -- and trt.where_clause = 'BEN_VRBL_RT_ELIG_PRFL_F'
5467: and cpe.table_alias = c_table_alias
5468: and information1 = c_vrbl_rt_elig_prfl_id
5469: -- and information4 = vep.business_group_id
5470: and information2 = vep.effective_start_date

Line 5490: from BEN_VRBL_RT_ELIG_PRFL_F

5486: l_out_vep_result_id number(15);
5487:
5488: cursor c_elp_from_parent(c_VRBL_RT_ELIG_PRFL_ID number) is
5489: select distinct eligy_prfl_id
5490: from BEN_VRBL_RT_ELIG_PRFL_F
5491: where VRBL_RT_ELIG_PRFL_ID = c_VRBL_RT_ELIG_PRFL_ID;
5492:
5493: ---------------------------------------------------------------
5494: -- END OF BEN_VRBL_RT_ELIG_PRFL_F ----------------------

Line 5494: -- END OF BEN_VRBL_RT_ELIG_PRFL_F ----------------------

5490: from BEN_VRBL_RT_ELIG_PRFL_F
5491: where VRBL_RT_ELIG_PRFL_ID = c_VRBL_RT_ELIG_PRFL_ID;
5492:
5493: ---------------------------------------------------------------
5494: -- END OF BEN_VRBL_RT_ELIG_PRFL_F ----------------------
5495: ---------------------------------------------------------------
5496:
5497: l_mirror_src_entity_result_id number(15);
5498: l_table_route_id number(15);

Line 5503: l_mndtry_flag ben_vrbl_rt_elig_prfl_f.mndtry_flag%type;

5499: l_result_type_cd varchar2(30);
5500: l_information5 ben_copy_entity_results.information5%type;
5501: l_number_of_copies number(15);
5502:
5503: l_mndtry_flag ben_vrbl_rt_elig_prfl_f.mndtry_flag%type;
5504:
5505: --ENH Avoid duplicate ELPRO's
5506: l_mirror_g_pdw_allow_dup_rslt varchar2(30);
5507:

Line 5527: -- START OF BEN_VRBL_RT_ELIG_PRFL_F ----------------------

5523:
5524: end if;
5525: --End Bug 5059695
5526: ---------------------------------------------------------------
5527: -- START OF BEN_VRBL_RT_ELIG_PRFL_F ----------------------
5528: ---------------------------------------------------------------
5529: --
5530: for l_parent_rec in c_vep_from_parent(p_VRBL_RT_PRFL_ID) loop
5531: --

Line 5659: -- END OF BEN_VRBL_RT_ELIG_PRFL_F ----------------------

5655: --reset the global allow dup results
5656:
5657: end loop;
5658: ---------------------------------------------------------------
5659: -- END OF BEN_VRBL_RT_ELIG_PRFL_F ----------------------
5660: ---------------------------------------------------------------
5661:
5662: end ;
5663: