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_TWO dependencies on BEN_ENRT_PERD_FOR_PL_F

Line 17823: -- and tr.where_clause = l_BEN_ENRT_PERD_FOR_PL_F

17819: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17820: pqh_table_route tr
17821: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17822: and cpe.table_route_id = tr.table_route_id
17823: -- and tr.where_clause = l_BEN_ENRT_PERD_FOR_PL_F
17824: and tr.table_alias = l_table_alias
17825: and cpe.number_of_copies = 1 -- ADDITION
17826: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
17827: order by information1, information2; --added for bug: 5151945

Line 17862: from BEN_ENRT_PERD_FOR_PL_F ERP

17858: c_business_group_id number,
17859: c_new_pk_id number) is
17860: select
17861: ERP.enrt_perd_for_pl_id new_value
17862: from BEN_ENRT_PERD_FOR_PL_F ERP
17863: where
17864: nvl(ERP.ENRT_PERD_ID,-999) = nvl(l_ENRT_PERD_ID,-999) and
17865: nvl(ERP.LEE_RSN_ID,-999) = nvl(l_LEE_RSN_ID,-999) and
17866: nvl(ERP.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 17876: from BEN_ENRT_PERD_FOR_PL_F ERP1

17872: --END TEMPIK
17873: /*TEMPIK
17874:
17875: and exists ( select null
17876: from BEN_ENRT_PERD_FOR_PL_F ERP1
17877: where
17878: nvl(ERP1.ENRT_PERD_ID,-999) = nvl(l_ENRT_PERD_ID, -999) and
17879: nvl(ERP1.LEE_RSN_ID,-999) = nvl(l_LEE_RSN_ID, -999) and
17880: nvl(ERP1.PL_ID,-999) = nvl(l_PL_ID, -999) and

Line 17884: from BEN_ENRT_PERD_FOR_PL_F ERP2

17880: nvl(ERP1.PL_ID,-999) = nvl(l_PL_ID, -999) and
17881: ERP1.business_group_id = c_business_group_id
17882: and ERP1.effective_start_date <= c_effective_start_date )
17883: and exists ( select null
17884: from BEN_ENRT_PERD_FOR_PL_F ERP2
17885: where
17886: nvl(ERP2.ENRT_PERD_ID,-999) = nvl(l_ENRT_PERD_ID, -999) and
17887: nvl(ERP2.LEE_RSN_ID,-999) = nvl(l_LEE_RSN_ID, -999) and
17888: nvl(ERP2.PL_ID,-999) = nvl(l_PL_ID, -999) and

Line 18037: (p_base_table_name => 'BEN_ENRT_PERD_FOR_PL_F',

18033: if c_find_ERP_in_target%found then
18034: --
18035: --TEMPIK
18036: l_dt_rec_found := dt_api.check_min_max_dates
18037: (p_base_table_name => 'BEN_ENRT_PERD_FOR_PL_F',
18038: p_base_key_column => 'ENRT_PERD_FOR_PL_ID',
18039: p_base_key_value => l_new_value,
18040: p_from_date => l_min_esd,
18041: p_to_date => l_max_eed );

Line 18096: hr_utility.set_location(' BEN_ENRT_PERD_FOR_PL_F CREATE_ENRT_PERD_FOR_PL ',20);

18092: end if;
18093:
18094: if l_first_rec and not l_update then
18095: -- Call Create routine.
18096: hr_utility.set_location(' BEN_ENRT_PERD_FOR_PL_F CREATE_ENRT_PERD_FOR_PL ',20);
18097: BEN_ENRT_PERD_FOR_PL_API.CREATE_ENRT_PERD_FOR_PL(
18098: --
18099: P_VALIDATE => false
18100: ,P_EFFECTIVE_DATE => l_effective_date

Line 18170: hr_utility.set_location(' BEN_ENRT_PERD_FOR_PL_F UPDATE_ENRT_PERD_FOR_PL ',30);

18166: else
18167: --
18168: -- Call Update routine for the pk_id created in prev run .
18169: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
18170: hr_utility.set_location(' BEN_ENRT_PERD_FOR_PL_F UPDATE_ENRT_PERD_FOR_PL ',30);
18171: --UPD START
18172: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
18173: --
18174: if l_update then