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_MRTL_STAT_CVG_F

Line 12268: l_MRTL_STAT_CD ben_elig_mrtl_stat_cvg_f.mrtl_stat_cd%type;

12264: --
12265: l_CVG_STRT_RL number;
12266: l_CVG_THRU_RL number;
12267: l_DPNT_CVG_ELIGY_PRFL_ID number;
12268: l_MRTL_STAT_CD ben_elig_mrtl_stat_cvg_f.mrtl_stat_cd%type;
12269: cursor c_unique_EMS(l_table_alias varchar2) is
12270: select distinct cpe.information1,
12271: cpe.information2,
12272: cpe.information3,

Line 12280: -- and tr.where_clause = l_BEN_ELIG_MRTL_STAT_CVG_F

12276: from ben_copy_entity_results cpe,
12277: pqh_table_route tr
12278: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12279: and cpe.table_route_id = tr.table_route_id
12280: -- and tr.where_clause = l_BEN_ELIG_MRTL_STAT_CVG_F
12281: and tr.table_alias = l_table_alias
12282: and cpe.number_of_copies = 1 -- ADDITION
12283: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12284: order by information1, information2; --added for bug: 5151945

Line 12318: from BEN_ELIG_MRTL_STAT_CVG_F EMS

12314: c_business_group_id number,
12315: c_new_pk_id number) is
12316: select
12317: EMS.elig_mrtl_stat_cvg_id new_value
12318: from BEN_ELIG_MRTL_STAT_CVG_F EMS
12319: where
12320: nvl(EMS.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
12321: EMS.MRTL_STAT_CD = l_MRTL_STAT_CD and
12322: EMS.business_group_id = c_business_group_id

Line 12330: from BEN_ELIG_MRTL_STAT_CVG_F EMS1

12326: and effective_end_date ;
12327: --END TEMPIK
12328: /*TEMPIK
12329: and exists ( select null
12330: from BEN_ELIG_MRTL_STAT_CVG_F EMS1
12331: where
12332: nvl(EMS1.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
12333: EMS1.MRTL_STAT_CD = l_MRTL_STAT_CD and
12334: EMS1.business_group_id = c_business_group_id

Line 12337: from BEN_ELIG_MRTL_STAT_CVG_F EMS2

12333: EMS1.MRTL_STAT_CD = l_MRTL_STAT_CD and
12334: EMS1.business_group_id = c_business_group_id
12335: and EMS1.effective_start_date <= c_effective_start_date )
12336: and exists ( select null
12337: from BEN_ELIG_MRTL_STAT_CVG_F EMS2
12338: where
12339: nvl(EMS2.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
12340: EMS2.MRTL_STAT_CD = l_MRTL_STAT_CD and
12341: EMS2.business_group_id = c_business_group_id

Line 12488: (p_base_table_name => 'BEN_ELIG_MRTL_STAT_CVG_F',

12484: if c_find_EMS_in_target%found then
12485: --
12486: --TEMPIK
12487: l_dt_rec_found := dt_api.check_min_max_dates
12488: (p_base_table_name => 'BEN_ELIG_MRTL_STAT_CVG_F',
12489: p_base_key_column => 'ELIG_MRTL_STAT_CVG_ID',
12490: p_base_key_value => l_new_value,
12491: p_from_date => l_min_esd,
12492: p_to_date => l_max_eed );

Line 12551: hr_utility.set_location(' BEN_ELIG_MRTL_STAT_CVG_F CREATE_ELIG_MRTL_STAT_CVG ',20);

12547: --if l_first_rec then
12548: if l_first_rec and not l_update then
12549:
12550: -- Call Create routine.
12551: hr_utility.set_location(' BEN_ELIG_MRTL_STAT_CVG_F CREATE_ELIG_MRTL_STAT_CVG ',20);
12552: BEN_ELIG_MRTL_STAT_CVG_API.CREATE_ELIG_MRTL_STAT_CVG(
12553: --
12554: P_VALIDATE => false
12555: ,P_EFFECTIVE_DATE => l_effective_date

Line 12620: hr_utility.set_location(' BEN_ELIG_MRTL_STAT_CVG_F UPDATE_ELIG_MRTL_STAT_CVG ',30);

12616: else
12617: --
12618: -- Call Update routine for the pk_id created in prev run .
12619: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
12620: hr_utility.set_location(' BEN_ELIG_MRTL_STAT_CVG_F UPDATE_ELIG_MRTL_STAT_CVG ',30);
12621: --UPD START
12622: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
12623: --
12624: if l_update then