[Home] [Help]
145: decode(peo.per_information25,'OTEV','M','OTEDV','M','AFSMDISOP','M','AFSMNSDISOP','M','AFSMOP','M','NSOP','M','AFSMNSOP','M','NSDISOP','M')||
146: decode(peo.per_information25,'AFSM','N','AFSMNSDIS','N','AFSMDIS','N','AFSMDISOP','N','AFSMNSDISOP','N','AFSMOP','N','AFSMNSOP','N','AFSMNS','N') veteran_category
147: from per_all_people_f peo,
148: per_all_assignments_f asg,
149: per_jobs_vl job
150: where peo.person_id = asg.person_id
151: and job.job_information_category = 'US'
152: and l_end_date between job.date_from and nvl(job.date_to,l_end_date)
153: and job.job_information1 is not null
197: ,asg.assignment_id
198: ,decode(peo.per_information25,'NS','O','AFSMNSDIS','O','NSDIS','O','AFSMNSDISOP','O', 'NSOP','O','AFSMNSOP','O','AFSMNS','O','NSDISOP','O') veteran_category
199: from per_all_people_f peo,
200: per_all_assignments_f asg,
201: per_jobs_vl job
202: where peo.person_id = asg.person_id
203: and job.job_information_category = 'US'
204: and l_end_date between job.date_from and nvl(job.date_to,l_end_date)
205: and job.job_information1 is not null
250: ,asg.assignment_id
251:
252: from per_all_people_f peo,
253: per_all_assignments_f asg,
254: per_jobs_vl job
255: where peo.person_id = asg.person_id
256: and job.job_information_category = 'US'
257: and l_end_date between job.date_from and nvl(job.date_to,l_end_date)
258: and job.job_information1 is not null
301: ,peo.per_information25 veteran
302: ,asg.assignment_id
303: from per_all_people_f peo,
304: per_all_assignments_f asg,
305: per_jobs_vl job
306: where peo.person_id = asg.person_id
307: and job.job_information_category = 'US'
308: and l_end_date between job.date_from and nvl(job.date_to,l_end_date)
309: and job.job_information1 is not null
345:
346:
347: begin
348:
349: --Made fix for 8724355 - Removed the join condition with per_jobs_vl
350: select
351: count(distinct asg.person_id)
352: into l_count_emps
353: from per_all_assignments_f asg,