APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_COMP_LVL_RT_F

Line 22835: -- and tr.where_clause = l_BEN_COMP_LVL_RT_F

22831: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22832: pqh_table_route tr
22833: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22834: and cpe.table_route_id = tr.table_route_id
22835: -- and tr.where_clause = l_BEN_COMP_LVL_RT_F
22836: and tr.table_alias = l_table_alias
22837: and cpe.number_of_copies = 1 -- ADDITION
22838: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
22839: order by information1, information2; --added for bug: 5151945

Line 22873: from BEN_COMP_LVL_RT_F CLR

22869: c_business_group_id number,
22870: c_new_pk_id number) is
22871: select
22872: CLR.comp_lvl_rt_id new_value
22873: from BEN_COMP_LVL_RT_F CLR
22874: where
22875: CLR.COMP_LVL_FCTR_ID = l_COMP_LVL_FCTR_ID and
22876: CLR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
22877: CLR.ORDR_NUM = l_ORDR_NUM and

Line 22886: from BEN_COMP_LVL_RT_F CLR1

22882: and effective_end_date ;
22883: --END TEMPIK
22884: /*TEMPIK
22885: and exists ( select null
22886: from BEN_COMP_LVL_RT_F CLR1
22887: where
22888: CLR1.COMP_LVL_FCTR_ID = l_COMP_LVL_FCTR_ID and
22889: CLR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
22890: CLR1.ORDR_NUM = l_ORDR_NUM and

Line 22894: from BEN_COMP_LVL_RT_F CLR2

22890: CLR1.ORDR_NUM = l_ORDR_NUM and
22891: CLR1.business_group_id = c_business_group_id
22892: and CLR1.effective_start_date <= c_effective_start_date )
22893: and exists ( select null
22894: from BEN_COMP_LVL_RT_F CLR2
22895: where
22896: CLR2.COMP_LVL_FCTR_ID = l_COMP_LVL_FCTR_ID and
22897: CLR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
22898: CLR2.ORDR_NUM = l_ORDR_NUM and

Line 23034: (p_base_table_name => 'BEN_COMP_LVL_RT_F',

23030: if c_find_CLR_in_target%found then
23031: --
23032: --TEMPIK
23033: l_dt_rec_found := dt_api.check_min_max_dates
23034: (p_base_table_name => 'BEN_COMP_LVL_RT_F',
23035: p_base_key_column => 'COMP_LVL_RT_ID',
23036: p_base_key_value => l_new_value,
23037: p_from_date => l_min_esd,
23038: p_to_date => l_max_eed );

Line 23092: hr_utility.set_location(' BEN_COMP_LVL_RT_F CREATE_COMP_LEVEL_RATE ',20);

23088: end if;
23089:
23090: if l_first_rec and not l_update then
23091: -- Call Create routine.
23092: hr_utility.set_location(' BEN_COMP_LVL_RT_F CREATE_COMP_LEVEL_RATE ',20);
23093: BEN_COMP_LEVEL_RATE_API.CREATE_COMP_LEVEL_RATE(
23094: --
23095: P_VALIDATE => false
23096: ,P_EFFECTIVE_DATE => l_effective_date

Line 23184: hr_utility.set_location(' BEN_COMP_LVL_RT_F UPDATE_COMP_LEVEL_RATE ',30);

23180: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
23181: --
23182: IF l_update OR l_dml_operation <> 'UPDATE' THEN
23183: --UPD END
23184: hr_utility.set_location(' BEN_COMP_LVL_RT_F UPDATE_COMP_LEVEL_RATE ',30);
23185: BEN_COMP_LEVEL_RATE_API.UPDATE_COMP_LEVEL_RATE(
23186: --
23187: P_VALIDATE => false
23188: ,P_EFFECTIVE_DATE => l_effective_date