APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_TTL_PRTT_RT_F

Line 18533: -- and tr.where_clause = l_BEN_TTL_PRTT_RT_F

18529: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18530: pqh_table_route tr
18531: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18532: and cpe.table_route_id = tr.table_route_id
18533: -- and tr.where_clause = l_BEN_TTL_PRTT_RT_F
18534: and tr.table_alias = l_table_alias
18535: and cpe.number_of_copies = 1 -- ADDITION
18536: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
18537: order by information1, information2; --added for bug: 5151945

Line 18571: from BEN_TTL_PRTT_RT_F TTP

18567: c_business_group_id number,
18568: c_new_pk_id number) is
18569: select
18570: TTP.ttl_prtt_rt_id new_value
18571: from BEN_TTL_PRTT_RT_F TTP
18572: where
18573: TTP.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
18574: nvl(TTP.PRTT_DET_CD, '-YYYY') = nvl(l_PRTT_DET_CD, '-YYYY') and
18575: nvl(TTP.PRTT_DET_RL, -999) = nvl(l_PRTT_DET_RL , -999)and

Line 18589: from BEN_TTL_PRTT_RT_F TTP1

18585: and effective_end_date ;
18586: --END TEMPIK
18587: /*TEMPIK
18588: and exists ( select null
18589: from BEN_TTL_PRTT_RT_F TTP1
18590: where
18591: TTP1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
18592: nvl(TTP1.PRTT_DET_CD, '-YYYY') = nvl(l_PRTT_DET_CD, '-YYYY') and
18593: nvl(TTP1.PRTT_DET_RL, -999) = nvl(l_PRTT_DET_RL , -999)and

Line 18602: from BEN_TTL_PRTT_RT_F TTP2

18598: nvl(TTP1.NO_MN_PRTT_NUM_APLS_FLAG, '-YYYY') = nvl(l_NO_MN_PRTT_NUM_APLS_FLAG, '-YYYY') and
18599: TTP1.business_group_id = c_business_group_id
18600: and TTP1.effective_start_date <= c_effective_start_date )
18601: and exists ( select null
18602: from BEN_TTL_PRTT_RT_F TTP2
18603: where
18604: TTP2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
18605: nvl(TTP2.PRTT_DET_CD, '-YYYY') = nvl(l_PRTT_DET_CD, '-YYYY') and
18606: nvl(TTP2.PRTT_DET_RL, -999) = nvl(l_PRTT_DET_RL , -999)and

Line 18752: (p_base_table_name => 'BEN_TTL_PRTT_RT_F',

18748: if c_find_TTP_in_target%found then
18749: --
18750: --TEMPIK
18751: l_dt_rec_found := dt_api.check_min_max_dates
18752: (p_base_table_name => 'BEN_TTL_PRTT_RT_F',
18753: p_base_key_column => 'TTL_PRTT_RT_ID',
18754: p_base_key_value => l_new_value,
18755: p_from_date => l_min_esd,
18756: p_to_date => l_max_eed );

Line 18810: hr_utility.set_location(' BEN_TTL_PRTT_RT_F CREATE_TTL_PRTT_RT ',20);

18806: end if;
18807:
18808: if l_first_rec and not l_update then
18809: -- Call Create routine.
18810: hr_utility.set_location(' BEN_TTL_PRTT_RT_F CREATE_TTL_PRTT_RT ',20);
18811: BEN_TTL_PRTT_RT_API.CREATE_TTL_PRTT_RT(
18812: --
18813: P_VALIDATE => false
18814: ,P_EFFECTIVE_DATE => l_effective_date

Line 18907: hr_utility.set_location(' BEN_TTL_PRTT_RT_F UPDATE_TTL_PRTT_RT ',30);

18903: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
18904: --
18905: IF l_update OR l_dml_operation <> 'UPDATE' THEN
18906: --UPD END
18907: hr_utility.set_location(' BEN_TTL_PRTT_RT_F UPDATE_TTL_PRTT_RT ',30);
18908: BEN_TTL_PRTT_RT_API.UPDATE_TTL_PRTT_RT(
18909: --
18910: P_VALIDATE => false
18911: ,P_EFFECTIVE_DATE => l_effective_date