DBA Data[Home] [Help]

APPS.PER_CA_EMP_EQUITY_PKG dependencies on PER_JOBS

Line 131: from per_jobs,

127: /*Cursor for checking the validity of Job code assigned to an employee */
128: cursor cur_jobs is
129: select job_id,
130: job_information7
131: from per_jobs,
132: hr_lookups
133: where lookup_type = 'EEOG'
134: and upper(ltrim(rtrim(lookup_code)))
135: =upper(ltrim(rtrim(job_information1)))

Line 503: l_noc_code per_jobs.job_information7%type;

499: l_start_date date;
500: l_end_dt date;
501: l_cma_code varchar2(5);
502: l_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
503: l_noc_code per_jobs.job_information7%type;
504: l_salary number;
505: l_flag char(1);
506: l_flag_sal char(1); --bug 10287946
507: l_cnt_flag char(1);

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

530: delete
531: from per_ca_ee_report_lines
532: where request_id in (10,20,30);
533:
534: /* Caching data from per_jobs and per_person_types tables */
535:
536: open cur_jobs;
537: fetch cur_jobs bulk collect into
538: v_job_id_temp,