APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on HR_CONTRACT_API

Line 556: ,hr_contract_api.get_active_end_date (pcf.contract_id

552:
553: CURSOR csr_contract_data(c_person_id number, c_effective_date date) IS
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