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_AGE_CVG_F

Line 10831: -- and tr.where_clause = l_BEN_ELIG_AGE_CVG_F

10827: from ben_copy_entity_results cpe,
10828: pqh_table_route tr
10829: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10830: and cpe.table_route_id = tr.table_route_id
10831: -- and tr.where_clause = l_BEN_ELIG_AGE_CVG_F
10832: and tr.table_alias = l_table_alias
10833: and cpe.number_of_copies = 1 -- ADDITION
10834: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
10835: order by information1, information2; --added for bug: 5151945

Line 10869: from BEN_ELIG_AGE_CVG_F EAC

10865: c_business_group_id number,
10866: c_new_pk_id number) is
10867: select
10868: EAC.elig_age_cvg_id new_value
10869: from BEN_ELIG_AGE_CVG_F EAC
10870: where
10871: nvl(EAC.AGE_FCTR_ID,-999) = nvl(l_AGE_FCTR_ID,-999) and
10872: nvl(EAC.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
10873: EAC.business_group_id = c_business_group_id

Line 10881: from BEN_ELIG_AGE_CVG_F EAC1

10877: and effective_end_date ;
10878: --END TEMPIK
10879: /*TEMPIK
10880: and exists ( select null
10881: from BEN_ELIG_AGE_CVG_F EAC1
10882: where
10883: nvl(EAC1.AGE_FCTR_ID,-999) = nvl(l_AGE_FCTR_ID,-999) and
10884: nvl(EAC1.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
10885: EAC1.business_group_id = c_business_group_id

Line 10888: from BEN_ELIG_AGE_CVG_F EAC2

10884: nvl(EAC1.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
10885: EAC1.business_group_id = c_business_group_id
10886: and EAC1.effective_start_date <= c_effective_start_date )
10887: and exists ( select null
10888: from BEN_ELIG_AGE_CVG_F EAC2
10889: where
10890: nvl(EAC2.AGE_FCTR_ID,-999) = nvl(l_AGE_FCTR_ID,-999) and
10891: nvl(EAC2.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
10892: EAC2.business_group_id = c_business_group_id

Line 11037: (p_base_table_name => 'BEN_ELIG_AGE_CVG_F',

11033: if c_find_EAC_in_target%found then
11034: --
11035: --TEMPIK
11036: l_dt_rec_found := dt_api.check_min_max_dates
11037: (p_base_table_name => 'BEN_ELIG_AGE_CVG_F',
11038: p_base_key_column => 'ELIG_AGE_CVG_ID',
11039: p_base_key_value => l_new_value,
11040: p_from_date => l_min_esd,
11041: p_to_date => l_max_eed );

Line 11102: hr_utility.set_location(' BEN_ELIG_AGE_CVG_F CREATE_ELIG_AGE_CVG ',20);

11098: --if l_first_rec then
11099: if l_first_rec and not l_update then
11100:
11101: -- Call Create routine.
11102: hr_utility.set_location(' BEN_ELIG_AGE_CVG_F CREATE_ELIG_AGE_CVG ',20);
11103: BEN_ELIG_AGE_CVG_API.CREATE_ELIG_AGE_CVG(
11104: --
11105: P_VALIDATE => false
11106: ,P_EFFECTIVE_DATE => l_effective_date

Line 11172: hr_utility.set_location(' BEN_ELIG_AGE_CVG_F UPDATE_ELIG_AGE_CVG ',30);

11168: else
11169: --
11170: -- Call Update routine for the pk_id created in prev run .
11171: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
11172: hr_utility.set_location(' BEN_ELIG_AGE_CVG_F UPDATE_ELIG_AGE_CVG ',30);
11173: --UPD START
11174: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
11175: --
11176: if l_update then