APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_PCT_FL_TM_RT_F

Line 21908: -- and tr.where_clause = l_BEN_PCT_FL_TM_RT_F

21904: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21905: pqh_table_route tr
21906: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21907: and cpe.table_route_id = tr.table_route_id
21908: -- and tr.where_clause = l_BEN_PCT_FL_TM_RT_F
21909: and tr.table_alias = l_table_alias
21910: and cpe.number_of_copies = 1 -- ADDITION
21911: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
21912: order by information1, information2; --added for bug: 5151945

Line 21946: from BEN_PCT_FL_TM_RT_F PFR

21942: c_business_group_id number,
21943: c_new_pk_id number) is
21944: select
21945: PFR.pct_fl_tm_rt_id new_value
21946: from BEN_PCT_FL_TM_RT_F PFR
21947: where
21948: PFR.PCT_FL_TM_FCTR_ID = l_PCT_FL_TM_FCTR_ID and
21949: PFR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
21950: PFR.ORDR_NUM = l_ORDR_NUM and

Line 21959: from BEN_PCT_FL_TM_RT_F PFR1

21955: and effective_end_date ;
21956: --END TEMPIK
21957: /*TEMPIK
21958: and exists ( select null
21959: from BEN_PCT_FL_TM_RT_F PFR1
21960: where
21961: PFR1.PCT_FL_TM_FCTR_ID = l_PCT_FL_TM_FCTR_ID and
21962: PFR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
21963: PFR1.ORDR_NUM = l_ORDR_NUM and

Line 21967: from BEN_PCT_FL_TM_RT_F PFR2

21963: PFR1.ORDR_NUM = l_ORDR_NUM and
21964: PFR1.business_group_id = c_business_group_id
21965: and PFR1.effective_start_date <= c_effective_start_date )
21966: and exists ( select null
21967: from BEN_PCT_FL_TM_RT_F PFR2
21968: where
21969: PFR2.PCT_FL_TM_FCTR_ID = l_PCT_FL_TM_FCTR_ID and
21970: PFR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
21971: PFR2.ORDR_NUM = l_ORDR_NUM and

Line 22105: (p_base_table_name => 'BEN_PCT_FL_TM_RT_F',

22101: fetch c_find_PFR_in_target into l_new_value ;
22102: if c_find_PFR_in_target%found then
22103: --TEMPIK
22104: l_dt_rec_found := dt_api.check_min_max_dates
22105: (p_base_table_name => 'BEN_PCT_FL_TM_RT_F',
22106: p_base_key_column => 'PCT_FL_TM_RT_ID',
22107: p_base_key_value => l_new_value,
22108: p_from_date => l_min_esd,
22109: p_to_date => l_max_eed );

Line 22164: hr_utility.set_location(' BEN_PCT_FL_TM_RT_F CREATE_PCT_FULL_TIME_RATE ',20);

22160: end if;
22161:
22162: if l_first_rec and not l_update then
22163: -- Call Create routine.
22164: hr_utility.set_location(' BEN_PCT_FL_TM_RT_F CREATE_PCT_FULL_TIME_RATE ',20);
22165: BEN_PCT_FULL_TIME_RATE_API.CREATE_PCT_FULL_TIME_RATE(
22166: --
22167: P_VALIDATE => false
22168: ,P_EFFECTIVE_DATE => l_effective_date

Line 22255: hr_utility.set_location(' BEN_PCT_FL_TM_RT_F UPDATE_PCT_FULL_TIME_RATE ',30);

22251: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
22252: --
22253: IF l_update OR l_dml_operation <> 'UPDATE' THEN
22254: --UPD END
22255: hr_utility.set_location(' BEN_PCT_FL_TM_RT_F UPDATE_PCT_FULL_TIME_RATE ',30);
22256: BEN_PCT_FULL_TIME_RATE_API.UPDATE_PCT_FULL_TIME_RATE(
22257: --
22258: P_VALIDATE => false
22259: ,P_EFFECTIVE_DATE => l_effective_date