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_NO_OTHR_CVG_RT_F

Line 13005: -- and tr.where_clause = l_BEN_NO_OTHR_CVG_RT_F

13001: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13002: pqh_table_route tr
13003: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13004: and cpe.table_route_id = tr.table_route_id
13005: -- and tr.where_clause = l_BEN_NO_OTHR_CVG_RT_F
13006: and tr.table_alias = l_table_alias
13007: and cpe.number_of_copies = 1 -- ADDITION
13008: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
13009: order by information1, information2; --added for bug: 5151945

Line 13043: from BEN_NO_OTHR_CVG_RT_F NOC

13039: c_business_group_id number,
13040: c_new_pk_id number) is
13041: select
13042: NOC.no_othr_cvg_rt_id new_value
13043: from BEN_NO_OTHR_CVG_RT_F NOC
13044: where
13045: NOC.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
13046: NOC.COORD_BEN_NO_CVG_FLAG = l_COORD_BEN_NO_CVG_FLAG and
13047: NOC.business_group_id = c_business_group_id

Line 13055: from BEN_NO_OTHR_CVG_RT_F NOC1

13051: and effective_end_date ;
13052: --END TEMPIK
13053: /*TEMPIK
13054: and exists ( select null
13055: from BEN_NO_OTHR_CVG_RT_F NOC1
13056: where
13057: NOC1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
13058: NOC1.COORD_BEN_NO_CVG_FLAG = l_COORD_BEN_NO_CVG_FLAG and
13059: NOC1.business_group_id = c_business_group_id

Line 13062: from BEN_NO_OTHR_CVG_RT_F NOC2

13058: NOC1.COORD_BEN_NO_CVG_FLAG = l_COORD_BEN_NO_CVG_FLAG and
13059: NOC1.business_group_id = c_business_group_id
13060: and NOC1.effective_start_date <= c_effective_start_date )
13061: and exists ( select null
13062: from BEN_NO_OTHR_CVG_RT_F NOC2
13063: where
13064: NOC2.VRBL_RT_PRFL_ID =l_VRBL_RT_PRFL_ID and
13065: NOC2.COORD_BEN_NO_CVG_FLAG = l_COORD_BEN_NO_CVG_FLAG and
13066: NOC2.business_group_id = c_business_group_id

Line 13199: (p_base_table_name => 'BEN_NO_OTHR_CVG_RT_F',

13195: if c_find_NOC_in_target%found then
13196: --
13197: --TEMPIK
13198: l_dt_rec_found := dt_api.check_min_max_dates
13199: (p_base_table_name => 'BEN_NO_OTHR_CVG_RT_F',
13200: p_base_key_column => 'NO_OTHR_CVG_RT_ID',
13201: p_base_key_value => l_new_value,
13202: p_from_date => l_min_esd,
13203: p_to_date => l_max_eed );

Line 13257: hr_utility.set_location(' BEN_NO_OTHR_CVG_RT_F CREATE_NO_OTHR_CVG_RT ',20);

13253: end if;
13254:
13255: if l_first_rec and not l_update then
13256: -- Call Create routine.
13257: hr_utility.set_location(' BEN_NO_OTHR_CVG_RT_F CREATE_NO_OTHR_CVG_RT ',20);
13258: BEN_NO_OTHR_CVG_RT_API.CREATE_NO_OTHR_CVG_RT(
13259: --
13260: P_VALIDATE => false
13261: ,P_EFFECTIVE_DATE => l_effective_date

Line 13347: hr_utility.set_location(' BEN_NO_OTHR_CVG_RT_F UPDATE_NO_OTHR_CVG_RT ',30);

13343: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
13344: --
13345: IF l_update OR l_dml_operation <> 'UPDATE' THEN
13346: --UPD END
13347: hr_utility.set_location(' BEN_NO_OTHR_CVG_RT_F UPDATE_NO_OTHR_CVG_RT ',30);
13348: BEN_NO_OTHR_CVG_RT_API.UPDATE_NO_OTHR_CVG_RT(
13349: --
13350: P_VALIDATE => false
13351: ,P_EFFECTIVE_DATE => l_effective_date