185: 'TRANSFER_NO_EMPS=P',
186: nvl(count(peo.person_id),0),
187: 'TRANSFER_NO_OT_EV=P',
188: nvl(count(decode(peo.per_information5,'OTEV',1,'OTEDV',1,'DVOEV',1,'VOEVV',1,'NSOP',1,'NSDISOP',1,'VIETNSOP',1,'VIETDISNSOP',1,null)),0)
189: FROM per_periods_of_service pds,
190: per_people_f peo,
191: per_assignments_f ass,
192: hr_organization_information hoi1,
193: hr_organization_information hoi2,
269: FROM per_people_f peo,
270: per_assignments_f ass,
271: hr_organization_information hoi1,
272: hr_organization_information hoi2,
273: per_periods_of_service pds,
274: per_jobs job
275: WHERE peo.person_id = ass.person_id
276: and pds.date_start between to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_START'),'YYYY/MM/DD HH24:MI:SS')
277: and to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')
381:
382: cursor S_VETS_MIN_COUNT is
383: SELECT 'TRANSFER_MIN_COUNT_ASSIGNMENTS=P',
384: count (distinct pds.person_id)
385: FROM per_periods_of_service pds,
386: per_assignments_f ass,
387: hr_organization_information hoi1,
388: hr_organization_information hoi2,
389: per_jobs job