APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_ACTL_PREM_F

Line 249: -- START OF BEN_ACTL_PREM_F ----------------------

245: ---------------------------------------------------------------
246: -- END OF BEN_PYMT_SCHED_PY_FREQ ----------------------
247: ---------------------------------------------------------------
248: ---------------------------------------------------------------
249: -- START OF BEN_ACTL_PREM_F ----------------------
250: ---------------------------------------------------------------
251: cursor c_apr_from_parent(c_ACTY_BASE_RT_ID number) is
252: select distinct actl_prem_id
253: from BEN_ACTY_BASE_RT_F

Line 259: from BEN_ACTL_PREM_F apr

255: --
256: cursor c_apr(c_actl_prem_id number,c_mirror_src_entity_result_id number,
257: c_table_alias varchar2 ) is
258: select apr.*
259: from BEN_ACTL_PREM_F apr
260: where apr.actl_prem_id = c_actl_prem_id
261: -- and apr.business_group_id = p_business_group_id
262: and not exists (
263: select /* */ null

Line 270: -- and trt.where_clause = 'BEN_ACTL_PREM_F'

266: where copy_entity_txn_id = p_copy_entity_txn_id
267: -- and trt.table_route_id = cpe.table_route_id
268: and ( -- c_mirror_src_entity_result_id is null or
269: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
270: -- and trt.where_clause = 'BEN_ACTL_PREM_F'
271: and cpe.table_alias = c_table_alias
272: and information1 = c_actl_prem_id
273: -- and information4 = apr.business_group_id
274: and information2 = apr.effective_start_date

Line 279: -- END OF BEN_ACTL_PREM_F ----------------------

275: and information3 = apr.effective_end_date);
276: l_actl_prem_id number(15);
277: l_out_apr_result_id number(15);
278: ---------------------------------------------------------------
279: -- END OF BEN_ACTL_PREM_F ----------------------
280: ---------------------------------------------------------------
281: ---------------------------------------------------------------
282: -- START OF BEN_ACTY_RT_PTD_LMT_F ----------------------
283: ---------------------------------------------------------------

Line 1519: -- START OF BEN_ACTL_PREM_F ----------------------

1515: ---------------------------------------------------------------
1516: -- END OF BEN_PYMT_SCHED_PY_FREQ ----------------------
1517: ---------------------------------------------------------------
1518: ---------------------------------------------------------------
1519: -- START OF BEN_ACTL_PREM_F ----------------------
1520: ---------------------------------------------------------------
1521: --
1522: /*
1523: ** NOT REQUIRED here as Premium Data will get copied with the Plan

Line 3153: -- START OF BEN_ACTL_PREM_F ----------------------

3149: l_result_type_cd varchar2(30);
3150: l_information5 ben_copy_entity_results.information5%type;
3151: l_number_of_copies number(15);
3152: ---------------------------------------------------------------
3153: -- START OF BEN_ACTL_PREM_F ----------------------
3154: ---------------------------------------------------------------
3155: cursor c_apr_from_parent(c_pl_id number,c_oipl_id number) is
3156: select distinct actl_prem_id
3157: from BEN_ACTL_PREM_F

Line 3157: from BEN_ACTL_PREM_F

3153: -- START OF BEN_ACTL_PREM_F ----------------------
3154: ---------------------------------------------------------------
3155: cursor c_apr_from_parent(c_pl_id number,c_oipl_id number) is
3156: select distinct actl_prem_id
3157: from BEN_ACTL_PREM_F
3158: where (c_pl_id is not null and pl_id = c_pl_id ) or
3159: (c_oipl_id is not null and oipl_id = c_oipl_id) ;
3160: --
3161: cursor c_apr(c_actl_prem_id number,c_mirror_src_entity_result_id number,

Line 3164: from BEN_ACTL_PREM_F apr

3160: --
3161: cursor c_apr(c_actl_prem_id number,c_mirror_src_entity_result_id number,
3162: c_table_alias varchar2 ) is
3163: select apr.*
3164: from BEN_ACTL_PREM_F apr
3165: where apr.actl_prem_id = c_actl_prem_id
3166: -- and apr.business_group_id = p_business_group_id
3167: and not exists (
3168: select /* */ null

Line 3175: -- and trt.where_clause = 'BEN_ACTL_PREM_F'

3171: where copy_entity_txn_id = p_copy_entity_txn_id
3172: -- and trt.table_route_id = cpe.table_route_id
3173: and ( -- c_mirror_src_entity_result_id is null or
3174: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3175: -- and trt.where_clause = 'BEN_ACTL_PREM_F'
3176: and cpe.table_alias = c_table_alias
3177: and information1 = c_actl_prem_id
3178: -- and information4 = apr.business_group_id
3179: and information2 = apr.effective_start_date

Line 3185: -- END OF BEN_ACTL_PREM_F ----------------------

3181: --
3182: l_actl_prem_id number(15);
3183: l_out_apr_result_id number(15);
3184: ---------------------------------------------------------------
3185: -- END OF BEN_ACTL_PREM_F ----------------------
3186: ---------------------------------------------------------------
3187: ---------------------------------------------------------------
3188: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
3189: ---------------------------------------------------------------

Line 3301: -- START OF BEN_ACTL_PREM_F ----------------------

3297: ---------------------------------------------------------------
3298: begin
3299: l_number_of_copies := p_number_of_copies ;
3300: ---------------------------------------------------------------
3301: -- START OF BEN_ACTL_PREM_F ----------------------
3302: ---------------------------------------------------------------
3303: --
3304: for l_parent_rec in c_apr_from_parent(p_pl_id,p_oipl_id) loop
3305: --

Line 3985: -- END OF BEN_ACTL_PREM_F ----------------------

3981: -- END OF BEN_ACTL_PREM_VRBL_RT_RL_F ----------------------
3982: ---------------------------------------------------------------
3983: end loop;
3984: ---------------------------------------------------------------
3985: -- END OF BEN_ACTL_PREM_F ----------------------
3986: ---------------------------------------------------------------
3987: null;
3988: end create_premium_results ;
3989: --