APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_TTL_CVG_VOL_RT_F

Line 19033: -- and tr.where_clause = l_BEN_TTL_CVG_VOL_RT_F

19029: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19030: pqh_table_route tr
19031: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19032: and cpe.table_route_id = tr.table_route_id
19033: -- and tr.where_clause = l_BEN_TTL_CVG_VOL_RT_F
19034: and tr.table_alias = l_table_alias
19035: and cpe.number_of_copies = 1 -- ADDITION
19036: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
19037: order by information1, information2; --added for bug: 5151945

Line 19071: from BEN_TTL_CVG_VOL_RT_F TCV

19067: c_business_group_id number,
19068: c_new_pk_id number) is
19069: select
19070: TCV.ttl_cvg_vol_rt_id new_value
19071: from BEN_TTL_CVG_VOL_RT_F TCV
19072: where
19073: TCV.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
19074: nvl(TCV.CVG_VOL_DET_CD, '-YYYY') = nvl(l_CVG_VOL_DET_CD, '-YYYY') and
19075: nvl(TCV.CVG_VOL_DET_RL, -999) = nvl(l_CVG_VOL_DET_RL , -999)and

Line 19089: from BEN_TTL_CVG_VOL_RT_F TCV1

19085: and effective_end_date ;
19086: --END TEMPIK
19087: /*TEMPIK
19088: and exists ( select null
19089: from BEN_TTL_CVG_VOL_RT_F TCV1
19090: where
19091: TCV1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
19092: nvl(TCV1.CVG_VOL_DET_CD, '-YYYY') = nvl(l_CVG_VOL_DET_CD, '-YYYY') and
19093: nvl(TCV1.CVG_VOL_DET_RL, -999) = nvl(l_CVG_VOL_DET_RL , -999)and

Line 19102: from BEN_TTL_CVG_VOL_RT_F TCV2

19098: nvl(TCV1.NO_MX_CVG_VOL_AMT_APLS_FLAG, '-YYYY') = nvl(l_NO_MX_CVG_VOL_AMT_APLS_FLAG, '-YYYY') and
19099: TCV1.business_group_id = c_business_group_id
19100: and TCV1.effective_start_date <= c_effective_start_date )
19101: and exists ( select null
19102: from BEN_TTL_CVG_VOL_RT_F TCV2
19103: where
19104: TCV2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
19105: nvl(TCV2.CVG_VOL_DET_CD, '-YYYY') = nvl(l_CVG_VOL_DET_CD, '-YYYY') and
19106: nvl(TCV2.CVG_VOL_DET_RL, -999) = nvl(l_CVG_VOL_DET_RL , -999)and

Line 19250: (p_base_table_name => 'BEN_TTL_CVG_VOL_RT_F',

19246: if c_find_TCV_in_target%found then
19247: --
19248: --TEMPIK
19249: l_dt_rec_found := dt_api.check_min_max_dates
19250: (p_base_table_name => 'BEN_TTL_CVG_VOL_RT_F',
19251: p_base_key_column => 'TTL_CVG_VOL_RT_ID',
19252: p_base_key_value => l_new_value,
19253: p_from_date => l_min_esd,
19254: p_to_date => l_max_eed );

Line 19308: hr_utility.set_location(' BEN_TTL_CVG_VOL_RT_F CREATE_TTL_CVG_VOL_RT ',20);

19304: end if;
19305:
19306: if l_first_rec and not l_update then
19307: -- Call Create routine.
19308: hr_utility.set_location(' BEN_TTL_CVG_VOL_RT_F CREATE_TTL_CVG_VOL_RT ',20);
19309: BEN_TTL_CVG_VOL_RT_API.CREATE_TTL_CVG_VOL_RT(
19310: --
19311: P_VALIDATE => false
19312: ,P_EFFECTIVE_DATE => l_effective_date

Line 19405: hr_utility.set_location(' BEN_TTL_CVG_VOL_RT_F UPDATE_TTL_CVG_VOL_RT ',30);

19401: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
19402: --
19403: IF l_update OR l_dml_operation <> 'UPDATE' THEN
19404: --UPD END
19405: hr_utility.set_location(' BEN_TTL_CVG_VOL_RT_F UPDATE_TTL_CVG_VOL_RT ',30);
19406: BEN_TTL_CVG_VOL_RT_API.UPDATE_TTL_CVG_VOL_RT(
19407: --
19408: P_VALIDATE => false
19409: ,P_EFFECTIVE_DATE => l_effective_date