APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_APLCN_TO_BNFT_POOL_F

Line 15171: -- START OF BEN_APLCN_TO_BNFT_POOL_F ----------------------

15167: ---------------------------------------------------------------
15168: -- END OF BEN_BNFT_PRVDR_POOL_F ----------------------
15169: ---------------------------------------------------------------
15170: ---------------------------------------------------------------
15171: -- START OF BEN_APLCN_TO_BNFT_POOL_F ----------------------
15172: ---------------------------------------------------------------
15173: cursor c_abp_from_parent(c_BNFT_PRVDR_POOL_ID number) is
15174: select aplcn_to_bnft_pool_id
15175: from BEN_APLCN_TO_BNFT_POOL_F

Line 15175: from BEN_APLCN_TO_BNFT_POOL_F

15171: -- START OF BEN_APLCN_TO_BNFT_POOL_F ----------------------
15172: ---------------------------------------------------------------
15173: cursor c_abp_from_parent(c_BNFT_PRVDR_POOL_ID number) is
15174: select aplcn_to_bnft_pool_id
15175: from BEN_APLCN_TO_BNFT_POOL_F
15176: where BNFT_PRVDR_POOL_ID = c_BNFT_PRVDR_POOL_ID ;
15177: --
15178: cursor c_abp(c_aplcn_to_bnft_pool_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
15179: select abp.*

Line 15180: from BEN_APLCN_TO_BNFT_POOL_F abp

15176: where BNFT_PRVDR_POOL_ID = c_BNFT_PRVDR_POOL_ID ;
15177: --
15178: cursor c_abp(c_aplcn_to_bnft_pool_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
15179: select abp.*
15180: from BEN_APLCN_TO_BNFT_POOL_F abp
15181: where abp.aplcn_to_bnft_pool_id = c_aplcn_to_bnft_pool_id
15182: --and abp.business_group_id = p_business_group_id
15183: and not exists (
15184: select /* */ null

Line 15191: -- and trt.where_clause = 'BEN_APLCN_TO_BNFT_POOL_F'

15187: where copy_entity_txn_id = p_copy_entity_txn_id
15188: -- and trt.table_route_id = cpe.table_route_id
15189: and ( -- c_mirror_src_entity_result_id is null or
15190: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
15191: -- and trt.where_clause = 'BEN_APLCN_TO_BNFT_POOL_F'
15192: and cpe.table_alias = c_table_alias
15193: and information1 = c_aplcn_to_bnft_pool_id
15194: -- and information4 = abp.business_group_id
15195: and information2 = abp.effective_start_date

Line 15200: -- END OF BEN_APLCN_TO_BNFT_POOL_F ----------------------

15196: and information3 = abp.effective_end_date);
15197: l_aplcn_to_bnft_pool_id number(15);
15198: l_out_abp_result_id number(15);
15199: ---------------------------------------------------------------
15200: -- END OF BEN_APLCN_TO_BNFT_POOL_F ----------------------
15201: ---------------------------------------------------------------
15202: ---------------------------------------------------------------
15203: -- START OF BEN_BNFT_POOL_RLOVR_RQMT_F ----------------------
15204: ---------------------------------------------------------------

Line 15456: -- START OF BEN_APLCN_TO_BNFT_POOL_F ----------------------

15452: --
15453: end loop;
15454: --
15455: ---------------------------------------------------------------
15456: -- START OF BEN_APLCN_TO_BNFT_POOL_F ----------------------
15457: ---------------------------------------------------------------
15458: --
15459: for l_parent_rec in c_abp_from_parent(l_BNFT_PRVDR_POOL_ID) loop
15460: --

Line 15550: -- END OF BEN_APLCN_TO_BNFT_POOL_F ----------------------

15546: end loop;
15547: --
15548: end loop;
15549: ---------------------------------------------------------------
15550: -- END OF BEN_APLCN_TO_BNFT_POOL_F ----------------------
15551: ---------------------------------------------------------------
15552: ---------------------------------------------------------------
15553: -- START OF BEN_BNFT_POOL_RLOVR_RQMT_F ----------------------
15554: ---------------------------------------------------------------