APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on PER_JOBS_TL

Line 594: l_emp_occupation per_jobs_tl.name%type;

590: l_contract_data csr_contract_data%rowtype;
591: l_emp_ss_id csr_get_ss_id%rowtype;
592: l_leaving_reason per_shared_types.information1%type;
593: l_action_info_id number;
594: l_emp_occupation per_jobs_tl.name%type;
595: l_ovn number;
596: l_vac_days number;
597: l_sickness_start_date date;
598:

Line 616: FROM per_jobs_tl jbt

612: AND business_group_id IS NULL;
613:
614: CURSOR csr_job_name(c_job_id NUMBER) IS
615: SELECT jbt.name
616: FROM per_jobs_tl jbt
617: WHERE jbt.language = userenv('LANG')
618: AND jbt.job_id = c_job_id;
619:
620: CURSOR csr_get_wc_prov(c_wc_id NUMBER) IS