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_PRTT_ANTHR_PL_RT_F

Line 12084: -- and tr.where_clause = l_BEN_PRTT_ANTHR_PL_RT_F

12080: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12081: pqh_table_route tr
12082: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12083: and cpe.table_route_id = tr.table_route_id
12084: -- and tr.where_clause = l_BEN_PRTT_ANTHR_PL_RT_F
12085: and tr.table_alias = l_table_alias
12086: and cpe.number_of_copies = 1 -- ADDITION
12087: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12088: order by information1, information2; --added for bug: 5151945

Line 12122: from BEN_PRTT_ANTHR_PL_RT_F PAP

12118: c_business_group_id number,
12119: c_new_pk_id number) is
12120: select
12121: PAP.prtt_anthr_pl_rt_id new_value
12122: from BEN_PRTT_ANTHR_PL_RT_F PAP
12123: where
12124: PAP.PL_ID = l_PL_ID and
12125: PAP.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
12126: PAP.business_group_id = c_business_group_id

Line 12134: from BEN_PRTT_ANTHR_PL_RT_F PAP1

12130: and effective_end_date ;
12131: --END TEMPIK
12132: /*TEMPIK
12133: and exists ( select null
12134: from BEN_PRTT_ANTHR_PL_RT_F PAP1
12135: where
12136: PAP1.PL_ID = l_PL_ID and
12137: PAP1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
12138: PAP1.business_group_id = c_business_group_id

Line 12141: from BEN_PRTT_ANTHR_PL_RT_F PAP2

12137: PAP1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
12138: PAP1.business_group_id = c_business_group_id
12139: and PAP1.effective_start_date <= c_effective_start_date )
12140: and exists ( select null
12141: from BEN_PRTT_ANTHR_PL_RT_F PAP2
12142: where
12143: PAP2.PL_ID = l_PL_ID and
12144: PAP2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
12145: PAP2.business_group_id = c_business_group_id

Line 12281: (p_base_table_name => 'BEN_PRTT_ANTHR_PL_RT_F',

12277: if c_find_PAP_in_target%found then
12278: --
12279: --TEMPIK
12280: l_dt_rec_found := dt_api.check_min_max_dates
12281: (p_base_table_name => 'BEN_PRTT_ANTHR_PL_RT_F',
12282: p_base_key_column => 'PRTT_ANTHR_PL_RT_ID',
12283: p_base_key_value => l_new_value,
12284: p_from_date => l_min_esd,
12285: p_to_date => l_max_eed );

Line 12339: hr_utility.set_location(' BEN_PRTT_ANTHR_PL_RT_F CREATE_PRTT_ANTHR_PL_RT ',20);

12335: end if;
12336:
12337: if l_first_rec and not l_update then
12338: -- Call Create routine.
12339: hr_utility.set_location(' BEN_PRTT_ANTHR_PL_RT_F CREATE_PRTT_ANTHR_PL_RT ',20);
12340: BEN_PRTT_ANTHR_PL_RT_API.CREATE_PRTT_ANTHR_PL_RT(
12341: --
12342: P_VALIDATE => false
12343: ,P_EFFECTIVE_DATE => l_effective_date

Line 12431: hr_utility.set_location(' BEN_PRTT_ANTHR_PL_RT_F UPDATE_PRTT_ANTHR_PL_RT ',30);

12427: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
12428: --
12429: IF l_update OR l_dml_operation <> 'UPDATE' THEN
12430: --UPD END
12431: hr_utility.set_location(' BEN_PRTT_ANTHR_PL_RT_F UPDATE_PRTT_ANTHR_PL_RT ',30);
12432: BEN_PRTT_ANTHR_PL_RT_API.UPDATE_PRTT_ANTHR_PL_RT(
12433: --
12434: P_VALIDATE => false
12435: ,P_EFFECTIVE_DATE => l_effective_date