[Home] [Help]
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
500: AND asg.business_group_id = P_BUSINESS_GROUP_ID
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
550: AND asg.business_group_id = P_BUSINESS_GROUP_ID
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
609: AND peo.business_group_id = P_BUSINESS_GROUP_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
663: AND peo.business_group_id = P_BUSINESS_GROUP_ID
1278: select
1279: count(distinct asg.person_id)
1280: into l_50_emps
1281: from per_all_assignments_f asg,
1282: per_periods_of_service pps /*8667924*/
1283: where
1284: asg.business_group_id = P_BUSINESS_GROUP_ID
1285: and asg.assignment_type = 'E'
1286: and asg.primary_flag = 'Y'