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_ONE dependencies on BEN_ELIGY_PRFL_F

Line 10661: -- and tr.where_clause = l_BEN_ELIGY_PRFL_F

10657: from ben_copy_entity_results cpe,
10658: pqh_table_route tr
10659: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10660: and cpe.table_route_id = tr.table_route_id
10661: -- and tr.where_clause = l_BEN_ELIGY_PRFL_F
10662: and tr.table_alias = l_table_alias
10663: and cpe.number_of_copies = 1 --ADDITION
10664: group by cpe.information1,cpe.information2,cpe.information3,
10665: cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode

Line 10700: from BEN_ELIGY_PRFL_F ELP

10696: c_business_group_id number,
10697: c_new_pk_id number) is
10698: select
10699: ELP.eligy_prfl_id new_value
10700: from BEN_ELIGY_PRFL_F ELP
10701: where ELP.name = c_ELP_name
10702: and ELP.business_group_id = c_business_group_id
10703: and ELP.eligy_prfl_id <> c_new_pk_id
10704: --TEMPIK

Line 10710: from BEN_ELIGY_PRFL_F ELP1

10706: and effective_end_date ;
10707: --END TEMPIK
10708: /*TEMPIK
10709: and exists ( select null
10710: from BEN_ELIGY_PRFL_F ELP1
10711: where ELP1.name = c_ELP_name
10712: and ELP1.business_group_id = c_business_group_id
10713: and ELP1.effective_start_date <= c_effective_start_date )
10714: and exists ( select null

Line 10715: from BEN_ELIGY_PRFL_F ELP2

10711: where ELP1.name = c_ELP_name
10712: and ELP1.business_group_id = c_business_group_id
10713: and ELP1.effective_start_date <= c_effective_start_date )
10714: and exists ( select null
10715: from BEN_ELIGY_PRFL_F ELP2
10716: where ELP2.name = c_ELP_name
10717: and ELP2.business_group_id = c_business_group_id
10718: and ELP2.effective_end_date >= c_effective_end_date )
10719: ;

Line 10837: (p_base_table_name => 'BEN_ELIGY_PRFL_F',

10833: if c_find_ELP_in_target%found then
10834: --
10835: --TEMPIK
10836: l_dt_rec_found := dt_api.check_min_max_dates
10837: (p_base_table_name => 'BEN_ELIGY_PRFL_F',
10838: p_base_key_column => 'ELIGY_PRFL_ID',
10839: p_base_key_value => l_new_value,
10840: p_from_date => l_min_esd,
10841: p_to_date => l_max_eed );

Line 10898: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_ELIGY_PRFL_F',l_prefix || r_elp.INFORMATION170 || l_suffix);

10894: l_first_rec := true ;
10895: --
10896: end if ;
10897: --
10898: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_ELIGY_PRFL_F',l_prefix || r_elp.INFORMATION170 || l_suffix);
10899: --
10900:
10901: l_effective_date := r_ELP.information2;
10902: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 10909: hr_utility.set_location(' BEN_ELIGY_PRFL_F CREATE_ELIGY_PROFILE ',20);

10905: end if;
10906:
10907: if l_first_rec and not l_update then
10908: -- Call Create routine.
10909: hr_utility.set_location(' BEN_ELIGY_PRFL_F CREATE_ELIGY_PROFILE ',20);
10910: BEN_ELIGY_PROFILE_API.CREATE_ELIGY_PROFILE(
10911: --
10912: P_VALIDATE => false
10913: ,P_EFFECTIVE_DATE => l_effective_date

Line 11070: hr_utility.set_location(' BEN_ELIGY_PRFL_F UPDATE_ELIGY_PROFILE ',30);

11066: IF l_update OR l_dml_operation <> 'UPDATE' THEN
11067: --UPD END
11068: -- Call Update routine for the pk_id created in prev run .
11069: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
11070: hr_utility.set_location(' BEN_ELIGY_PRFL_F UPDATE_ELIGY_PROFILE ',30);
11071: BEN_ELIGY_PROFILE_API.UPDATE_ELIGY_PROFILE(
11072: --
11073: P_VALIDATE => false
11074: ,P_EFFECTIVE_DATE => l_effective_date