APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_APLD_DPNT_CVG_ELIG_PRFL_F

Line 19369: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE

19365: c_business_group_id number,
19366: c_new_pk_id number) is
19367: select
19368: ADE.apld_dpnt_cvg_elig_prfl_id new_value
19369: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE
19370: where
19371: ADE.DPNT_CVG_ELIGY_PRFL_ID = l_DPNT_CVG_ELIGY_PRFL_ID and
19372: nvl(ADE.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
19373: nvl(ADE.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 19383: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE1

19379: and effective_end_date ;
19380: --END TEMPIK
19381: /*TEMPIK
19382: and exists ( select null
19383: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE1
19384: where
19385: ADE1.DPNT_CVG_ELIGY_PRFL_ID = l_DPNT_CVG_ELIGY_PRFL_ID and
19386: nvl(ADE1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
19387: nvl(ADE1.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 19392: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE2

19388: nvl(ADE1.PTIP_ID,-999) = nvl(l_PTIP_ID,-999) and
19389: ADE1.business_group_id = c_business_group_id
19390: and ADE1.effective_start_date <= c_effective_start_date )
19391: and exists ( select null
19392: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE2
19393: where
19394: ADE2.DPNT_CVG_ELIGY_PRFL_ID = l_DPNT_CVG_ELIGY_PRFL_ID and
19395: nvl(ADE2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
19396: nvl(ADE2.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 19541: (p_base_table_name => 'BEN_APLD_DPNT_CVG_ELIG_PRFL_F',

19537: if c_find_ADE_in_target%found then
19538: --
19539: --TEMPIK
19540: l_dt_rec_found := dt_api.check_min_max_dates
19541: (p_base_table_name => 'BEN_APLD_DPNT_CVG_ELIG_PRFL_F',
19542: p_base_key_column => 'APLD_DPNT_CVG_ELIG_PRFL_ID',
19543: p_base_key_value => l_new_value,
19544: p_from_date => l_min_esd,
19545: p_to_date => l_max_eed );

Line 19600: hr_utility.set_location(' BEN_APLD_DPNT_CVG_ELIG_PRFL_F CREATE_APLD_DPNT_CVG_PRFL ',20);

19596: end if;
19597:
19598: if l_first_rec and not l_update then
19599: -- Call Create routine.
19600: hr_utility.set_location(' BEN_APLD_DPNT_CVG_ELIG_PRFL_F CREATE_APLD_DPNT_CVG_PRFL ',20);
19601: BEN_APLD_DPNT_CVG_PRFL_API.CREATE_APLD_DPNT_CVG_PRFL(
19602: --
19603: P_VALIDATE => false
19604: ,P_EFFECTIVE_DATE => l_effective_date

Line 19669: hr_utility.set_location(' BEN_APLD_DPNT_CVG_ELIG_PRFL_F UPDATE_APLD_DPNT_CVG_PRFL ',30);

19665: else
19666: --
19667: -- Call Update routine for the pk_id created in prev run .
19668: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
19669: hr_utility.set_location(' BEN_APLD_DPNT_CVG_ELIG_PRFL_F UPDATE_APLD_DPNT_CVG_PRFL ',30);
19670: --UPD START
19671: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
19672: --
19673: if l_update then