APPS.PER_CA_EMP_EQUITY_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 151: hr_soft_coding_keyflex hsck

147: /*Cursor for checking the NAIC code validation */
148: cursor cur_naic_code (p_keyflex_id number) is
149: select hl.lookup_code
150: from hr_lookups hl,
151: hr_soft_coding_keyflex hsck
152: where hsck.soft_coding_keyflex_id = p_keyflex_id and
153: hl.lookup_type = 'NAIC' and
154: (
155: (

Line 235: hr_soft_coding_keyflex hsck,

231: paf.location_id loc_id,
232: paf.effective_start_date st_dt
233: from
234: per_all_assignments_f paf,
235: hr_soft_coding_keyflex hsck,
236: hr_lookups hl
237: where paf.person_id = p_person_id and
238: paf.business_group_id = p_business_group_id and
239: paf.effective_end_date >= p_start_date and

Line 502: l_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;

498: l_st_date date;
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