APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_BNFT_PRVDR_POOL_F

Line 15127: -- START OF BEN_BNFT_PRVDR_POOL_F ----------------------

15123: l_result_type_cd varchar2(30);
15124: l_information5 ben_copy_entity_results.information5%type;
15125: l_number_of_copies number(15);
15126: ---------------------------------------------------------------
15127: -- START OF BEN_BNFT_PRVDR_POOL_F ----------------------
15128: ---------------------------------------------------------------
15129: cursor c_bpp_from_parent( c_pgm_id number,c_ptip_id number,c_plip_id number, c_oiplip_id number,
15130: c_cmbn_plip_id number, c_cmbn_ptip_id number,
15131: c_cmbn_ptip_opt_id number ) is

Line 15133: from BEN_BNFT_PRVDR_POOL_F

15129: cursor c_bpp_from_parent( c_pgm_id number,c_ptip_id number,c_plip_id number, c_oiplip_id number,
15130: c_cmbn_plip_id number, c_cmbn_ptip_id number,
15131: c_cmbn_ptip_opt_id number ) is
15132: select bnft_prvdr_pool_id
15133: from BEN_BNFT_PRVDR_POOL_F
15134: where (c_pgm_id is not null and c_pgm_id = pgm_id
15135: and ptip_id is null and plip_id is null
15136: and oiplip_id is null and cmbn_plip_id is null
15137: and cmbn_ptip_id is null and cmbn_ptip_opt_id is null

Line 15148: from BEN_BNFT_PRVDR_POOL_F bpp

15144: (c_cmbn_ptip_opt_id is not null and c_cmbn_ptip_opt_id = cmbn_ptip_opt_id ) ;
15145: --
15146: cursor c_bpp(c_bnft_prvdr_pool_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
15147: select bpp.*
15148: from BEN_BNFT_PRVDR_POOL_F bpp
15149: where bpp.bnft_prvdr_pool_id = c_bnft_prvdr_pool_id
15150: --and bpp.business_group_id = p_business_group_id
15151: and not exists (
15152: select /* */ null

Line 15159: -- and trt.where_clause = 'BEN_BNFT_PRVDR_POOL_F'

15155: where copy_entity_txn_id = p_copy_entity_txn_id
15156: -- and trt.table_route_id = cpe.table_route_id
15157: and ( -- c_mirror_src_entity_result_id is null or
15158: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
15159: -- and trt.where_clause = 'BEN_BNFT_PRVDR_POOL_F'
15160: and cpe.table_alias = c_table_alias
15161: and information1 = c_bnft_prvdr_pool_id
15162: -- and information4 = bpp.business_group_id
15163: and information2 = bpp.effective_start_date

Line 15168: -- END OF BEN_BNFT_PRVDR_POOL_F ----------------------

15164: and information3 = bpp.effective_end_date);
15165: l_bnft_prvdr_pool_id number(15);
15166: l_out_bpp_result_id number(15);
15167: ---------------------------------------------------------------
15168: -- END OF BEN_BNFT_PRVDR_POOL_F ----------------------
15169: ---------------------------------------------------------------
15170: ---------------------------------------------------------------
15171: -- START OF BEN_APLCN_TO_BNFT_POOL_F ----------------------
15172: ---------------------------------------------------------------

Line 15238: -- START OF BEN_BNFT_PRVDR_POOL_F ----------------------

15234: begin
15235: l_number_of_copies := p_number_of_copies ;
15236: --
15237: ---------------------------------------------------------------
15238: -- START OF BEN_BNFT_PRVDR_POOL_F ----------------------
15239: ---------------------------------------------------------------
15240: --
15241: for l_parent_rec in c_bpp_from_parent(p_pgm_id,p_ptip_id,p_plip_id,
15242: p_oiplip_id,p_cmbn_plip_id,p_cmbn_ptip_id,p_cmbn_ptip_opt_id) loop

Line 15763: -- END OF BEN_BNFT_PRVDR_POOL_F ----------------------

15759: -- END OF BEN_BNFT_POOL_RLOVR_RQMT_F ----------------------
15760: ---------------------------------------------------------------
15761: end loop;
15762: ---------------------------------------------------------------
15763: -- END OF BEN_BNFT_PRVDR_POOL_F ----------------------
15764: ---------------------------------------------------------------
15765: --
15766: end ;
15767: --