eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_SVC_AREA_PSTL_ZIP_RNG_F

Line 15840: -- START OF BEN_SVC_AREA_PSTL_ZIP_RNG_F ----------------------

15836: ---------------------------------------------------------------
15837: -- END OF BEN_SVC_AREA_F ----------------------
15838: ---------------------------------------------------------------
15839: ---------------------------------------------------------------
15840: -- START OF BEN_SVC_AREA_PSTL_ZIP_RNG_F ----------------------
15841: ---------------------------------------------------------------
15842: cursor c_saz_from_parent(c_SVC_AREA_ID number) is
15843: select distinct svc_area_pstl_zip_rng_id
15844: from BEN_SVC_AREA_PSTL_ZIP_RNG_F

Line 15844: from BEN_SVC_AREA_PSTL_ZIP_RNG_F

15840: -- START OF BEN_SVC_AREA_PSTL_ZIP_RNG_F ----------------------
15841: ---------------------------------------------------------------
15842: cursor c_saz_from_parent(c_SVC_AREA_ID number) is
15843: select distinct svc_area_pstl_zip_rng_id
15844: from BEN_SVC_AREA_PSTL_ZIP_RNG_F
15845: where SVC_AREA_ID = c_SVC_AREA_ID ;
15846: --
15847: cursor c_saz(c_svc_area_pstl_zip_rng_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
15848: select saz.*

Line 15849: from BEN_SVC_AREA_PSTL_ZIP_RNG_F saz

15845: where SVC_AREA_ID = c_SVC_AREA_ID ;
15846: --
15847: cursor c_saz(c_svc_area_pstl_zip_rng_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
15848: select saz.*
15849: from BEN_SVC_AREA_PSTL_ZIP_RNG_F saz
15850: where saz.svc_area_pstl_zip_rng_id = c_svc_area_pstl_zip_rng_id
15851: --and saz.business_group_id = p_business_group_id
15852: and not exists (
15853: select /* */ null

Line 15860: -- and trt.where_clause = 'BEN_SVC_AREA_PSTL_ZIP_RNG_F'

15856: where copy_entity_txn_id = p_copy_entity_txn_id
15857: -- and trt.table_route_id = cpe.table_route_id
15858: and ( -- c_mirror_src_entity_result_id is null or
15859: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
15860: -- and trt.where_clause = 'BEN_SVC_AREA_PSTL_ZIP_RNG_F'
15861: and cpe.table_alias = c_table_alias
15862: and information1 = c_svc_area_pstl_zip_rng_id
15863: -- and information4 = saz.business_group_id
15864: and information2 = saz.effective_start_date

Line 15876: -- and trt.where_clause = 'BEN_SVC_AREA_PSTL_ZIP_RNG_F'

15872: -- pqh_table_route trt
15873: where copy_entity_txn_id = p_copy_entity_txn_id
15874: -- and trt.table_route_id = cpe.table_route_id
15875: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
15876: -- and trt.where_clause = 'BEN_SVC_AREA_PSTL_ZIP_RNG_F'
15877: and cpe.table_alias = c_table_alias
15878: and information1 = c_svc_area_pstl_zip_rng_id
15879: -- and information4 = p_business_group_id
15880: ;

Line 15883: -- END OF BEN_SVC_AREA_PSTL_ZIP_RNG_F ----------------------

15879: -- and information4 = p_business_group_id
15880: ;
15881:
15882: ---------------------------------------------------------------
15883: -- END OF BEN_SVC_AREA_PSTL_ZIP_RNG_F ----------------------
15884: ---------------------------------------------------------------
15885:
15886: cursor c_object_exists(c_pk_id number,
15887: c_table_alias varchar2) is

Line 16004: -- START OF BEN_SVC_AREA_PSTL_ZIP_RNG_F ----------------------

16000: --
16001: end loop;
16002: --
16003: ---------------------------------------------------------------
16004: -- START OF BEN_SVC_AREA_PSTL_ZIP_RNG_F ----------------------
16005: ---------------------------------------------------------------
16006: -- Bug - 4241267 - moved code outside of loop
16007: l_table_route_id := null ;
16008: open ben_plan_design_program_module.g_table_route('SAZ');

Line 16115: -- END OF BEN_SVC_AREA_PSTL_ZIP_RNG_F ----------------------

16111: ) ;
16112: end loop;
16113: end loop;
16114: ---------------------------------------------------------------
16115: -- END OF BEN_SVC_AREA_PSTL_ZIP_RNG_F ----------------------
16116: ---------------------------------------------------------------
16117: ---------------------------------------------------------------
16118: -- END OF BEN_SVC_AREA_F ----------------------
16119: ---------------------------------------------------------------