APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_PSTL_CD_R_RNG_PRTE_F

Line 17516: from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F EPZ

17512: c_business_group_id number,
17513: c_new_pk_id number) is
17514: select
17515: EPZ.elig_pstl_cd_r_rng_prte_id new_value
17516: from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F EPZ
17517: where
17518: EPZ.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
17519: EPZ.PSTL_ZIP_RNG_ID = l_PSTL_ZIP_RNG_ID and
17520: EPZ.business_group_id = c_business_group_id

Line 17527: from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F EPZ1

17523: and effective_end_date ;
17524: --END TEMPIK
17525: /*TEMPIK
17526: and exists ( select null
17527: from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F EPZ1
17528: where
17529: EPZ1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
17530: EPZ1.PSTL_ZIP_RNG_ID = l_PSTL_ZIP_RNG_ID and
17531: EPZ1.business_group_id = c_business_group_id

Line 17534: from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F EPZ2

17530: EPZ1.PSTL_ZIP_RNG_ID = l_PSTL_ZIP_RNG_ID and
17531: EPZ1.business_group_id = c_business_group_id
17532: and EPZ1.effective_start_date <= c_effective_start_date )
17533: and exists ( select null
17534: from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F EPZ2
17535: where
17536: EPZ2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
17537: EPZ2.PSTL_ZIP_RNG_ID = l_PSTL_ZIP_RNG_ID and
17538: EPZ2.business_group_id = c_business_group_id

Line 17690: (p_base_table_name => 'BEN_ELIG_PSTL_CD_R_RNG_PRTE_F',

17686: if c_find_EPZ_in_target%found then
17687: --
17688: --TEMPIK
17689: l_dt_rec_found := dt_api.check_min_max_dates
17690: (p_base_table_name => 'BEN_ELIG_PSTL_CD_R_RNG_PRTE_F',
17691: p_base_key_column => 'ELIG_PSTL_CD_R_RNG_PRTE_ID',
17692: p_base_key_value => l_new_value,
17693: p_from_date => l_min_esd,
17694: p_to_date => l_max_eed );

Line 17750: hr_utility.set_location(' BEN_ELIG_PSTL_CD_R_RNG_PRTE_F CREATE_ELIG_PSTL_CD_RNG_PRTE ',20);

17746: end if;
17747:
17748: if l_first_rec and not l_update then
17749: -- Call Create routine.
17750: hr_utility.set_location(' BEN_ELIG_PSTL_CD_R_RNG_PRTE_F CREATE_ELIG_PSTL_CD_RNG_PRTE ',20);
17751: BEN_ELIG_PSTL_CD_RNG_PRTE_API.CREATE_ELIG_PSTL_CD_RNG_PRTE(
17752: --
17753: P_VALIDATE => false
17754: ,P_EFFECTIVE_DATE => l_effective_date

Line 17819: hr_utility.set_location(' BEN_ELIG_PSTL_CD_R_RNG_PRTE_F UPDATE_ELIG_PSTL_CD_RNG_PRTE ',30);

17815: else
17816: --
17817: -- Call Update routine for the pk_id created in prev run .
17818: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
17819: hr_utility.set_location(' BEN_ELIG_PSTL_CD_R_RNG_PRTE_F UPDATE_ELIG_PSTL_CD_RNG_PRTE ',30);
17820: --UPD START
17821: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
17822: --
17823: if l_update then