APPS.PER_CA_EMP_EQUITY_PKG dependencies on PER_JOBS

Line 114: from per_jobs,

110: /*Cursor for checking the validity of Job code assigned to an employee */
111: cursor cur_jobs is
112: select job_id,
113: job_information7
114: from per_jobs,
115: hr_lookups
116: where lookup_type = 'EEOG'
117: and upper(ltrim(rtrim(lookup_code)))
118: =upper(ltrim(rtrim(job_information1)))

Line 446: l_noc_code per_jobs.job_information7%type;

442: l_start_date date;
443: l_end_dt date;
444: l_cma_code varchar2(5);
445: l_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
446: l_noc_code per_jobs.job_information7%type;
447: l_salary number;
448: l_flag char(1);
449: l_cnt_flag char(1);
450: l_tmp_cnt number;

Line 473: /* Caching data from per_jobs and per_person_types tables */

469: delete
470: from per_ca_ee_report_lines
471: where request_id in (10,20,30);
472:
473: /* Caching data from per_jobs and per_person_types tables */
474:
475: open cur_jobs;
476: fetch cur_jobs bulk collect into
477: v_job_id_temp,