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.

[Home] [Help]

APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on PER_CONTRACTS_F

Line 558: FROM per_contracts_f pcf

554: SELECT pcf.contract_id contract_id
555: ,hr_general.decode_lookup('CONTRACT_TYPE',pcf.type) contract_type
556: ,hr_contract_api.get_active_end_date (pcf.contract_id
557: ,p_effective_date,pcf.status) contract_end_date
558: FROM per_contracts_f pcf
559: where pcf.person_id = c_person_id
560: AND c_effective_date BETWEEN pcf.effective_start_date
561: AND pcf.effective_end_date;
562: