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_CBR_QUALD_BNF_RT_F

Line 10226: -- and tr.where_clause = l_BEN_CBR_QUALD_BNF_RT_F

10222: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10223: pqh_table_route tr
10224: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10225: and cpe.table_route_id = tr.table_route_id
10226: -- and tr.where_clause = l_BEN_CBR_QUALD_BNF_RT_F
10227: and tr.table_alias = l_table_alias
10228: and cpe.number_of_copies = 1 -- ADDITION
10229: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
10230: order by information1, information2; --added for bug: 5151945

Line 10264: from BEN_CBR_QUALD_BNF_RT_F CQR

10260: c_business_group_id number,
10261: c_new_pk_id number) is
10262: select
10263: CQR.cbr_quald_bnf_rt_id new_value
10264: from BEN_CBR_QUALD_BNF_RT_F CQR
10265: where
10266: nvl(CQR.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
10267: nvl(CQR.PTIP_ID,-999) = nvl(l_PTIP_ID,-999) and
10268: CQR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and

Line 10277: from BEN_CBR_QUALD_BNF_RT_F CQR1

10273: and effective_end_date ;
10274: --END TEMPIK
10275: /*TEMPIK
10276: and exists ( select null
10277: from BEN_CBR_QUALD_BNF_RT_F CQR1
10278: where
10279: nvl(CQR1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
10280: nvl(CQR1.PTIP_ID,-999) = nvl(l_PTIP_ID,-999) and
10281: CQR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and

Line 10285: from BEN_CBR_QUALD_BNF_RT_F CQR2

10281: CQR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
10282: CQR1.business_group_id = c_business_group_id
10283: and CQR1.effective_start_date <= c_effective_start_date )
10284: and exists ( select null
10285: from BEN_CBR_QUALD_BNF_RT_F CQR2
10286: where
10287: nvl(CQR2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
10288: nvl(CQR2.PTIP_ID,-999) = nvl(l_PTIP_ID,-999) and
10289: CQR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and

Line 10429: (p_base_table_name => 'BEN_CBR_QUALD_BNF_RT_F',

10425: if c_find_CQR_in_target%found then
10426: --
10427: --TEMPIK
10428: l_dt_rec_found := dt_api.check_min_max_dates
10429: (p_base_table_name => 'BEN_CBR_QUALD_BNF_RT_F',
10430: p_base_key_column => 'CBR_QUALD_BNF_RT_ID',
10431: p_base_key_value => l_new_value,
10432: p_from_date => l_min_esd,
10433: p_to_date => l_max_eed );

Line 10487: hr_utility.set_location(' BEN_CBR_QUALD_BNF_RT_F CREATE_CBR_QUALD_BNF_RT ',20);

10483: end if;
10484:
10485: if l_first_rec and not l_update then
10486: -- Call Create routine.
10487: hr_utility.set_location(' BEN_CBR_QUALD_BNF_RT_F CREATE_CBR_QUALD_BNF_RT ',20);
10488: BEN_CBR_QUALD_BNF_RT_API.CREATE_CBR_QUALD_BNF_RT(
10489: --
10490: P_VALIDATE => false
10491: ,P_EFFECTIVE_DATE => l_effective_date

Line 10580: hr_utility.set_location(' BEN_CBR_QUALD_BNF_RT_F UPDATE_CBR_QUALD_BNF_RT ',30);

10576: --
10577: IF l_update OR l_dml_operation <> 'UPDATE' THEN
10578: --UPD END
10579: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
10580: hr_utility.set_location(' BEN_CBR_QUALD_BNF_RT_F UPDATE_CBR_QUALD_BNF_RT ',30);
10581: BEN_CBR_QUALD_BNF_RT_API.UPDATE_CBR_QUALD_BNF_RT(
10582: --
10583: P_VALIDATE => false
10584: ,P_EFFECTIVE_DATE => l_effective_date