APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_PRTT_ANTHR_PL_PRTE_F

Line 15995: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F EPP

15991: c_business_group_id number,
15992: c_new_pk_id number) is
15993: select
15994: EPP.elig_prtt_anthr_pl_prte_id new_value
15995: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F EPP
15996: where
15997: EPP.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
15998: EPP.PL_ID = l_PL_ID and
15999: EPP.business_group_id = c_business_group_id

Line 16006: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F EPP1

16002: and effective_end_date ;
16003: --END TEMPIK
16004: /*TEMPIK
16005: and exists ( select null
16006: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F EPP1
16007: where
16008: EPP1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
16009: EPP1.PL_ID = l_PL_ID and
16010: EPP1.ORDR_NUM = l_ORDR_NUM and -- Added this criteria

Line 16014: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F EPP2

16010: EPP1.ORDR_NUM = l_ORDR_NUM and -- Added this criteria
16011: EPP1.business_group_id = c_business_group_id
16012: and EPP1.effective_start_date <= c_effective_start_date )
16013: and exists ( select null
16014: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F EPP2
16015: where
16016: EPP2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
16017: EPP2.PL_ID = l_PL_ID and
16018: EPP2.ORDR_NUM = l_ORDR_NUM and -- Added this criteria

Line 16181: (p_base_table_name => 'BEN_ELIG_PRTT_ANTHR_PL_PRTE_F',

16177: if c_find_EPP_in_target%found then
16178: --
16179: --TEMPIK
16180: l_dt_rec_found := dt_api.check_min_max_dates
16181: (p_base_table_name => 'BEN_ELIG_PRTT_ANTHR_PL_PRTE_F',
16182: p_base_key_column => 'ELIG_PRTT_ANTHR_PL_PRTE_ID',
16183: p_base_key_value => l_new_value,
16184: p_from_date => l_min_esd,
16185: p_to_date => l_max_eed );

Line 16241: hr_utility.set_location(' BEN_ELIG_PRTT_ANTHR_PL_PRTE_F CREATE_ELG_PRT_ANTHR_PL_PT ',20);

16237: end if;
16238:
16239: if l_first_rec and not l_update then
16240: -- Call Create routine.
16241: hr_utility.set_location(' BEN_ELIG_PRTT_ANTHR_PL_PRTE_F CREATE_ELG_PRT_ANTHR_PL_PT ',20);
16242: BEN_ELG_PRT_ANTHR_PL_PT_API.CREATE_ELG_PRT_ANTHR_PL_PT(
16243: --
16244: P_VALIDATE => false
16245: ,P_EFFECTIVE_DATE => l_effective_date

Line 16308: hr_utility.set_location(' BEN_ELIG_PRTT_ANTHR_PL_PRTE_F UPDATE_ELG_PRT_ANTHR_PL_PT ',30);

16304: else
16305: --
16306: -- Call Update routine for the pk_id created in prev run .
16307: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
16308: hr_utility.set_location(' BEN_ELIG_PRTT_ANTHR_PL_PRTE_F UPDATE_ELG_PRT_ANTHR_PL_PT ',30);
16309: --UPD START
16310: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
16311: --
16312: if l_update then