eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_DPNT_OTHR_PTIP_RT_F

Line 16219: -- and tr.where_clause = l_BEN_DPNT_OTHR_PTIP_RT_F

16215: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16216: pqh_table_route tr
16217: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16218: and cpe.table_route_id = tr.table_route_id
16219: -- and tr.where_clause = l_BEN_DPNT_OTHR_PTIP_RT_F
16220: and tr.table_alias = l_table_alias
16221: and cpe.number_of_copies = 1 -- ADDITION
16222: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
16223: order by information1, information2; --added for bug: 5151945

Line 16257: from BEN_DPNT_OTHR_PTIP_RT_F DOT

16253: c_business_group_id number,
16254: c_new_pk_id number) is
16255: select
16256: DOT.dpnt_othr_ptip_rt_id new_value
16257: from BEN_DPNT_OTHR_PTIP_RT_F DOT
16258: where
16259: DOT.PTIP_ID = l_PTIP_ID and
16260: DOT.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
16261: DOT.business_group_id = c_business_group_id

Line 16269: from BEN_DPNT_OTHR_PTIP_RT_F DOT1

16265: and effective_end_date ;
16266: --END TEMPIK
16267: /*TEMPIK
16268: and exists ( select null
16269: from BEN_DPNT_OTHR_PTIP_RT_F DOT1
16270: where
16271: DOT1.PTIP_ID = l_PTIP_ID and
16272: DOT1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
16273: DOT1.business_group_id = c_business_group_id

Line 16276: from BEN_DPNT_OTHR_PTIP_RT_F DOT2

16272: DOT1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
16273: DOT1.business_group_id = c_business_group_id
16274: and DOT1.effective_start_date <= c_effective_start_date )
16275: and exists ( select null
16276: from BEN_DPNT_OTHR_PTIP_RT_F DOT2
16277: where
16278: DOT2.PTIP_ID = l_PTIP_ID and
16279: DOT2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
16280: DOT2.business_group_id = c_business_group_id

Line 16415: (p_base_table_name => 'BEN_DPNT_OTHR_PTIP_RT_F',

16411: if c_find_DOT_in_target%found then
16412: --
16413: --TEMPIK
16414: l_dt_rec_found := dt_api.check_min_max_dates
16415: (p_base_table_name => 'BEN_DPNT_OTHR_PTIP_RT_F',
16416: p_base_key_column => 'DPNT_OTHR_PTIP_RT_ID',
16417: p_base_key_value => l_new_value,
16418: p_from_date => l_min_esd,
16419: p_to_date => l_max_eed );

Line 16473: hr_utility.set_location(' BEN_DPNT_OTHR_PTIP_RT_F CREATE_DPNT_OTHR_PTIP_RT ',20);

16469: end if;
16470:
16471: if l_first_rec and not l_update then
16472: -- Call Create routine.
16473: hr_utility.set_location(' BEN_DPNT_OTHR_PTIP_RT_F CREATE_DPNT_OTHR_PTIP_RT ',20);
16474: BEN_DPNT_OTHR_PTIP_RT_API.CREATE_DPNT_OTHR_PTIP_RT(
16475: --
16476: P_VALIDATE => false
16477: ,P_EFFECTIVE_DATE => l_effective_date

Line 16565: hr_utility.set_location(' BEN_DPNT_OTHR_PTIP_RT_F UPDATE_DPNT_OTHR_PTIP_RT ',30);

16561: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
16562: --
16563: IF l_update OR l_dml_operation <> 'UPDATE' THEN
16564: --UPD END
16565: hr_utility.set_location(' BEN_DPNT_OTHR_PTIP_RT_F UPDATE_DPNT_OTHR_PTIP_RT ',30);
16566: BEN_DPNT_OTHR_PTIP_RT_API.UPDATE_DPNT_OTHR_PTIP_RT(
16567: --
16568: P_VALIDATE => false
16569: ,P_EFFECTIVE_DATE => l_effective_date