APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_APLD_DPNT_CVG_ELIG_PRFL_F

Line 19282: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE

19278: c_business_group_id number,
19279: c_new_pk_id number) is
19280: select
19281: ADE.apld_dpnt_cvg_elig_prfl_id new_value
19282: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE
19283: where
19284: ADE.DPNT_CVG_ELIGY_PRFL_ID = l_DPNT_CVG_ELIGY_PRFL_ID and
19285: nvl(ADE.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
19286: nvl(ADE.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 19296: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE1

19292: and effective_end_date ;
19293: --END TEMPIK
19294: /*TEMPIK
19295: and exists ( select null
19296: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE1
19297: where
19298: ADE1.DPNT_CVG_ELIGY_PRFL_ID = l_DPNT_CVG_ELIGY_PRFL_ID and
19299: nvl(ADE1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
19300: nvl(ADE1.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 19305: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE2

19301: nvl(ADE1.PTIP_ID,-999) = nvl(l_PTIP_ID,-999) and
19302: ADE1.business_group_id = c_business_group_id
19303: and ADE1.effective_start_date <= c_effective_start_date )
19304: and exists ( select null
19305: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE2
19306: where
19307: ADE2.DPNT_CVG_ELIGY_PRFL_ID = l_DPNT_CVG_ELIGY_PRFL_ID and
19308: nvl(ADE2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
19309: nvl(ADE2.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 19454: (p_base_table_name => 'BEN_APLD_DPNT_CVG_ELIG_PRFL_F',

19450: if c_find_ADE_in_target%found then
19451: --
19452: --TEMPIK
19453: l_dt_rec_found := dt_api.check_min_max_dates
19454: (p_base_table_name => 'BEN_APLD_DPNT_CVG_ELIG_PRFL_F',
19455: p_base_key_column => 'APLD_DPNT_CVG_ELIG_PRFL_ID',
19456: p_base_key_value => l_new_value,
19457: p_from_date => l_min_esd,
19458: p_to_date => l_max_eed );

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

19509: end if;
19510:
19511: if l_first_rec and not l_update then
19512: -- Call Create routine.
19513: hr_utility.set_location(' BEN_APLD_DPNT_CVG_ELIG_PRFL_F CREATE_APLD_DPNT_CVG_PRFL ',20);
19514: BEN_APLD_DPNT_CVG_PRFL_API.CREATE_APLD_DPNT_CVG_PRFL(
19515: --
19516: P_VALIDATE => false
19517: ,P_EFFECTIVE_DATE => l_effective_date

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

19578: else
19579: --
19580: -- Call Update routine for the pk_id created in prev run .
19581: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
19582: hr_utility.set_location(' BEN_APLD_DPNT_CVG_ELIG_PRFL_F UPDATE_APLD_DPNT_CVG_PRFL ',30);
19583: --UPD START
19584: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
19585: --
19586: if l_update then