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_ACTL_PREM_VRBL_RT_F

Line 3220: -- START OF BEN_ACTL_PREM_VRBL_RT_F ----------------------

3216: ---------------------------------------------------------------
3217: -- END OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
3218: ---------------------------------------------------------------
3219: ---------------------------------------------------------------
3220: -- START OF BEN_ACTL_PREM_VRBL_RT_F ----------------------
3221: ---------------------------------------------------------------
3222: cursor c_apv_from_parent(c_ACTL_PREM_ID number) is
3223: select distinct actl_prem_vrbl_rt_id
3224: from BEN_ACTL_PREM_VRBL_RT_F

Line 3224: from BEN_ACTL_PREM_VRBL_RT_F

3220: -- START OF BEN_ACTL_PREM_VRBL_RT_F ----------------------
3221: ---------------------------------------------------------------
3222: cursor c_apv_from_parent(c_ACTL_PREM_ID number) is
3223: select distinct actl_prem_vrbl_rt_id
3224: from BEN_ACTL_PREM_VRBL_RT_F
3225: where ACTL_PREM_ID = c_ACTL_PREM_ID ;
3226: --
3227: cursor c_apv(c_actl_prem_vrbl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
3228: select apv.*

Line 3229: from BEN_ACTL_PREM_VRBL_RT_F apv

3225: where ACTL_PREM_ID = c_ACTL_PREM_ID ;
3226: --
3227: cursor c_apv(c_actl_prem_vrbl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
3228: select apv.*
3229: from BEN_ACTL_PREM_VRBL_RT_F apv
3230: where apv.actl_prem_vrbl_rt_id = c_actl_prem_vrbl_rt_id
3231: -- and apv.business_group_id = p_business_group_id
3232: and not exists (
3233: select /* */ null

Line 3240: -- and trt.where_clause = 'BEN_ACTL_PREM_VRBL_RT_F'

3236: where copy_entity_txn_id = p_copy_entity_txn_id
3237: -- and trt.table_route_id = cpe.table_route_id
3238: and ( -- c_mirror_src_entity_result_id is null or
3239: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3240: -- and trt.where_clause = 'BEN_ACTL_PREM_VRBL_RT_F'
3241: and cpe.table_alias = c_table_alias
3242: and information1 = c_actl_prem_vrbl_rt_id
3243: -- and information4 = apv.business_group_id
3244: and information2 = apv.effective_start_date

Line 3254: -- and trt.where_clause = 'BEN_ACTL_PREM_VRBL_RT_F'

3250: -- pqh_table_route trt
3251: where copy_entity_txn_id = p_copy_entity_txn_id
3252: -- and trt.table_route_id = cpe.table_route_id
3253: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
3254: -- and trt.where_clause = 'BEN_ACTL_PREM_VRBL_RT_F'
3255: and cpe.table_alias = c_table_alias
3256: and information1 = c_actl_prem_vrbl_rt_id
3257: -- and information4 = p_business_group_id
3258: ;

Line 3264: -- END OF BEN_ACTL_PREM_VRBL_RT_F ----------------------

3260:
3261: l_actl_prem_vrbl_rt_id number(15);
3262: l_out_apv_result_id number(15);
3263: ---------------------------------------------------------------
3264: -- END OF BEN_ACTL_PREM_VRBL_RT_F ----------------------
3265: ---------------------------------------------------------------
3266: ---------------------------------------------------------------
3267: -- START OF BEN_ACTL_PREM_VRBL_RT_RL_F ----------------------
3268: ---------------------------------------------------------------

Line 3741: -- START OF BEN_ACTL_PREM_VRBL_RT_F ----------------------

3737: ---------------------------------------------------------------
3738: -- END OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
3739: ---------------------------------------------------------------
3740: ---------------------------------------------------------------
3741: -- START OF BEN_ACTL_PREM_VRBL_RT_F ----------------------
3742: ---------------------------------------------------------------
3743: --
3744: for l_parent_rec in c_apv_from_parent(l_ACTL_PREM_ID) loop
3745: --

Line 3775: p_parent_entity_result_id => null, -- Hide BEN_ACTL_PREM_VRBL_RT_F for HGrid

3771: p_copy_entity_result_id => l_copy_entity_result_id,
3772: p_copy_entity_txn_id => p_copy_entity_txn_id,
3773: p_result_type_cd => l_result_type_cd,
3774: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
3775: p_parent_entity_result_id => null, -- Hide BEN_ACTL_PREM_VRBL_RT_F for HGrid
3776: p_number_of_copies => l_number_of_copies,
3777: p_table_route_id => l_table_route_id,
3778: P_TABLE_ALIAS => 'APV',
3779: p_information1 => l_apv_rec.actl_prem_vrbl_rt_id,

Line 3857: -- END OF BEN_ACTL_PREM_VRBL_RT_F ----------------------

3853: end loop;
3854: --
3855: end loop;
3856: ---------------------------------------------------------------
3857: -- END OF BEN_ACTL_PREM_VRBL_RT_F ----------------------
3858: ---------------------------------------------------------------
3859: ---------------------------------------------------------------
3860: -- START OF BEN_ACTL_PREM_VRBL_RT_RL_F ----------------------
3861: ---------------------------------------------------------------