APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_LER_BNFT_RSTRN_CTFN_F

Line 4068: -- and tr.where_clause = l_BEN_LER_BNFT_RSTRN_CTFN_F

4064: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4065: pqh_table_route tr
4066: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4067: and cpe.table_route_id = tr.table_route_id
4068: -- and tr.where_clause = l_BEN_LER_BNFT_RSTRN_CTFN_F
4069: and tr.table_alias = l_table_alias
4070: and cpe.number_of_copies = 1 --ADDITION
4071: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
4072: order by information1, information2; --added for bug: 5151945

Line 4106: from BEN_LER_BNFT_RSTRN_CTFN_F LBC

4102: c_business_group_id number,
4103: c_new_pk_id number) is
4104: select
4105: LBC.ler_bnft_rstrn_ctfn_id new_value
4106: from BEN_LER_BNFT_RSTRN_CTFN_F LBC
4107: where
4108: nvl(LBC.LER_BNFT_RSTRN_ID,-999) = nvl(l_LER_BNFT_RSTRN_ID,-999) and
4109: nvl(LBC.ENRT_CTFN_TYP_CD,'XXX') = nvl(l_ENRT_CTFN_TYP_CD,'XXX') and
4110: LBC.business_group_id = c_business_group_id

Line 4118: from BEN_LER_BNFT_RSTRN_CTFN_F LBC1

4114: and effective_end_date ;
4115: --END TEMPIK
4116: /*TEMPIK
4117: and exists ( select null
4118: from BEN_LER_BNFT_RSTRN_CTFN_F LBC1
4119: where
4120: nvl(LBC1.LER_BNFT_RSTRN_ID,-999) = nvl(l_LER_BNFT_RSTRN_ID,-999) and
4121: LBC1.ENRT_CTFN_TYP_CD = l_ENRT_CTFN_TYP_CD and
4122: LBC1.business_group_id = c_business_group_id

Line 4125: from BEN_LER_BNFT_RSTRN_CTFN_F LBC2

4121: LBC1.ENRT_CTFN_TYP_CD = l_ENRT_CTFN_TYP_CD and
4122: LBC1.business_group_id = c_business_group_id
4123: and LBC1.effective_start_date <= c_effective_start_date )
4124: and exists ( select null
4125: from BEN_LER_BNFT_RSTRN_CTFN_F LBC2
4126: where
4127: nvl(LBC2.LER_BNFT_RSTRN_ID,-999) = nvl(l_LER_BNFT_RSTRN_ID,-999) and
4128: LBC2.ENRT_CTFN_TYP_CD = l_ENRT_CTFN_TYP_CD and
4129: LBC2.business_group_id = c_business_group_id

Line 4272: (p_base_table_name => 'BEN_LER_BNFT_RSTRN_CTFN_F',

4268: if c_find_LBC_in_target%found then
4269: --
4270: --TEMPIK
4271: l_dt_rec_found := dt_api.check_min_max_dates
4272: (p_base_table_name => 'BEN_LER_BNFT_RSTRN_CTFN_F',
4273: p_base_key_column => 'LER_BNFT_RSTRN_CTFN_ID',
4274: p_base_key_value => l_new_value,
4275: p_from_date => l_min_esd,
4276: p_to_date => l_max_eed );

Line 4332: hr_utility.set_location(' BEN_LER_BNFT_RSTRN_CTFN_F CREATE_LER_BNFT_RSTRN_CTFN ',20);

4328: end if;
4329:
4330: if l_first_rec and not l_update then
4331: -- Call Create routine.
4332: hr_utility.set_location(' BEN_LER_BNFT_RSTRN_CTFN_F CREATE_LER_BNFT_RSTRN_CTFN ',20);
4333: BEN_LER_BNFT_RSTRN_CTFN_API.CREATE_LER_BNFT_RSTRN_CTFN(
4334: --
4335: P_VALIDATE => false
4336: ,P_EFFECTIVE_DATE => l_effective_date

Line 4399: hr_utility.set_location(' BEN_LER_BNFT_RSTRN_CTFN_F UPDATE_LER_BNFT_RSTRN_CTFN ',30);

4395: else
4396: --
4397: -- Call Update routine for the pk_id created in prev run .
4398: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
4399: hr_utility.set_location(' BEN_LER_BNFT_RSTRN_CTFN_F UPDATE_LER_BNFT_RSTRN_CTFN ',30);
4400: --UPD START
4401: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
4402: --
4403: if l_update then