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_DSBLD_RT_F

Line 6411: -- and tr.where_clause = l_BEN_DSBLD_RT_F

6407: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6408: pqh_table_route tr
6409: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6410: and cpe.table_route_id = tr.table_route_id
6411: -- and tr.where_clause = l_BEN_DSBLD_RT_F
6412: and tr.table_alias = l_table_alias
6413: and cpe.number_of_copies = 1 -- ADDITION
6414: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
6415: order by information1, information2; --added for bug: 5151945

Line 6449: from BEN_DSBLD_RT_F DBR

6445: c_business_group_id number,
6446: c_new_pk_id number) is
6447: select
6448: DBR.dsbld_rt_id new_value
6449: from BEN_DSBLD_RT_F DBR
6450: where
6451: DBR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
6452: DBR.DSBLD_CD = l_DSBLD_CD and
6453: DBR.ORDR_NUM = l_ORDR_NUM and

Line 6462: from BEN_DSBLD_RT_F DBR1

6458: and effective_end_date ;
6459: --END TEMPIK
6460: /*TEMPIK
6461: and exists ( select null
6462: from BEN_DSBLD_RT_F DBR1
6463: where
6464: DBR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
6465: DBR1.DSBLD_CD = l_DSBLD_CD and
6466: DBR1.ORDR_NUM = l_ORDR_NUM and

Line 6470: from BEN_DSBLD_RT_F DBR2

6466: DBR1.ORDR_NUM = l_ORDR_NUM and
6467: DBR1.business_group_id = c_business_group_id
6468: and DBR1.effective_start_date <= c_effective_start_date )
6469: and exists ( select null
6470: from BEN_DSBLD_RT_F DBR2
6471: where
6472: DBR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
6473: DBR2.DSBLD_CD = l_DSBLD_CD and
6474: DBR2.ORDR_NUM = l_ORDR_NUM and

Line 6609: (p_base_table_name => 'BEN_DSBLD_RT_F',

6605: if c_find_DBR_in_target%found then
6606: --
6607: --TEMPIK
6608: l_dt_rec_found := dt_api.check_min_max_dates
6609: (p_base_table_name => 'BEN_DSBLD_RT_F',
6610: p_base_key_column => 'DSBLD_RT_ID',
6611: p_base_key_value => l_new_value,
6612: p_from_date => l_min_esd,
6613: p_to_date => l_max_eed );

Line 6667: hr_utility.set_location(' BEN_DSBLD_RT_F CREATE_DSBLD_RT ',20);

6663: end if;
6664:
6665: if l_first_rec and not l_update then
6666: -- Call Create routine.
6667: hr_utility.set_location(' BEN_DSBLD_RT_F CREATE_DSBLD_RT ',20);
6668: BEN_DSBLD_RT_API.CREATE_DSBLD_RT(
6669: --
6670: P_VALIDATE => false
6671: ,P_EFFECTIVE_DATE => l_effective_date

Line 6759: hr_utility.set_location(' BEN_DSBLD_RT_F UPDATE_DSBLD_RT ',30);

6755: --
6756: IF l_update OR l_dml_operation <> 'UPDATE' THEN
6757: --UPD END
6758: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
6759: hr_utility.set_location(' BEN_DSBLD_RT_F UPDATE_DSBLD_RT ',30);
6760: BEN_DSBLD_RT_API.UPDATE_DSBLD_RT(
6761: --
6762: P_VALIDATE => false
6763: ,P_EFFECTIVE_DATE => l_effective_date