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 17910: -- and tr.where_clause = l_BEN_ENRT_PERD_FOR_PL_F

17906: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17907: pqh_table_route tr
17908: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17909: and cpe.table_route_id = tr.table_route_id
17910: -- and tr.where_clause = l_BEN_ENRT_PERD_FOR_PL_F
17911: and tr.table_alias = l_table_alias
17912: and cpe.number_of_copies = 1 -- ADDITION
17913: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
17914: order by information1, information2; --added for bug: 5151945

Line 17949: from BEN_ENRT_PERD_FOR_PL_F ERP

17945: c_business_group_id number,
17946: c_new_pk_id number) is
17947: select
17948: ERP.enrt_perd_for_pl_id new_value
17949: from BEN_ENRT_PERD_FOR_PL_F ERP
17950: where
17951: nvl(ERP.ENRT_PERD_ID,-999) = nvl(l_ENRT_PERD_ID,-999) and
17952: nvl(ERP.LEE_RSN_ID,-999) = nvl(l_LEE_RSN_ID,-999) and
17953: nvl(ERP.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 17963: from BEN_ENRT_PERD_FOR_PL_F ERP1

17959: --END TEMPIK
17960: /*TEMPIK
17961:
17962: and exists ( select null
17963: from BEN_ENRT_PERD_FOR_PL_F ERP1
17964: where
17965: nvl(ERP1.ENRT_PERD_ID,-999) = nvl(l_ENRT_PERD_ID, -999) and
17966: nvl(ERP1.LEE_RSN_ID,-999) = nvl(l_LEE_RSN_ID, -999) and
17967: nvl(ERP1.PL_ID,-999) = nvl(l_PL_ID, -999) and

Line 17971: from BEN_ENRT_PERD_FOR_PL_F ERP2

17967: nvl(ERP1.PL_ID,-999) = nvl(l_PL_ID, -999) and
17968: ERP1.business_group_id = c_business_group_id
17969: and ERP1.effective_start_date <= c_effective_start_date )
17970: and exists ( select null
17971: from BEN_ENRT_PERD_FOR_PL_F ERP2
17972: where
17973: nvl(ERP2.ENRT_PERD_ID,-999) = nvl(l_ENRT_PERD_ID, -999) and
17974: nvl(ERP2.LEE_RSN_ID,-999) = nvl(l_LEE_RSN_ID, -999) and
17975: nvl(ERP2.PL_ID,-999) = nvl(l_PL_ID, -999) and

Line 18124: (p_base_table_name => 'BEN_ENRT_PERD_FOR_PL_F',

18120: if c_find_ERP_in_target%found then
18121: --
18122: --TEMPIK
18123: l_dt_rec_found := dt_api.check_min_max_dates
18124: (p_base_table_name => 'BEN_ENRT_PERD_FOR_PL_F',
18125: p_base_key_column => 'ENRT_PERD_FOR_PL_ID',
18126: p_base_key_value => l_new_value,
18127: p_from_date => l_min_esd,
18128: p_to_date => l_max_eed );

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

18179: end if;
18180:
18181: if l_first_rec and not l_update then
18182: -- Call Create routine.
18183: hr_utility.set_location(' BEN_ENRT_PERD_FOR_PL_F CREATE_ENRT_PERD_FOR_PL ',20);
18184: BEN_ENRT_PERD_FOR_PL_API.CREATE_ENRT_PERD_FOR_PL(
18185: --
18186: P_VALIDATE => false
18187: ,P_EFFECTIVE_DATE => l_effective_date

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

18253: else
18254: --
18255: -- Call Update routine for the pk_id created in prev run .
18256: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
18257: hr_utility.set_location(' BEN_ENRT_PERD_FOR_PL_F UPDATE_ENRT_PERD_FOR_PL ',30);
18258: --UPD START
18259: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
18260: --
18261: if l_update then