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_THREE dependencies on BEN_PER_TYP_RT_F

Line 5466: -- and tr.where_clause = l_BEN_PER_TYP_RT_F

5462: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5463: pqh_table_route tr
5464: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5465: and cpe.table_route_id = tr.table_route_id
5466: -- and tr.where_clause = l_BEN_PER_TYP_RT_F
5467: and tr.table_alias = l_table_alias
5468: and cpe.number_of_copies = 1 -- ADDITION
5469: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
5470: order by information1, information2; --added for bug: 5151945

Line 5504: from BEN_PER_TYP_RT_F PTR

5500: c_business_group_id number,
5501: c_new_pk_id number) is
5502: select
5503: PTR.per_typ_rt_id new_value
5504: from BEN_PER_TYP_RT_F PTR
5505: where
5506: PTR.PERSON_TYPE_ID = l_PERSON_TYPE_ID and
5507: PTR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
5508: PTR.ORDR_NUM = l_ORDR_NUM and

Line 5517: from BEN_PER_TYP_RT_F PTR1

5513: and effective_end_date ;
5514: --END TEMPIK
5515: /*TEMPIK
5516: and exists ( select null
5517: from BEN_PER_TYP_RT_F PTR1
5518: where
5519: PTR1.PERSON_TYPE_ID = l_PERSON_TYPE_ID and
5520: PTR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
5521: PTR1.ORDR_NUM = l_ORDR_NUM and

Line 5525: from BEN_PER_TYP_RT_F PTR2

5521: PTR1.ORDR_NUM = l_ORDR_NUM and
5522: PTR1.business_group_id = c_business_group_id
5523: and PTR1.effective_start_date <= c_effective_start_date )
5524: and exists ( select null
5525: from BEN_PER_TYP_RT_F PTR2
5526: where
5527: PTR2.PERSON_TYPE_ID = l_PERSON_TYPE_ID and
5528: PTR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
5529: PTR2.ORDR_NUM = l_ORDR_NUM and

Line 5679: (p_base_table_name => 'BEN_PER_TYP_RT_F',

5675: if c_find_PTR_in_target%found then
5676: --
5677: --TEMPIK
5678: l_dt_rec_found := dt_api.check_min_max_dates
5679: (p_base_table_name => 'BEN_PER_TYP_RT_F',
5680: p_base_key_column => 'PER_TYP_RT_ID',
5681: p_base_key_value => l_new_value,
5682: p_from_date => l_min_esd,
5683: p_to_date => l_max_eed );

Line 5737: hr_utility.set_location(' BEN_PER_TYP_RT_F CREATE_PERSON_TYPE_RATE ',20);

5733: end if;
5734:
5735: if l_first_rec and not l_update then
5736: -- Call Create routine.
5737: hr_utility.set_location(' BEN_PER_TYP_RT_F CREATE_PERSON_TYPE_RATE ',20);
5738: BEN_PERSON_TYPE_RATE_API.CREATE_PERSON_TYPE_RATE(
5739: --
5740: P_VALIDATE => false
5741: ,P_EFFECTIVE_DATE => l_effective_date

Line 5829: hr_utility.set_location(' BEN_PER_TYP_RT_F UPDATE_PERSON_TYPE_RATE ',30);

5825: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
5826: --
5827: IF l_update OR l_dml_operation <> 'UPDATE' THEN
5828: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
5829: hr_utility.set_location(' BEN_PER_TYP_RT_F UPDATE_PERSON_TYPE_RATE ',30);
5830: BEN_PERSON_TYPE_RATE_API.UPDATE_PERSON_TYPE_RATE(
5831: --
5832: P_VALIDATE => false
5833: ,P_EFFECTIVE_DATE => l_effective_date