APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_PSTL_ZIP_RT_F

Line 5001: -- and tr.where_clause = l_BEN_PSTL_ZIP_RT_F

4997: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4998: pqh_table_route tr
4999: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5000: and cpe.table_route_id = tr.table_route_id
5001: -- and tr.where_clause = l_BEN_PSTL_ZIP_RT_F
5002: and tr.table_alias = l_table_alias
5003: and cpe.number_of_copies = 1 -- ADDITION
5004: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
5005: order by information1, information2; --added for bug: 5151945

Line 5039: from BEN_PSTL_ZIP_RT_F PZR

5035: c_business_group_id number,
5036: c_new_pk_id number) is
5037: select
5038: PZR.pstl_zip_rt_id new_value
5039: from BEN_PSTL_ZIP_RT_F PZR
5040: where
5041: PZR.PSTL_ZIP_RNG_ID = l_PSTL_ZIP_RNG_ID and
5042: PZR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
5043: PZR.ORDR_NUM = l_ORDR_NUM and

Line 5052: from BEN_PSTL_ZIP_RT_F PZR1

5048: and effective_end_date ;
5049: --END TEMPIK
5050: /*TEMPIK
5051: and exists ( select null
5052: from BEN_PSTL_ZIP_RT_F PZR1
5053: where
5054: PZR1.PSTL_ZIP_RNG_ID = l_PSTL_ZIP_RNG_ID and
5055: PZR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
5056: PZR1.ORDR_NUM = l_ORDR_NUM and

Line 5060: from BEN_PSTL_ZIP_RT_F PZR2

5056: PZR1.ORDR_NUM = l_ORDR_NUM and
5057: PZR1.business_group_id = c_business_group_id
5058: and PZR1.effective_start_date <= c_effective_start_date )
5059: and exists ( select null
5060: from BEN_PSTL_ZIP_RT_F PZR2
5061: where
5062: PZR2.PSTL_ZIP_RNG_ID = l_PSTL_ZIP_RNG_ID and
5063: PZR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
5064: PZR2.ORDR_NUM = l_ORDR_NUM and

Line 5199: (p_base_table_name => 'BEN_PSTL_ZIP_RT_F',

5195: if c_find_PZR_in_target%found then
5196: --
5197: --TEMPIK
5198: l_dt_rec_found := dt_api.check_min_max_dates
5199: (p_base_table_name => 'BEN_PSTL_ZIP_RT_F',
5200: p_base_key_column => 'PSTL_ZIP_RT_ID',
5201: p_base_key_value => l_new_value,
5202: p_from_date => l_min_esd,
5203: p_to_date => l_max_eed );

Line 5257: hr_utility.set_location(' BEN_PSTL_ZIP_RT_F CREATE_POSTAL_ZIP_RATE ',20);

5253: end if;
5254:
5255: if l_first_rec and not l_update then
5256: -- Call Create routine.
5257: hr_utility.set_location(' BEN_PSTL_ZIP_RT_F CREATE_POSTAL_ZIP_RATE ',20);
5258: BEN_POSTAL_ZIP_RATE_API.CREATE_POSTAL_ZIP_RATE(
5259: --
5260: P_VALIDATE => false
5261: ,P_EFFECTIVE_DATE => l_effective_date

Line 5349: hr_utility.set_location(' BEN_PSTL_ZIP_RT_F UPDATE_POSTAL_ZIP_RATE ',30);

5345: --
5346: IF l_update OR l_dml_operation <> 'UPDATE' THEN
5347: --UPD END
5348: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
5349: hr_utility.set_location(' BEN_PSTL_ZIP_RT_F UPDATE_POSTAL_ZIP_RATE ',30);
5350: BEN_POSTAL_ZIP_RATE_API.UPDATE_POSTAL_ZIP_RATE(
5351: --
5352: P_VALIDATE => false
5353: ,P_EFFECTIVE_DATE => l_effective_date