APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_SVC_AREA_RT_F

Line 4054: -- and tr.where_clause = l_BEN_SVC_AREA_RT_F

4050: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4051: pqh_table_route tr
4052: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4053: and cpe.table_route_id = tr.table_route_id
4054: -- and tr.where_clause = l_BEN_SVC_AREA_RT_F
4055: and tr.table_alias = l_table_alias
4056: and cpe.number_of_copies = 1 -- ADDITION
4057: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
4058: order by information1, information2; --added for bug: 5151945

Line 4092: from BEN_SVC_AREA_RT_F SAR

4088: c_business_group_id number,
4089: c_new_pk_id number) is
4090: select
4091: SAR.svc_area_rt_id new_value
4092: from BEN_SVC_AREA_RT_F SAR
4093: where
4094: SAR.SVC_AREA_ID = l_SVC_AREA_ID and
4095: SAR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
4096: SAR.ORDR_NUM = l_ORDR_NUM and

Line 4105: from BEN_SVC_AREA_RT_F SAR1

4101: and effective_end_date ;
4102: --END TEMPIK
4103: /*TEMPIK
4104: and exists ( select null
4105: from BEN_SVC_AREA_RT_F SAR1
4106: where
4107: SAR1.SVC_AREA_ID = l_SVC_AREA_ID and
4108: SAR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
4109: SAR1.ORDR_NUM = l_ORDR_NUM and

Line 4113: from BEN_SVC_AREA_RT_F SAR2

4109: SAR1.ORDR_NUM = l_ORDR_NUM and
4110: SAR1.business_group_id = c_business_group_id
4111: and SAR1.effective_start_date <= c_effective_start_date )
4112: and exists ( select null
4113: from BEN_SVC_AREA_RT_F SAR2
4114: where
4115: SAR2.SVC_AREA_ID = l_SVC_AREA_ID and
4116: SAR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
4117: SAR2.ORDR_NUM = l_ORDR_NUM and

Line 4252: (p_base_table_name => 'BEN_SVC_AREA_RT_F',

4248: if c_find_SAR_in_target%found then
4249: --
4250: --TEMPIK
4251: l_dt_rec_found := dt_api.check_min_max_dates
4252: (p_base_table_name => 'BEN_SVC_AREA_RT_F',
4253: p_base_key_column => 'SVC_AREA_RT_ID',
4254: p_base_key_value => l_new_value,
4255: p_from_date => l_min_esd,
4256: p_to_date => l_max_eed );

Line 4310: hr_utility.set_location(' BEN_SVC_AREA_RT_F CREATE_SERVICE_AREA_RATE ',20);

4306: end if;
4307:
4308: if l_first_rec and not l_update then
4309: -- Call Create routine.
4310: hr_utility.set_location(' BEN_SVC_AREA_RT_F CREATE_SERVICE_AREA_RATE ',20);
4311: BEN_SERVICE_AREA_RATE_API.CREATE_SERVICE_AREA_RATE(
4312: --
4313: P_VALIDATE => false
4314: ,P_EFFECTIVE_DATE => l_effective_date

Line 4402: hr_utility.set_location(' BEN_SVC_AREA_RT_F UPDATE_SERVICE_AREA_RATE ',30);

4398: --
4399: IF l_update OR l_dml_operation <> 'UPDATE' THEN
4400: --UPD END
4401: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
4402: hr_utility.set_location(' BEN_SVC_AREA_RT_F UPDATE_SERVICE_AREA_RATE ',30);
4403: BEN_SERVICE_AREA_RATE_API.UPDATE_SERVICE_AREA_RATE(
4404: --
4405: P_VALIDATE => false
4406: ,P_EFFECTIVE_DATE => l_effective_date