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_HRS_WKD_IN_PERD_RT_F

Line 22371: -- and tr.where_clause = l_BEN_HRS_WKD_IN_PERD_RT_F

22367: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22368: pqh_table_route tr
22369: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22370: and cpe.table_route_id = tr.table_route_id
22371: -- and tr.where_clause = l_BEN_HRS_WKD_IN_PERD_RT_F
22372: and tr.table_alias = l_table_alias
22373: and cpe.number_of_copies = 1 -- ADDITION
22374: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
22375: order by information1, information2; --added for bug: 5151945

Line 22409: from BEN_HRS_WKD_IN_PERD_RT_F HWR

22405: c_business_group_id number,
22406: c_new_pk_id number) is
22407: select
22408: HWR.hrs_wkd_in_perd_rt_id new_value
22409: from BEN_HRS_WKD_IN_PERD_RT_F HWR
22410: where
22411: HWR.HRS_WKD_IN_PERD_FCTR_ID = l_HRS_WKD_IN_PERD_FCTR_ID and
22412: HWR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
22413: HWR.ORDR_NUM = l_ORDR_NUM and

Line 22422: from BEN_HRS_WKD_IN_PERD_RT_F HWR1

22418: and effective_end_date ;
22419: --END TEMPIK
22420: /*TEMPIK
22421: and exists ( select null
22422: from BEN_HRS_WKD_IN_PERD_RT_F HWR1
22423: where
22424: HWR1.HRS_WKD_IN_PERD_FCTR_ID = l_HRS_WKD_IN_PERD_FCTR_ID and
22425: HWR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
22426: HWR1.ORDR_NUM = l_ORDR_NUM and

Line 22430: from BEN_HRS_WKD_IN_PERD_RT_F HWR2

22426: HWR1.ORDR_NUM = l_ORDR_NUM and
22427: HWR1.business_group_id = c_business_group_id
22428: and HWR1.effective_start_date <= c_effective_start_date )
22429: and exists ( select null
22430: from BEN_HRS_WKD_IN_PERD_RT_F HWR2
22431: where
22432: HWR2.HRS_WKD_IN_PERD_FCTR_ID = l_HRS_WKD_IN_PERD_FCTR_ID and
22433: HWR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
22434: HWR2.ORDR_NUM = l_ORDR_NUM and

Line 22569: (p_base_table_name => 'BEN_HRS_WKD_IN_PERD_RT_F',

22565: if c_find_HWR_in_target%found then
22566: --
22567: --TEMPIK
22568: l_dt_rec_found := dt_api.check_min_max_dates
22569: (p_base_table_name => 'BEN_HRS_WKD_IN_PERD_RT_F',
22570: p_base_key_column => 'HRS_WKD_IN_PERD_RT_ID',
22571: p_base_key_value => l_new_value,
22572: p_from_date => l_min_esd,
22573: p_to_date => l_max_eed );

Line 22627: hr_utility.set_location(' BEN_HRS_WKD_IN_PERD_RT_F CREATE_HRS_WKD_IN_PERIOD_RT ',20);

22623: end if;
22624:
22625: if l_first_rec and not l_update then
22626: -- Call Create routine.
22627: hr_utility.set_location(' BEN_HRS_WKD_IN_PERD_RT_F CREATE_HRS_WKD_IN_PERIOD_RT ',20);
22628: BEN_HRS_WKD_IN_PERIOD_RT_API.CREATE_HRS_WKD_IN_PERIOD_RT(
22629: --
22630: P_VALIDATE => false
22631: ,P_EFFECTIVE_DATE => l_effective_date

Line 22719: hr_utility.set_location(' BEN_HRS_WKD_IN_PERD_RT_F UPDATE_HRS_WKD_IN_PERIOD_RT ',30);

22715: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
22716: --
22717: IF l_update OR l_dml_operation <> 'UPDATE' THEN
22718: --UPD END
22719: hr_utility.set_location(' BEN_HRS_WKD_IN_PERD_RT_F UPDATE_HRS_WKD_IN_PERIOD_RT ',30);
22720: BEN_HRS_WKD_IN_PERIOD_RT_API.UPDATE_HRS_WKD_IN_PERIOD_RT(
22721: --
22722: P_VALIDATE => false
22723: ,P_EFFECTIVE_DATE => l_effective_date