APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_AGE_RT_F

Line 24212: -- and tr.where_clause = l_BEN_AGE_RT_F

24208: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24209: pqh_table_route tr
24210: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24211: and cpe.table_route_id = tr.table_route_id
24212: -- and tr.where_clause = l_BEN_AGE_RT_F
24213: and tr.table_alias = l_table_alias
24214: and cpe.number_of_copies = 1 -- ADDITION
24215: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
24216: order by information1, information2; --added for bug: 5151945

Line 24250: from BEN_AGE_RT_F ART

24246: c_business_group_id number,
24247: c_new_pk_id number) is
24248: select
24249: ART.age_rt_id new_value
24250: from BEN_AGE_RT_F ART
24251: where
24252: ART.AGE_FCTR_ID = l_AGE_FCTR_ID and
24253: ART.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
24254: ART.ORDR_NUM = l_ORDR_NUM and

Line 24263: from BEN_AGE_RT_F ART1

24259: and effective_end_date ;
24260: --END TEMPIK
24261: /*TEMPIK
24262: and exists ( select null
24263: from BEN_AGE_RT_F ART1
24264: where
24265: ART1.AGE_FCTR_ID = l_AGE_FCTR_ID and
24266: ART1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
24267: ART1.ORDR_NUM = l_ORDR_NUM and

Line 24271: from BEN_AGE_RT_F ART2

24267: ART1.ORDR_NUM = l_ORDR_NUM and
24268: ART1.business_group_id = c_business_group_id
24269: and ART1.effective_start_date <= c_effective_start_date )
24270: and exists ( select null
24271: from BEN_AGE_RT_F ART2
24272: where
24273: ART2.AGE_FCTR_ID = l_AGE_FCTR_ID and
24274: ART2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
24275: ART2.ORDR_NUM = l_ORDR_NUM and

Line 24410: (p_base_table_name => 'BEN_AGE_RT_F',

24406: if c_find_ART_in_target%found then
24407: --
24408: --TEMPIK
24409: l_dt_rec_found := dt_api.check_min_max_dates
24410: (p_base_table_name => 'BEN_AGE_RT_F',
24411: p_base_key_column => 'AGE_RT_ID',
24412: p_base_key_value => l_new_value,
24413: p_from_date => l_min_esd,
24414: p_to_date => l_max_eed );

Line 24468: hr_utility.set_location(' BEN_AGE_RT_F CREATE_AGE_RATES ',20);

24464: end if;
24465:
24466: if l_first_rec and not l_update then
24467: -- Call Create routine.
24468: hr_utility.set_location(' BEN_AGE_RT_F CREATE_AGE_RATES ',20);
24469: BEN_AGE_RATES_API.CREATE_AGE_RATES(
24470: --
24471: P_VALIDATE => false
24472: ,P_EFFECTIVE_DATE => l_effective_date

Line 24560: hr_utility.set_location(' BEN_AGE_RT_F UPDATE_AGE_RATES ',30);

24556: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
24557: --
24558: IF l_update OR l_dml_operation <> 'UPDATE' THEN
24559: --UPD END
24560: hr_utility.set_location(' BEN_AGE_RT_F UPDATE_AGE_RATES ',30);
24561: BEN_AGE_RATES_API.UPDATE_AGE_RATES(
24562: --
24563: P_VALIDATE => false
24564: ,P_EFFECTIVE_DATE => l_effective_date