APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_CMBN_AGE_LOS_RT_F

Line 11151: -- and tr.where_clause = l_BEN_CMBN_AGE_LOS_RT_F

11147: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
11148: pqh_table_route tr
11149: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11150: and cpe.table_route_id = tr.table_route_id
11151: -- and tr.where_clause = l_BEN_CMBN_AGE_LOS_RT_F
11152: and tr.table_alias = l_table_alias
11153: and cpe.number_of_copies = 1 -- ADDITION
11154: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
11155: order by information1, information2; --added for bug: 5151945

Line 11189: from BEN_CMBN_AGE_LOS_RT_F CMR

11185: c_business_group_id number,
11186: c_new_pk_id number) is
11187: select
11188: CMR.cmbn_age_los_rt_id new_value
11189: from BEN_CMBN_AGE_LOS_RT_F CMR
11190: where
11191: CMR.CMBN_AGE_LOS_FCTR_ID = l_CMBN_AGE_LOS_FCTR_ID and
11192: CMR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
11193: CMR.business_group_id = c_business_group_id

Line 11201: from BEN_CMBN_AGE_LOS_RT_F CMR1

11197: and effective_end_date ;
11198: --END TEMPIK
11199: /*TEMPIK
11200: and exists ( select null
11201: from BEN_CMBN_AGE_LOS_RT_F CMR1
11202: where
11203: CMR1.CMBN_AGE_LOS_FCTR_ID = l_CMBN_AGE_LOS_FCTR_ID and
11204: CMR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
11205: CMR1.business_group_id = c_business_group_id

Line 11208: from BEN_CMBN_AGE_LOS_RT_F CMR2

11204: CMR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
11205: CMR1.business_group_id = c_business_group_id
11206: and CMR1.effective_start_date <= c_effective_start_date )
11207: and exists ( select null
11208: from BEN_CMBN_AGE_LOS_RT_F CMR2
11209: where
11210: CMR2.CMBN_AGE_LOS_FCTR_ID = l_CMBN_AGE_LOS_FCTR_ID and
11211: CMR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
11212: CMR2.business_group_id = c_business_group_id

Line 11344: (p_base_table_name => 'BEN_CMBN_AGE_LOS_RT_F',

11340: if c_find_CMR_in_target%found then
11341: --
11342: --TEMPIK
11343: l_dt_rec_found := dt_api.check_min_max_dates
11344: (p_base_table_name => 'BEN_CMBN_AGE_LOS_RT_F',
11345: p_base_key_column => 'CMBN_AGE_LOS_RT_ID',
11346: p_base_key_value => l_new_value,
11347: p_from_date => l_min_esd,
11348: p_to_date => l_max_eed );

Line 11402: hr_utility.set_location(' BEN_CMBN_AGE_LOS_RT_F CREATE_CMBN_AGE_LOS_RT ',20);

11398: end if;
11399:
11400: if l_first_rec and not l_update then
11401: -- Call Create routine.
11402: hr_utility.set_location(' BEN_CMBN_AGE_LOS_RT_F CREATE_CMBN_AGE_LOS_RT ',20);
11403: BEN_CMBN_AGE_LOS_RT_API.CREATE_CMBN_AGE_LOS_RT(
11404: --
11405: P_VALIDATE => false
11406: ,P_EFFECTIVE_DATE => l_effective_date

Line 11494: hr_utility.set_location(' BEN_CMBN_AGE_LOS_RT_F UPDATE_CMBN_AGE_LOS_RT ',30);

11490: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
11491: --
11492: IF l_update OR l_dml_operation <> 'UPDATE' THEN
11493: --UPD END
11494: hr_utility.set_location(' BEN_CMBN_AGE_LOS_RT_F UPDATE_CMBN_AGE_LOS_RT ',30);
11495: BEN_CMBN_AGE_LOS_RT_API.UPDATE_CMBN_AGE_LOS_RT(
11496: --
11497: P_VALIDATE => false
11498: ,P_EFFECTIVE_DATE => l_effective_date