[Home] [Help]
379: count(1) loc_tot_emps -- #10113747
380: FROM
381: per_all_people_f peo,
382: per_all_assignments_f asg,
383: per_jobs_vl job
384: WHERE
385: peo.person_id = asg.person_id
386: AND l_month_end_date between peo.effective_start_date and peo.effective_end_date
387: AND peo.current_employee_flag = 'Y'
431: null loc_tot_emps -- #10113747
432: FROM
433: per_all_people_f peo,
434: per_all_assignments_f asg,
435: per_jobs_vl job
436: WHERE
437: peo.person_id = asg.person_id
438: AND l_month_end_date between peo.effective_start_date and peo.effective_end_date
439: AND peo.current_employee_flag = 'Y'
491: count(decode(peo.per_information25,'NOTVET',1,NULL,1,'VET',1,null)) loc_nh_not_vets,
492: count(1) loc_nh_tot_emps -- #10113747
493: FROM per_all_people_f peo,
494: per_all_assignments_f asg,
495: per_jobs_vl job,
496: per_periods_of_service pps
497: WHERE peo.person_id = asg.person_id
498: AND peo.person_id = pps.person_id
499: AND peo.business_group_id = P_BUSINESS_GROUP_ID
541: NULL loc_nh_not_vets,
542: NULL loc_nh_tot_emps -- #10113747
543: FROM per_all_people_f peo,
544: per_all_assignments_f asg,
545: per_jobs_vl job,
546: per_periods_of_service pps
547: WHERE peo.person_id = asg.person_id
548: AND peo.person_id = pps.person_id
549: AND peo.business_group_id = P_BUSINESS_GROUP_ID
600: decode(peo.per_information25,'OTEV','R','OTEDV','R','AFSMDISOP','R','AFSMNSDISOP','R','AFSMOP','R','NSOP','R','AFSMNSOP','R','NSDISOP','R')||
601: decode(peo.per_information25,'AFSM','S','AFSMNSDIS','S','AFSMDIS','S','AFSMDISOP','S','AFSMNSDISOP','S','AFSMOP','S','AFSMNSOP','S','AFSMNS','S') veteran_category
602: FROM per_all_people_f peo,
603: per_all_assignments_f asg,
604: per_jobs_vl job,
605: per_periods_of_service pps
606:
607: WHERE peo.person_id = asg.person_id
608: AND peo.person_id = pps.person_id
654: ,asg.assignment_id
655: ,decode(peo.per_information25,'NS','T','AFSMNSDIS','T','NSDIS','T','AFSMNSDISOP','T', 'NSOP','T','AFSMNSOP','T','AFSMNS','T','NSDISOP','T') veteran_category
656: FROM per_all_people_f peo,
657: per_all_assignments_f asg,
658: per_jobs_vl job,
659: per_periods_of_service pps
660:
661: WHERE peo.person_id = asg.person_id
662: AND peo.person_id = pps.person_id
715:
716: FROM
717: per_all_people_f peo,
718: per_all_assignments_f asg,
719: per_jobs_vl job
720: WHERE
721: peo.person_id = asg.person_id
722: AND l_month_end_date between peo.effective_start_date and peo.effective_end_date
723: AND peo.current_employee_flag = 'Y'
771:
772: FROM
773: per_all_people_f peo,
774: per_all_assignments_f asg,
775: per_jobs_vl job
776: WHERE
777: peo.person_id = asg.person_id
778: AND l_month_end_date between peo.effective_start_date and peo.effective_end_date
779: AND peo.current_employee_flag = 'Y'
827:
828: FROM
829: per_all_people_f peo,
830: per_all_assignments_f asg,
831: per_jobs_vl job
832: WHERE
833: peo.person_id = asg.person_id
834: AND l_month_end_date between peo.effective_start_date and peo.effective_end_date
835: AND peo.current_employee_flag = 'Y'
882:
883: FROM
884: per_all_people_f peo,
885: per_all_assignments_f asg,
886: per_jobs_vl job
887: WHERE
888: peo.person_id = asg.person_id
889: AND l_month_end_date between peo.effective_start_date and peo.effective_end_date
890: AND peo.current_employee_flag = 'Y'
1273: CS_NH_ARMED_VETS :=0;
1274: CS_NH_RECSEP_VETS :=0;
1275: CS_NH_TOT_VETS :=0;
1276:
1277: --Made fix for 8724355 - Removed the join condition with per_jobs_vl
1278: select
1279: count(distinct asg.person_id)
1280: into l_50_emps
1281: from per_all_assignments_f asg,