APPS.PER_CA_EMP_EQUITY_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 133: hr_soft_coding_keyflex hsck

129: /*Cursor for checking the NAIC code validation */
130: cursor cur_naic_code (p_keyflex_id number) is
131: select hl.lookup_code
132: from hr_lookups hl,
133: hr_soft_coding_keyflex hsck
134: where hsck.soft_coding_keyflex_id = p_keyflex_id and
135: hl.lookup_type = 'NAIC' and
136: (
137: (

Line 213: hr_soft_coding_keyflex hsck,

209: paf.location_id loc_id,
210: paf.effective_start_date st_dt
211: from
212: per_all_assignments_f paf,
213: hr_soft_coding_keyflex hsck,
214: hr_lookups hl
215: where paf.person_id = p_person_id and
216: paf.business_group_id = p_business_group_id and
217: paf.effective_end_date >= p_start_date and

Line 445: l_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;

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