APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_PSTL_ZIP_RNG_F

Line 16166: -- START OF BEN_PSTL_ZIP_RNG_F ----------------------

16162: l_result_type_cd varchar2(30);
16163: l_information5 ben_copy_entity_results.information5%type;
16164: l_number_of_copies number(15);
16165: ---------------------------------------------------------------
16166: -- START OF BEN_PSTL_ZIP_RNG_F ----------------------
16167: ---------------------------------------------------------------
16168: cursor c_rzr(c_pstl_zip_rng_id number,c_mirror_src_entity_result_id number,
16169: c_table_alias varchar2 ) is
16170: select rzr.*

Line 16171: from BEN_PSTL_ZIP_RNG_F rzr

16167: ---------------------------------------------------------------
16168: cursor c_rzr(c_pstl_zip_rng_id number,c_mirror_src_entity_result_id number,
16169: c_table_alias varchar2 ) is
16170: select rzr.*
16171: from BEN_PSTL_ZIP_RNG_F rzr
16172: where rzr.pstl_zip_rng_id = c_pstl_zip_rng_id
16173: --and rzr.business_group_id = p_business_group_id
16174: and not exists (
16175: select /* */ null

Line 16182: -- and trt.where_clause = 'BEN_PSTL_ZIP_RNG_F'

16178: where copy_entity_txn_id = p_copy_entity_txn_id
16179: -- and trt.table_route_id = cpe.table_route_id
16180: and ( -- c_mirror_src_entity_result_id is null or
16181: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
16182: -- and trt.where_clause = 'BEN_PSTL_ZIP_RNG_F'
16183: and cpe.table_alias = c_table_alias
16184: and information1 = c_pstl_zip_rng_id
16185: -- and information4 = rzr.business_group_id
16186: and information2 = rzr.effective_start_date

Line 16191: -- END OF BEN_PSTL_ZIP_RNG_F ----------------------

16187: and information3 = rzr.effective_end_date);
16188: l_pstl_zip_rng_id number(15);
16189: l_out_rzr_result_id number(15);
16190: ---------------------------------------------------------------
16191: -- END OF BEN_PSTL_ZIP_RNG_F ----------------------
16192: ---------------------------------------------------------------
16193: cursor c_object_exists(c_pk_id number,
16194: c_table_alias varchar2) is
16195: select null

Line 16219: -- START OF BEN_PSTL_ZIP_RNG_F ----------------------

16215: end if;
16216:
16217: l_number_of_copies := p_number_of_copies ;
16218: ---------------------------------------------------------------
16219: -- START OF BEN_PSTL_ZIP_RNG_F ----------------------
16220: ---------------------------------------------------------------
16221: -- bug 4241267 - moved code outside of loop
16222: l_table_route_id := null ;
16223: open ben_plan_design_program_module.g_table_route('RZR');

Line 16311: -- END OF BEN_PSTL_ZIP_RNG_F ----------------------

16307: --
16308: end loop;
16309: --
16310: ---------------------------------------------------------------
16311: -- END OF BEN_PSTL_ZIP_RNG_F ----------------------
16312: ---------------------------------------------------------------
16313: end create_postal_results ;
16314: --
16315: procedure create_bnft_bal_results