APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_ACTL_PREM_VRBL_RT_RL_F

Line 3267: -- START OF BEN_ACTL_PREM_VRBL_RT_RL_F ----------------------

3263: ---------------------------------------------------------------
3264: -- END OF BEN_ACTL_PREM_VRBL_RT_F ----------------------
3265: ---------------------------------------------------------------
3266: ---------------------------------------------------------------
3267: -- START OF BEN_ACTL_PREM_VRBL_RT_RL_F ----------------------
3268: ---------------------------------------------------------------
3269: cursor c_ava_from_parent(c_ACTL_PREM_ID number) is
3270: select actl_prem_vrbl_rt_rl_id
3271: from BEN_ACTL_PREM_VRBL_RT_RL_F

Line 3271: from BEN_ACTL_PREM_VRBL_RT_RL_F

3267: -- START OF BEN_ACTL_PREM_VRBL_RT_RL_F ----------------------
3268: ---------------------------------------------------------------
3269: cursor c_ava_from_parent(c_ACTL_PREM_ID number) is
3270: select actl_prem_vrbl_rt_rl_id
3271: from BEN_ACTL_PREM_VRBL_RT_RL_F
3272: where ACTL_PREM_ID = c_ACTL_PREM_ID ;
3273: --
3274: cursor c_ava(c_actl_prem_vrbl_rt_rl_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
3275: select ava.*

Line 3276: from BEN_ACTL_PREM_VRBL_RT_RL_F ava

3272: where ACTL_PREM_ID = c_ACTL_PREM_ID ;
3273: --
3274: cursor c_ava(c_actl_prem_vrbl_rt_rl_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
3275: select ava.*
3276: from BEN_ACTL_PREM_VRBL_RT_RL_F ava
3277: where ava.actl_prem_vrbl_rt_rl_id = c_actl_prem_vrbl_rt_rl_id
3278: -- and ava.business_group_id = p_business_group_id
3279: and not exists (
3280: select /* */ null

Line 3287: -- and trt.where_clause = 'BEN_ACTL_PREM_VRBL_RT_RL_F'

3283: where copy_entity_txn_id = p_copy_entity_txn_id
3284: -- and trt.table_route_id = cpe.table_route_id
3285: and ( -- c_mirror_src_entity_result_id is null or
3286: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3287: -- and trt.where_clause = 'BEN_ACTL_PREM_VRBL_RT_RL_F'
3288: and cpe.table_alias = c_table_alias
3289: and information1 = c_actl_prem_vrbl_rt_rl_id
3290: -- and information4 = ava.business_group_id
3291: and information2 = ava.effective_start_date

Line 3296: -- END OF BEN_ACTL_PREM_VRBL_RT_RL_F ----------------------

3292: and information3 = ava.effective_end_date);
3293: l_actl_prem_vrbl_rt_rl_id number(15);
3294: l_out_ava_result_id number(15);
3295: ---------------------------------------------------------------
3296: -- END OF BEN_ACTL_PREM_VRBL_RT_RL_F ----------------------
3297: ---------------------------------------------------------------
3298: begin
3299: l_number_of_copies := p_number_of_copies ;
3300: ---------------------------------------------------------------

Line 3860: -- START OF BEN_ACTL_PREM_VRBL_RT_RL_F ----------------------

3856: ---------------------------------------------------------------
3857: -- END OF BEN_ACTL_PREM_VRBL_RT_F ----------------------
3858: ---------------------------------------------------------------
3859: ---------------------------------------------------------------
3860: -- START OF BEN_ACTL_PREM_VRBL_RT_RL_F ----------------------
3861: ---------------------------------------------------------------
3862: --
3863: for l_parent_rec in c_ava_from_parent(l_ACTL_PREM_ID) loop
3864: --

Line 3981: -- END OF BEN_ACTL_PREM_VRBL_RT_RL_F ----------------------

3977: end loop;
3978: --
3979: end loop;
3980: ---------------------------------------------------------------
3981: -- END OF BEN_ACTL_PREM_VRBL_RT_RL_F ----------------------
3982: ---------------------------------------------------------------
3983: end loop;
3984: ---------------------------------------------------------------
3985: -- END OF BEN_ACTL_PREM_F ----------------------