APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_ENRLD_ANTHR_PGM_F

Line 24155: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PGM_F

24151: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24152: pqh_table_route tr
24153: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24154: and cpe.table_route_id = tr.table_route_id
24155: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PGM_F
24156: and tr.table_alias = l_table_alias
24157: and cpe.number_of_copies = 1 -- ADDITION
24158: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
24159: order by information1, information2; --added for bug: 5151945

Line 24193: from BEN_ELIG_ENRLD_ANTHR_PGM_F EEG

24189: c_business_group_id number,
24190: c_new_pk_id number) is
24191: select
24192: EEG.elig_enrld_anthr_pgm_id new_value
24193: from BEN_ELIG_ENRLD_ANTHR_PGM_F EEG
24194: where
24195: EEG.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
24196: EEG.PGM_ID = l_PGM_ID and
24197: EEG.business_group_id = c_business_group_id

Line 24204: from BEN_ELIG_ENRLD_ANTHR_PGM_F EEG1

24200: and effective_end_date ;
24201: --END TEMPIK
24202: /*TEMPIK
24203: and exists ( select null
24204: from BEN_ELIG_ENRLD_ANTHR_PGM_F EEG1
24205: where
24206: EEG1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
24207: EEG1.PGM_ID = l_PGM_ID and
24208: EEG1.business_group_id = c_business_group_id

Line 24211: from BEN_ELIG_ENRLD_ANTHR_PGM_F EEG2

24207: EEG1.PGM_ID = l_PGM_ID and
24208: EEG1.business_group_id = c_business_group_id
24209: and EEG1.effective_start_date <= c_effective_start_date )
24210: and exists ( select null
24211: from BEN_ELIG_ENRLD_ANTHR_PGM_F EEG2
24212: where
24213: EEG2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
24214: EEG2.PGM_ID = l_PGM_ID and
24215: EEG2.business_group_id = c_business_group_id

Line 24372: (p_base_table_name => 'BEN_ELIG_ENRLD_ANTHR_PGM_F',

24368: if c_find_EEG_in_target%found then
24369: --
24370: --TEMPIK
24371: l_dt_rec_found := dt_api.check_min_max_dates
24372: (p_base_table_name => 'BEN_ELIG_ENRLD_ANTHR_PGM_F',
24373: p_base_key_column => 'ELIG_ENRLD_ANTHR_PGM_ID',
24374: p_base_key_value => l_new_value,
24375: p_from_date => l_min_esd,
24376: p_to_date => l_max_eed );

Line 24432: hr_utility.set_location(' BEN_ELIG_ENRLD_ANTHR_PGM_F CREATE_ELIG_ENRLD_ANTHR_PGM ',20);

24428: end if;
24429:
24430: if l_first_rec and not l_update then
24431: -- Call Create routine.
24432: hr_utility.set_location(' BEN_ELIG_ENRLD_ANTHR_PGM_F CREATE_ELIG_ENRLD_ANTHR_PGM ',20);
24433: BEN_ELIG_ENRLD_ANTHR_PGM_API.CREATE_ELIG_ENRLD_ANTHR_PGM(
24434: --
24435: P_VALIDATE => false
24436: ,P_EFFECTIVE_DATE => l_effective_date

Line 24504: hr_utility.set_location(' BEN_ELIG_ENRLD_ANTHR_PGM_F UPDATE_ELIG_ENRLD_ANTHR_PGM ',30);

24500: else
24501: --
24502: -- Call Update routine for the pk_id created in prev run .
24503: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
24504: hr_utility.set_location(' BEN_ELIG_ENRLD_ANTHR_PGM_F UPDATE_ELIG_ENRLD_ANTHR_PGM ',30);
24505: --UPD START
24506: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
24507: --
24508: if l_update then