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_FOUR dependencies on BEN_ELIG_FL_TM_PT_TM_PRTE_F

Line 26133: -- and tr.where_clause = l_BEN_ELIG_FL_TM_PT_TM_PRTE_F

26129: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26130: pqh_table_route tr
26131: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26132: and cpe.table_route_id = tr.table_route_id
26133: -- and tr.where_clause = l_BEN_ELIG_FL_TM_PT_TM_PRTE_F
26134: and tr.table_alias = l_table_alias
26135: and cpe.number_of_copies = 1 -- ADDITION
26136: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
26137: order by information1, information2; --added for bug: 5151945

Line 26171: from BEN_ELIG_FL_TM_PT_TM_PRTE_F EFP

26167: c_business_group_id number,
26168: c_new_pk_id number) is
26169: select
26170: EFP.elig_fl_tm_pt_tm_prte_id new_value
26171: from BEN_ELIG_FL_TM_PT_TM_PRTE_F EFP
26172: where
26173: EFP.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
26174: EFP.FL_TM_PT_TM_CD = l_FL_TM_PT_TM_CD and
26175: EFP.ORDR_NUM = l_ORDR_NUM and

Line 26183: from BEN_ELIG_FL_TM_PT_TM_PRTE_F EFP1

26179: and effective_end_date ;
26180: --END TEMPIK
26181: /*TEMPIK
26182: and exists ( select null
26183: from BEN_ELIG_FL_TM_PT_TM_PRTE_F EFP1
26184: where
26185: EFP1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
26186: -- Additional Filter
26187: EFP1.FL_TM_PT_TM_CD = l_FL_TM_PT_TM_CD and

Line 26192: from BEN_ELIG_FL_TM_PT_TM_PRTE_F EFP2

26188: EFP1.ORDR_NUM = l_ORDR_NUM and
26189: EFP1.business_group_id = c_business_group_id
26190: and EFP1.effective_start_date <= c_effective_start_date )
26191: and exists ( select null
26192: from BEN_ELIG_FL_TM_PT_TM_PRTE_F EFP2
26193: where
26194: EFP2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
26195: -- Additional Filter
26196: EFP2.FL_TM_PT_TM_CD = l_FL_TM_PT_TM_CD and

Line 26354: (p_base_table_name => 'BEN_ELIG_FL_TM_PT_TM_PRTE_F',

26350: if c_find_EFP_in_target%found then
26351: --
26352: --TEMPIK
26353: l_dt_rec_found := dt_api.check_min_max_dates
26354: (p_base_table_name => 'BEN_ELIG_FL_TM_PT_TM_PRTE_F',
26355: p_base_key_column => 'ELIG_FL_TM_PT_TM_PRTE_ID',
26356: p_base_key_value => l_new_value,
26357: p_from_date => l_min_esd,
26358: p_to_date => l_max_eed );

Line 26414: hr_utility.set_location(' BEN_ELIG_FL_TM_PT_TM_PRTE_F CREATE_ELIG_FL_TM_PT_TM_PRTE ',20);

26410: end if;
26411:
26412: if l_first_rec and not l_update then
26413: -- Call Create routine.
26414: hr_utility.set_location(' BEN_ELIG_FL_TM_PT_TM_PRTE_F CREATE_ELIG_FL_TM_PT_TM_PRTE ',20);
26415: BEN_ELIG_FL_TM_PT_TM_PRTE_API.CREATE_ELIG_FL_TM_PT_TM_PRTE(
26416: --
26417: P_VALIDATE => false
26418: ,P_EFFECTIVE_DATE => l_effective_date

Line 26487: hr_utility.set_location(' BEN_ELIG_FL_TM_PT_TM_PRTE_F UPDATE_ELIG_FL_TM_PT_TM_PRTE ',30);

26483: else
26484: --
26485: -- Call Update routine for the pk_id created in prev run .
26486: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
26487: hr_utility.set_location(' BEN_ELIG_FL_TM_PT_TM_PRTE_F UPDATE_ELIG_FL_TM_PT_TM_PRTE ',30);
26488: --UPD START
26489: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
26490: --
26491: if l_update then