APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_PSTL_ZIP_RT_F

Line 6734: -- START OF BEN_PSTL_ZIP_RT_F ----------------------

6730: ---------------------------------------------------------------
6731: -- END OF BEN_PPL_GRP_RT_F ----------------------
6732: ---------------------------------------------------------------
6733: ---------------------------------------------------------------
6734: -- START OF BEN_PSTL_ZIP_RT_F ----------------------
6735: ---------------------------------------------------------------
6736: cursor c_pzr_from_parent(c_VRBL_RT_PRFL_ID number) is
6737: select distinct pstl_zip_rt_id
6738: from BEN_PSTL_ZIP_RT_F

Line 6738: from BEN_PSTL_ZIP_RT_F

6734: -- START OF BEN_PSTL_ZIP_RT_F ----------------------
6735: ---------------------------------------------------------------
6736: cursor c_pzr_from_parent(c_VRBL_RT_PRFL_ID number) is
6737: select distinct pstl_zip_rt_id
6738: from BEN_PSTL_ZIP_RT_F
6739: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6740: --
6741: cursor c_pzr(c_pstl_zip_rt_id number,c_mirror_src_entity_result_id number,
6742: c_table_alias varchar2 ) is

Line 6744: from BEN_PSTL_ZIP_RT_F pzr

6740: --
6741: cursor c_pzr(c_pstl_zip_rt_id number,c_mirror_src_entity_result_id number,
6742: c_table_alias varchar2 ) is
6743: select pzr.*
6744: from BEN_PSTL_ZIP_RT_F pzr
6745: where pzr.pstl_zip_rt_id = c_pstl_zip_rt_id
6746: -- and pzr.business_group_id = p_business_group_id
6747: and not exists (
6748: select /* */ null

Line 6755: -- and trt.where_clause = 'BEN_PSTL_ZIP_RT_F'

6751: where copy_entity_txn_id = p_copy_entity_txn_id
6752: -- and trt.table_route_id = cpe.table_route_id
6753: and ( -- c_mirror_src_entity_result_id is null or
6754: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6755: -- and trt.where_clause = 'BEN_PSTL_ZIP_RT_F'
6756: and cpe.table_alias = c_table_alias
6757: and information1 = c_pstl_zip_rt_id
6758: -- and information4 = pzr.business_group_id
6759: and information2 = pzr.effective_start_date

Line 6771: -- and trt.where_clause = 'BEN_PSTL_ZIP_RT_F'

6767: -- pqh_table_route trt
6768: where copy_entity_txn_id = p_copy_entity_txn_id
6769: -- and trt.table_route_id = cpe.table_route_id
6770: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
6771: -- and trt.where_clause = 'BEN_PSTL_ZIP_RT_F'
6772: and cpe.table_alias = c_table_alias
6773: and information1 = c_pstl_zip_rt_id
6774: -- and information4 = p_business_group_id
6775: ;

Line 6777: -- END OF BEN_PSTL_ZIP_RT_F ----------------------

6773: and information1 = c_pstl_zip_rt_id
6774: -- and information4 = p_business_group_id
6775: ;
6776: ---------------------------------------------------------------
6777: -- END OF BEN_PSTL_ZIP_RT_F ----------------------
6778: ---------------------------------------------------------------
6779: ---------------------------------------------------------------
6780: -- START OF BEN_PYRL_RT_F ----------------------
6781: ---------------------------------------------------------------

Line 11152: -- START OF BEN_PSTL_ZIP_RT_F ----------------------

11148: ---------------------------------------------------------------
11149: -- END OF BEN_PPL_GRP_RT_F ----------------------
11150: ---------------------------------------------------------------
11151: ---------------------------------------------------------------
11152: -- START OF BEN_PSTL_ZIP_RT_F ----------------------
11153: ---------------------------------------------------------------
11154: --
11155: for l_parent_rec in c_pzr_from_parent(l_VRBL_RT_PRFL_ID) loop
11156: --

Line 11266: -- END OF BEN_PSTL_ZIP_RT_F ----------------------

11262: ) ;
11263: end loop;
11264: end loop;
11265: ---------------------------------------------------------------
11266: -- END OF BEN_PSTL_ZIP_RT_F ----------------------
11267: ---------------------------------------------------------------
11268: ---------------------------------------------------------------
11269: -- START OF BEN_PYRL_RT_F ----------------------
11270: ---------------------------------------------------------------