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: