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_SVC_AREA_F

Line 15516: -- and tr.where_clause = l_BEN_SVC_AREA_F

15512: from ben_copy_entity_results cpe,
15513: pqh_table_route tr
15514: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15515: and cpe.table_route_id = tr.table_route_id
15516: -- and tr.where_clause = l_BEN_SVC_AREA_F
15517: and tr.table_alias = l_table_alias
15518: and cpe.number_of_copies = 1 --ADDITION
15519: group by cpe.information1,cpe.information2,cpe.information3, cpe.information170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
15520: order by information1, information2; --added for bug: 5151945

Line 15554: from BEN_SVC_AREA_F SVA

15550: c_business_group_id number,
15551: c_new_pk_id number) is
15552: select
15553: SVA.svc_area_id new_value
15554: from BEN_SVC_AREA_F SVA
15555: where SVA.name = c_SVA_name
15556: and SVA.business_group_id = c_business_group_id
15557: and SVA.svc_area_id <> c_new_pk_id
15558: --TEMPIK

Line 15564: from BEN_SVC_AREA_F SVA1

15560: and effective_end_date ;
15561: --END TEMPIK
15562: /*TEMPIK
15563: and exists ( select null
15564: from BEN_SVC_AREA_F SVA1
15565: where SVA1.name = c_SVA_name
15566: and SVA1.business_group_id = c_business_group_id
15567: and SVA1.effective_start_date <= c_effective_start_date )
15568: and exists ( select null

Line 15569: from BEN_SVC_AREA_F SVA2

15565: where SVA1.name = c_SVA_name
15566: and SVA1.business_group_id = c_business_group_id
15567: and SVA1.effective_start_date <= c_effective_start_date )
15568: and exists ( select null
15569: from BEN_SVC_AREA_F SVA2
15570: where SVA2.name = c_SVA_name
15571: and SVA2.business_group_id = c_business_group_id
15572: and SVA2.effective_end_date >= c_effective_end_date )
15573: ;

Line 15691: (p_base_table_name => 'BEN_SVC_AREA_F',

15687: if c_find_SVA_in_target%found then
15688: --
15689: --TEMPIK
15690: l_dt_rec_found := dt_api.check_min_max_dates
15691: (p_base_table_name => 'BEN_SVC_AREA_F',
15692: p_base_key_column => 'SVC_AREA_ID',
15693: p_base_key_value => l_new_value,
15694: p_from_date => l_min_esd,
15695: p_to_date => l_max_eed );

Line 15753: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_SVC_AREA_F',l_prefix || r_SVA.information170 || l_suffix);

15749: l_first_rec := true ;
15750: --
15751: end if ;
15752: --
15753: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_SVC_AREA_F',l_prefix || r_SVA.information170 || l_suffix);
15754: --
15755:
15756: l_effective_date := r_SVA.information2;
15757: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 15764: hr_utility.set_location(' BEN_SVC_AREA_F CREATE_SERVICE_AREA ',20);

15760: end if;
15761:
15762: if l_first_rec and not l_update then
15763: -- Call Create routine.
15764: hr_utility.set_location(' BEN_SVC_AREA_F CREATE_SERVICE_AREA ',20);
15765: BEN_SERVICE_AREA_API.CREATE_SERVICE_AREA(
15766: --
15767: P_VALIDATE => false
15768: ,P_EFFECTIVE_DATE => l_effective_date

Line 15856: hr_utility.set_location(' BEN_SVC_AREA_F UPDATE_SERVICE_AREA ',30);

15852: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
15853: --
15854: IF l_update OR l_dml_operation <> 'UPDATE' THEN
15855: --UPD END
15856: hr_utility.set_location(' BEN_SVC_AREA_F UPDATE_SERVICE_AREA ',30);
15857: BEN_SERVICE_AREA_API.UPDATE_SERVICE_AREA(
15858: --
15859: P_VALIDATE => false
15860: ,P_EFFECTIVE_DATE => l_effective_date