DBA Data[Home] [Help]

APPS.PER_FR_D2_PKG dependencies on PER_JOBS_V

Line 557: from per_jobs_v

553: end loop;
554: --
555: select job_information1, name
556: into p_pcs_code, p_job_title
557: from per_jobs_v
558: where job_id = lid
559: and nvl(job_information_category,' ') = 'FR';
560: --
561: begin -- get pcs-code

Line 712: l_job_title per_jobs_v.name%TYPE;

708: is
709: l_pcs_code_text varchar2(30);
710: l_pcs_code number(30):=0;
711: l_pcs_particular varchar2(1);
712: l_job_title per_jobs_v.name%TYPE;
713: -- #4068197
714: l_exists varchar2(1);
715: l_pcs_code_count number;
716: -- #4068197