APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_BNFT_POOL_RLOVR_RQMT_F

Line 15203: -- START OF BEN_BNFT_POOL_RLOVR_RQMT_F ----------------------

15199: ---------------------------------------------------------------
15200: -- END OF BEN_APLCN_TO_BNFT_POOL_F ----------------------
15201: ---------------------------------------------------------------
15202: ---------------------------------------------------------------
15203: -- START OF BEN_BNFT_POOL_RLOVR_RQMT_F ----------------------
15204: ---------------------------------------------------------------
15205: cursor c_bpr_from_parent(c_BNFT_PRVDR_POOL_ID number) is
15206: select bnft_pool_rlovr_rqmt_id
15207: from BEN_BNFT_POOL_RLOVR_RQMT_F

Line 15207: from BEN_BNFT_POOL_RLOVR_RQMT_F

15203: -- START OF BEN_BNFT_POOL_RLOVR_RQMT_F ----------------------
15204: ---------------------------------------------------------------
15205: cursor c_bpr_from_parent(c_BNFT_PRVDR_POOL_ID number) is
15206: select bnft_pool_rlovr_rqmt_id
15207: from BEN_BNFT_POOL_RLOVR_RQMT_F
15208: where BNFT_PRVDR_POOL_ID = c_BNFT_PRVDR_POOL_ID ;
15209: --
15210: cursor c_bpr(c_bnft_pool_rlovr_rqmt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
15211: select bpr.*

Line 15212: from BEN_BNFT_POOL_RLOVR_RQMT_F bpr

15208: where BNFT_PRVDR_POOL_ID = c_BNFT_PRVDR_POOL_ID ;
15209: --
15210: cursor c_bpr(c_bnft_pool_rlovr_rqmt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
15211: select bpr.*
15212: from BEN_BNFT_POOL_RLOVR_RQMT_F bpr
15213: where bpr.bnft_pool_rlovr_rqmt_id = c_bnft_pool_rlovr_rqmt_id
15214: --and bpr.business_group_id = p_business_group_id
15215: and not exists (
15216: select /* */ null

Line 15223: -- and trt.where_clause = 'BEN_BNFT_POOL_RLOVR_RQMT_F'

15219: where copy_entity_txn_id = p_copy_entity_txn_id
15220: -- and trt.table_route_id = cpe.table_route_id
15221: and ( -- c_mirror_src_entity_result_id is null or
15222: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
15223: -- and trt.where_clause = 'BEN_BNFT_POOL_RLOVR_RQMT_F'
15224: and cpe.table_alias = c_table_alias
15225: and information1 = c_bnft_pool_rlovr_rqmt_id
15226: -- and information4 = bpr.business_group_id
15227: and information2 = bpr.effective_start_date

Line 15232: -- END OF BEN_BNFT_POOL_RLOVR_RQMT_F ----------------------

15228: and information3 = bpr.effective_end_date);
15229: l_bnft_pool_rlovr_rqmt_id number(15);
15230: l_out_bpr_result_id number(15);
15231: ---------------------------------------------------------------
15232: -- END OF BEN_BNFT_POOL_RLOVR_RQMT_F ----------------------
15233: ---------------------------------------------------------------
15234: begin
15235: l_number_of_copies := p_number_of_copies ;
15236: --

Line 15553: -- START OF BEN_BNFT_POOL_RLOVR_RQMT_F ----------------------

15549: ---------------------------------------------------------------
15550: -- END OF BEN_APLCN_TO_BNFT_POOL_F ----------------------
15551: ---------------------------------------------------------------
15552: ---------------------------------------------------------------
15553: -- START OF BEN_BNFT_POOL_RLOVR_RQMT_F ----------------------
15554: ---------------------------------------------------------------
15555: --
15556: for l_parent_rec in c_bpr_from_parent(l_BNFT_PRVDR_POOL_ID) loop
15557: --

Line 15759: -- END OF BEN_BNFT_POOL_RLOVR_RQMT_F ----------------------

15755: --
15756: end loop;
15757:
15758: ---------------------------------------------------------------
15759: -- END OF BEN_BNFT_POOL_RLOVR_RQMT_F ----------------------
15760: ---------------------------------------------------------------
15761: end loop;
15762: ---------------------------------------------------------------
15763: -- END OF BEN_BNFT_PRVDR_POOL_F ----------------------