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_FIVE dependencies on BEN_ELIG_PSTL_CD_R_RNG_CVG_F

Line 12765: -- and tr.where_clause = l_BEN_ELIG_PSTL_CD_R_RNG_CVG_F

12761: from ben_copy_entity_results cpe,
12762: pqh_table_route tr
12763: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12764: and cpe.table_route_id = tr.table_route_id
12765: -- and tr.where_clause = l_BEN_ELIG_PSTL_CD_R_RNG_CVG_F
12766: and tr.table_alias = l_table_alias
12767: and cpe.number_of_copies = 1 -- ADDITION
12768: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12769: order by information1, information2; --added for bug: 5151945

Line 12803: from BEN_ELIG_PSTL_CD_R_RNG_CVG_F EPL

12799: c_business_group_id number,
12800: c_new_pk_id number) is
12801: select
12802: EPL.elig_pstl_cd_r_rng_cvg_id new_value
12803: from BEN_ELIG_PSTL_CD_R_RNG_CVG_F EPL
12804: where
12805: nvl(EPL.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
12806: nvl(EPL.PSTL_ZIP_RNG_ID,-999) = nvl(l_PSTL_ZIP_RNG_ID,-999) and
12807: EPL.business_group_id = c_business_group_id

Line 12815: from BEN_ELIG_PSTL_CD_R_RNG_CVG_F EPL1

12811: and effective_end_date ;
12812: --END TEMPIK
12813: /*TEMPIK
12814: and exists ( select null
12815: from BEN_ELIG_PSTL_CD_R_RNG_CVG_F EPL1
12816: where
12817: nvl(EPL1.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
12818: nvl(EPL1.PSTL_ZIP_RNG_ID,-999) = nvl(l_PSTL_ZIP_RNG_ID,-999) and
12819: EPL1.business_group_id = c_business_group_id

Line 12822: from BEN_ELIG_PSTL_CD_R_RNG_CVG_F EPL2

12818: nvl(EPL1.PSTL_ZIP_RNG_ID,-999) = nvl(l_PSTL_ZIP_RNG_ID,-999) and
12819: EPL1.business_group_id = c_business_group_id
12820: and EPL1.effective_start_date <= c_effective_start_date )
12821: and exists ( select null
12822: from BEN_ELIG_PSTL_CD_R_RNG_CVG_F EPL2
12823: where
12824: nvl(EPL2.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
12825: nvl(EPL2.PSTL_ZIP_RNG_ID,-999) = nvl(l_PSTL_ZIP_RNG_ID,-999) and
12826: EPL2.business_group_id = c_business_group_id

Line 12959: (p_base_table_name => 'BEN_ELIG_PSTL_CD_R_RNG_CVG_F',

12955: fetch c_find_EPL_in_target into l_new_value ;
12956: if c_find_EPL_in_target%found then
12957: --TEMPIK
12958: l_dt_rec_found := dt_api.check_min_max_dates
12959: (p_base_table_name => 'BEN_ELIG_PSTL_CD_R_RNG_CVG_F',
12960: p_base_key_column => 'ELIG_PSTL_CD_R_RNG_CVG_ID',
12961: p_base_key_value => l_new_value,
12962: p_from_date => l_min_esd,
12963: p_to_date => l_max_eed );

Line 13021: hr_utility.set_location(' BEN_ELIG_PSTL_CD_R_RNG_CVG_F CREATE_ELIG_PSTL_CD_CVG ',20);

13017:
13018: --if l_first_rec then
13019: if l_first_rec and not l_update then
13020: -- Call Create routine.
13021: hr_utility.set_location(' BEN_ELIG_PSTL_CD_R_RNG_CVG_F CREATE_ELIG_PSTL_CD_CVG ',20);
13022: BEN_ELIG_PSTL_CD_CVG_API.CREATE_ELIG_PSTL_CD_CVG(
13023: --
13024: P_VALIDATE => false
13025: ,P_EFFECTIVE_DATE => l_effective_date

Line 13088: hr_utility.set_location(' BEN_ELIG_PSTL_CD_R_RNG_CVG_F UPDATE_ELIG_PSTL_CD_CVG ',30);

13084: else
13085: --
13086: -- Call Update routine for the pk_id created in prev run .
13087: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
13088: hr_utility.set_location(' BEN_ELIG_PSTL_CD_R_RNG_CVG_F UPDATE_ELIG_PSTL_CD_CVG ',30);
13089: --UPD START
13090: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
13091: --
13092: if l_update then