APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_ENRLD_ANTHR_OIPL_RT_F

Line 15758: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_OIPL_RT_F

15754: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15755: pqh_table_route tr
15756: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15757: and cpe.table_route_id = tr.table_route_id
15758: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_OIPL_RT_F
15759: and tr.table_alias = l_table_alias
15760: and cpe.number_of_copies = 1 -- ADDITION
15761: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
15762: order by information1, information2; --added for bug: 5151945

Line 15796: from BEN_ENRLD_ANTHR_OIPL_RT_F EAO

15792: c_business_group_id number,
15793: c_new_pk_id number) is
15794: select
15795: EAO.enrld_anthr_oipl_rt_id new_value
15796: from BEN_ENRLD_ANTHR_OIPL_RT_F EAO
15797: where
15798: EAO.OIPL_ID = l_OIPL_ID and
15799: EAO.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
15800: EAO.business_group_id = c_business_group_id

Line 15808: from BEN_ENRLD_ANTHR_OIPL_RT_F EAO1

15804: and effective_end_date ;
15805: --END TEMPIK
15806: /*TEMPIK
15807: and exists ( select null
15808: from BEN_ENRLD_ANTHR_OIPL_RT_F EAO1
15809: where
15810: EAO1.OIPL_ID = l_OIPL_ID and
15811: EAO1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
15812: EAO1.business_group_id = c_business_group_id

Line 15815: from BEN_ENRLD_ANTHR_OIPL_RT_F EAO2

15811: EAO1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
15812: EAO1.business_group_id = c_business_group_id
15813: and EAO1.effective_start_date <= c_effective_start_date )
15814: and exists ( select null
15815: from BEN_ENRLD_ANTHR_OIPL_RT_F EAO2
15816: where
15817: EAO2.OIPL_ID = l_OIPL_ID and
15818: EAO2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
15819: EAO2.business_group_id = c_business_group_id

Line 15954: (p_base_table_name => 'BEN_ENRLD_ANTHR_OIPL_RT_F',

15950: if c_find_EAO_in_target%found then
15951: --
15952: --TEMPIK
15953: l_dt_rec_found := dt_api.check_min_max_dates
15954: (p_base_table_name => 'BEN_ENRLD_ANTHR_OIPL_RT_F',
15955: p_base_key_column => 'ENRLD_ANTHR_OIPL_RT_ID',
15956: p_base_key_value => l_new_value,
15957: p_from_date => l_min_esd,
15958: p_to_date => l_max_eed );

Line 16012: hr_utility.set_location(' BEN_ENRLD_ANTHR_OIPL_RT_F CREATE_ENRLD_ANTHR_OIPL_RT ',20);

16008: end if;
16009:
16010: if l_first_rec and not l_update then
16011: -- Call Create routine.
16012: hr_utility.set_location(' BEN_ENRLD_ANTHR_OIPL_RT_F CREATE_ENRLD_ANTHR_OIPL_RT ',20);
16013: BEN_ENRLD_ANTHR_OIPL_RT_API.CREATE_ENRLD_ANTHR_OIPL_RT(
16014: --
16015: P_VALIDATE => false
16016: ,P_EFFECTIVE_DATE => l_effective_date

Line 16105: hr_utility.set_location(' BEN_ENRLD_ANTHR_OIPL_RT_F UPDATE_ENRLD_ANTHR_OIPL_RT ',30);

16101: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
16102: --
16103: IF l_update OR l_dml_operation <> 'UPDATE' THEN
16104: --UPD END
16105: hr_utility.set_location(' BEN_ENRLD_ANTHR_OIPL_RT_F UPDATE_ENRLD_ANTHR_OIPL_RT ',30);
16106: BEN_ENRLD_ANTHR_OIPL_RT_API.UPDATE_ENRLD_ANTHR_OIPL_RT(
16107: --
16108: P_VALIDATE => false
16109: ,P_EFFECTIVE_DATE => l_effective_date