APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_BNFTS_BAL_F

Line 4051: l_bnb_bnfts_bal_esd ben_bnfts_bal_f.effective_start_date%type;

4047: and cpe.table_alias = c_parent_table_alias;
4048: -- and trt.from_clause = 'OAB'
4049: -- and trt.where_clause = upper(c_parent_table_name);
4050:
4051: l_bnb_bnfts_bal_esd ben_bnfts_bal_f.effective_start_date%type;
4052:
4053: l_mirror_src_entity_result_id number(15);
4054: l_table_route_id number(15);
4055: l_result_type_cd varchar2(30);

Line 16359: -- START OF BEN_BNFTS_BAL_F ----------------------

16355: l_result_type_cd varchar2(30);
16356: l_information5 ben_copy_entity_results.information5%type;
16357: l_number_of_copies number(15);
16358: ---------------------------------------------------------------
16359: -- START OF BEN_BNFTS_BAL_F ----------------------
16360: ---------------------------------------------------------------
16361: cursor c_bnb(c_bnfts_bal_id number,c_mirror_src_entity_result_id number,
16362: c_table_alias varchar2 ) is
16363: select bnb.*

Line 16364: from BEN_BNFTS_BAL_F bnb

16360: ---------------------------------------------------------------
16361: cursor c_bnb(c_bnfts_bal_id number,c_mirror_src_entity_result_id number,
16362: c_table_alias varchar2 ) is
16363: select bnb.*
16364: from BEN_BNFTS_BAL_F bnb
16365: where bnb.bnfts_bal_id = c_bnfts_bal_id
16366: --and bnb.business_group_id = p_business_group_id
16367: and not exists (
16368: select /* */ null

Line 16375: -- and trt.where_clause = 'BEN_BNFTS_BAL_F'

16371: where copy_entity_txn_id = p_copy_entity_txn_id
16372: -- and trt.table_route_id = cpe.table_route_id
16373: and ( -- c_mirror_src_entity_result_id is null or
16374: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
16375: -- and trt.where_clause = 'BEN_BNFTS_BAL_F'
16376: and cpe.table_alias = c_table_alias
16377: and information1 = c_bnfts_bal_id
16378: -- and information4 = bnb.business_group_id
16379: and information2 = bnb.effective_start_date

Line 16384: -- END OF BEN_BNFTS_BAL_F ----------------------

16380: and information3 = bnb.effective_end_date);
16381: l_bnfts_bal_id number(15);
16382: l_out_bnb_result_id number(15);
16383: ---------------------------------------------------------------
16384: -- END OF BEN_BNFTS_BAL_F ----------------------
16385: ---------------------------------------------------------------
16386: cursor c_object_exists(c_pk_id number,
16387: c_table_alias varchar2) is
16388: select null

Line 16412: -- START OF BEN_BNFTS_BAL_F ----------------------

16408: end if;
16409:
16410: l_number_of_copies := p_number_of_copies ;
16411: ---------------------------------------------------------------
16412: -- START OF BEN_BNFTS_BAL_F ----------------------
16413: ---------------------------------------------------------------
16414: --
16415: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
16416: --

Line 16505: -- END OF BEN_BNFTS_BAL_F ----------------------

16501: --
16502: end loop;
16503: --
16504: ---------------------------------------------------------------
16505: -- END OF BEN_BNFTS_BAL_F ----------------------
16506: ---------------------------------------------------------------
16507: end create_bnft_bal_results ;
16508: --
16509: procedure create_bnft_group_results