[Home] [Help]
1: PACKAGE BODY per_us_vets_100a_list_pkg as
2: /* $Header: pervetsl100a.pkb 120.14.12020000.2 2012/07/05 05:00:30 amnaraya ship $ */
3:
4: function check_recent_or_not(l_person_id IN per_all_people_f.person_id%TYPE,
5: l_report_end_date IN date)
6: return number
7: is
8: l_count number;
143: ,decode(peo.per_information25,'NOTVET',' ','VET',' ')||
144: decode(peo.per_information25,'VETDIS','L','AFSMNSDIS','L','OTEDV','L','AFSMDIS','L','NSDIS','L','AFSMDISOP','L','AFSMNSDISOP','L','NSDISOP','L')||
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'
195: ,peo.per_information25 veteran
196: ,job.job_information1 job_category
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'
248: ,peo.employee_number
249: ,peo.per_information25 veteran
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'
299: ,peo.first_name
300: ,peo.employee_number
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'