APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_SVC_AREA_F

Line 15812: -- START OF BEN_SVC_AREA_F ----------------------

15808: l_result_type_cd varchar2(30);
15809: l_information5 ben_copy_entity_results.information5%type;
15810: l_number_of_copies number(15);
15811: ---------------------------------------------------------------
15812: -- START OF BEN_SVC_AREA_F ----------------------
15813: ---------------------------------------------------------------
15814: cursor c_sva(c_svc_area_id number,c_mirror_src_entity_result_id number,
15815: c_table_alias varchar2 ) is
15816: select sva.*

Line 15817: from BEN_SVC_AREA_F sva

15813: ---------------------------------------------------------------
15814: cursor c_sva(c_svc_area_id number,c_mirror_src_entity_result_id number,
15815: c_table_alias varchar2 ) is
15816: select sva.*
15817: from BEN_SVC_AREA_F sva
15818: where sva.svc_area_id = c_svc_area_id
15819: --and sva.business_group_id = p_business_group_id
15820: and not exists (
15821: select /* */ null

Line 15828: -- and trt.where_clause = 'BEN_SVC_AREA_F'

15824: where copy_entity_txn_id = p_copy_entity_txn_id
15825: -- and trt.table_route_id = cpe.table_route_id
15826: and ( -- c_mirror_src_entity_result_id is null or
15827: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
15828: -- and trt.where_clause = 'BEN_SVC_AREA_F'
15829: and cpe.table_alias = c_table_alias
15830: and information1 = c_svc_area_id
15831: -- and information4 = sva.business_group_id
15832: and information2 = sva.effective_start_date

Line 15837: -- END OF BEN_SVC_AREA_F ----------------------

15833: and information3 = sva.effective_end_date);
15834: l_svc_area_id number(15);
15835: l_out_sva_result_id number(15);
15836: ---------------------------------------------------------------
15837: -- END OF BEN_SVC_AREA_F ----------------------
15838: ---------------------------------------------------------------
15839: ---------------------------------------------------------------
15840: -- START OF BEN_SVC_AREA_PSTL_ZIP_RNG_F ----------------------
15841: ---------------------------------------------------------------

Line 15912: -- START OF BEN_SVC_AREA_F ----------------------

15908: end if;
15909:
15910: l_number_of_copies := p_number_of_copies ;
15911: ---------------------------------------------------------------
15912: -- START OF BEN_SVC_AREA_F ----------------------
15913: ---------------------------------------------------------------
15914: --
15915: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
15916: --

Line 16118: -- END OF BEN_SVC_AREA_F ----------------------

16114: ---------------------------------------------------------------
16115: -- END OF BEN_SVC_AREA_PSTL_ZIP_RNG_F ----------------------
16116: ---------------------------------------------------------------
16117: ---------------------------------------------------------------
16118: -- END OF BEN_SVC_AREA_F ----------------------
16119: ---------------------------------------------------------------
16120: end create_service_results ;
16121: --
16122: procedure create_postal_results