APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 2516: -- START OF BEN_CVG_AMT_CALC_MTHD_F ----------------------

2512: l_result_type_cd varchar2(30);
2513: l_information5 ben_copy_entity_results.information5%type;
2514: l_number_of_copies number(15);
2515: ---------------------------------------------------------------
2516: -- START OF BEN_CVG_AMT_CALC_MTHD_F ----------------------
2517: ---------------------------------------------------------------
2518: cursor c_ccm_from_parent( c_pl_id number,c_plip_id number, c_oipl_id number ) is
2519: select distinct cvg_amt_calc_mthd_id
2520: from BEN_CVG_AMT_CALC_MTHD_F

Line 2520: from BEN_CVG_AMT_CALC_MTHD_F

2516: -- START OF BEN_CVG_AMT_CALC_MTHD_F ----------------------
2517: ---------------------------------------------------------------
2518: cursor c_ccm_from_parent( c_pl_id number,c_plip_id number, c_oipl_id number ) is
2519: select distinct cvg_amt_calc_mthd_id
2520: from BEN_CVG_AMT_CALC_MTHD_F
2521: where (c_pl_id is not null and pl_id = c_pl_id) or
2522: (c_plip_id is not null and c_plip_id = plip_id) or
2523: (c_oipl_id is not null and c_oipl_id = oipl_id) ;
2524: --

Line 2527: from BEN_CVG_AMT_CALC_MTHD_F ccm

2523: (c_oipl_id is not null and c_oipl_id = oipl_id) ;
2524: --
2525: cursor c_ccm(c_cvg_amt_calc_mthd_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
2526: select ccm.*
2527: from BEN_CVG_AMT_CALC_MTHD_F ccm
2528: where ccm.cvg_amt_calc_mthd_id = c_cvg_amt_calc_mthd_id
2529: -- and ccm.business_group_id = p_business_group_id
2530: and not exists (
2531: select /* */ null

Line 2538: -- and trt.where_clause = 'BEN_CVG_AMT_CALC_MTHD_F'

2534: where copy_entity_txn_id = p_copy_entity_txn_id
2535: -- and trt.table_route_id = cpe.table_route_id
2536: and ( -- c_mirror_src_entity_result_id is null or
2537: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2538: -- and trt.where_clause = 'BEN_CVG_AMT_CALC_MTHD_F'
2539: and cpe.table_alias = c_table_alias
2540: and information1 = c_cvg_amt_calc_mthd_id
2541: -- and information4 = ccm.business_group_id
2542: and information2 = ccm.effective_start_date

Line 2547: -- END OF BEN_CVG_AMT_CALC_MTHD_F ----------------------

2543: and information3 = ccm.effective_end_date);
2544: l_cvg_amt_calc_mthd_id number(15);
2545: l_out_ccm_result_id number(15);
2546: ---------------------------------------------------------------
2547: -- END OF BEN_CVG_AMT_CALC_MTHD_F ----------------------
2548: ---------------------------------------------------------------
2549: ---------------------------------------------------------------
2550: -- START OF BEN_BNFT_VRBL_RT_RL_F ----------------------
2551: ---------------------------------------------------------------

Line 2632: -- START OF BEN_CVG_AMT_CALC_MTHD_F ----------------------

2628: ---------------------------------------------------------------
2629: begin
2630: l_number_of_copies := p_number_of_copies ;
2631: ---------------------------------------------------------------
2632: -- START OF BEN_CVG_AMT_CALC_MTHD_F ----------------------
2633: ---------------------------------------------------------------
2634: --
2635: for l_parent_rec in c_ccm_from_parent(p_pl_id,p_plip_id,p_oipl_id) loop
2636: --

Line 3103: -- END OF BEN_CVG_AMT_CALC_MTHD_F ----------------------

3099: -- END OF BEN_BNFT_VRBL_RT_F ----------------------
3100: ---------------------------------------------------------------
3101: end loop;
3102: ---------------------------------------------------------------
3103: -- END OF BEN_CVG_AMT_CALC_MTHD_F ----------------------
3104: ---------------------------------------------------------------
3105: end create_coverage_results ;
3106: --
3107: procedure create_premium_results