APPS.PER_CA_EMP_EQUITY_PKG dependencies on HR_LOOKUPS

Line 115: hr_lookups

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)))
119: and upper(ltrim(rtrim(job_information_category))) = 'CA'

Line 132: from hr_lookups hl,

128:
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: (

Line 214: hr_lookups hl

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
218: paf.primary_flag = 'Y' and

Line 311: hr_lookups hrl

307: per_all_assignments_f paf,
308: per_all_people_f ppf,
309: per_pay_proposals_v2 pppv,
310: per_assignment_status_types past,
311: hr_lookups hrl
312: where paf.pay_basis_id = ppb.pay_basis_id and
313: paf.person_id=ppf.person_id and
314: past.assignment_status_type_id = paf.assignment_status_type_id and
315: pppv.assignment_id = paf.assignment_id and

Line 326: hr_lookups hrl1

322: paf.assignment_id=pppv.assignment_id and
323: paf.effective_start_date = ( select max(effective_start_date)
324: from per_all_assignments_f paf1,
325: per_assignment_status_types past1,
326: hr_lookups hrl1
327: where paf1.business_group_id = p_business_group_id
328: and paf1.assignment_id = pppv.assignment_id
329: and paf1.person_id = p_person_id
330: and past1.assignment_status_type_id = paf1.assignment_status_type_id

Line 365: hr_lookups hl1

361: 'NT','21',
362: 'NU','22',
363: '98')
364: from hr_locations_all hloc,
365: hr_lookups hl1
366: where hloc.location_id = p_location_code
367: and hl1.lookup_code = hloc.region_1
368: and hl1.lookup_type = 'CA_PROVINCE';
369:

Line 388: FROM hr_lookups hl1,

384: 'NEW BRUNSWICK LESS CMA','88','NOVA SCOTIA LESS CMA','89',
385: 'NORTH WEST TERRITORIES','90','NEWFOUNDLAND LESS CMA','91',
386: 'NUNAVUT','92','ONTORIA LESS CMA','93','PRINCE EDWARD ISLAND','94',
387: 'QUEBEC LESS CMA','95','SASKATCHEWAN LESS CMA','96','YUKON TERRITORY','97')
388: FROM hr_lookups hl1,
389: hr_locations_all hloc
390: WHERE hloc.location_id = p_location_code
391: AND hloc.region_2 = hl1.lookup_code
392: AND hl1.lookup_type = 'CA_CMA';