APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_DPNT_CVRD_OTHR_PL_RT_F

Line 18065: -- and tr.where_clause = l_BEN_DPNT_CVRD_OTHR_PL_RT_F

18061: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18062: pqh_table_route tr
18063: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18064: and cpe.table_route_id = tr.table_route_id
18065: -- and tr.where_clause = l_BEN_DPNT_CVRD_OTHR_PL_RT_F
18066: and tr.table_alias = l_table_alias
18067: and cpe.number_of_copies = 1 -- ADDITION
18068: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
18069: order by information1, information2; --added for bug: 5151945

Line 18103: from BEN_DPNT_CVRD_OTHR_PL_RT_F DCL

18099: c_business_group_id number,
18100: c_new_pk_id number) is
18101: select
18102: DCL.dpnt_cvrd_othr_pl_rt_id new_value
18103: from BEN_DPNT_CVRD_OTHR_PL_RT_F DCL
18104: where
18105: DCL.PL_ID = l_PL_ID and
18106: DCL.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
18107: DCL.business_group_id = c_business_group_id

Line 18115: from BEN_DPNT_CVRD_OTHR_PL_RT_F DCL1

18111: and effective_end_date ;
18112: --END TEMPIK
18113: /*TEMPIK
18114: and exists ( select null
18115: from BEN_DPNT_CVRD_OTHR_PL_RT_F DCL1
18116: where
18117: DCL1.PL_ID = l_PL_ID and
18118: DCL1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
18119: DCL1.business_group_id = c_business_group_id

Line 18122: from BEN_DPNT_CVRD_OTHR_PL_RT_F DCL2

18118: DCL1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
18119: DCL1.business_group_id = c_business_group_id
18120: and DCL1.effective_start_date <= c_effective_start_date )
18121: and exists ( select null
18122: from BEN_DPNT_CVRD_OTHR_PL_RT_F DCL2
18123: where
18124: DCL2.PL_ID = l_PL_ID and
18125: DCL2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
18126: DCL2.business_group_id = c_business_group_id

Line 18261: (p_base_table_name => 'BEN_DPNT_CVRD_OTHR_PL_RT_F',

18257: if c_find_DCL_in_target%found then
18258: --
18259: --TEMPIK
18260: l_dt_rec_found := dt_api.check_min_max_dates
18261: (p_base_table_name => 'BEN_DPNT_CVRD_OTHR_PL_RT_F',
18262: p_base_key_column => 'DPNT_CVRD_OTHR_PL_RT_ID',
18263: p_base_key_value => l_new_value,
18264: p_from_date => l_min_esd,
18265: p_to_date => l_max_eed );

Line 18319: hr_utility.set_location(' BEN_DPNT_CVRD_OTHR_PL_RT_F CREATE_DPNT_CVRD_OTHR_PL_RT ',20);

18315: end if;
18316:
18317: if l_first_rec and not l_update then
18318: -- Call Create routine.
18319: hr_utility.set_location(' BEN_DPNT_CVRD_OTHR_PL_RT_F CREATE_DPNT_CVRD_OTHR_PL_RT ',20);
18320: BEN_DPNT_CVRD_OTHR_PL_RT_API.CREATE_DPNT_CVRD_OTHR_PL_RT(
18321: --
18322: P_VALIDATE => false
18323: ,P_EFFECTIVE_DATE => l_effective_date

Line 18412: hr_utility.set_location(' BEN_DPNT_CVRD_OTHR_PL_RT_F UPDATE_DPNT_CVRD_OTHR_PL_RT ',30);

18408: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
18409: --
18410: IF l_update OR l_dml_operation <> 'UPDATE' THEN
18411: --UPD END
18412: hr_utility.set_location(' BEN_DPNT_CVRD_OTHR_PL_RT_F UPDATE_DPNT_CVRD_OTHR_PL_RT ',30);
18413: BEN_DPNT_CVRD_OTHR_PL_RT_API.UPDATE_DPNT_CVRD_OTHR_PL_RT(
18414: --
18415: P_VALIDATE => false
18416: ,P_EFFECTIVE_DATE => l_effective_date