[Home] [Help]
1082: nvl(count(decode(peo.per_information5,'OTEV',1,'OTEDV',1,'DVOEV',1,
1083: 'VOEVV',1,'NSOP',1,'NSDISOP',1,'VIETNSOP',1,'VIETDISNSOP',1,
1084: null)),0) no_other_vets,
1085: hrl.lookup_code
1086: from per_periods_of_service pds,
1087: per_people_f peo,
1088: per_assignments_f ass,
1089: hr_organization_information hoi1,
1090: hr_organization_information hoi2,
1166: 'NSDISOP',1,'VIETNS',1,'VIETDISNS',1,'VIETNSOP',1,
1167: 'VIETDISNSOP',1,null))
1168: ,0) no_newlysep_vets, --added for bug 13905482
1169: decode(hrl.lookup_code,10,1,hrl.lookup_code) lookup_code
1170: from per_periods_of_service pds,
1171: per_all_people_f peo,
1172: per_all_assignments_f ass,
1173: hr_organization_information hoi1,
1174: hr_organization_information hoi2,
1251: count(decode(peo.per_information5,'NS',1,'NSDIS',1,'NSOP',1,
1252: 'NSDISOP',1,'VIETNS',1,'VIETDISNS',1,'VIETNSOP',1,
1253: 'VIETDISNSOP',1,null)) no_nh_newly_sep_vets,
1254: hrl.lookup_code
1255: from per_periods_of_service pds,
1256: per_people_f peo,
1257: per_assignments_f ass,
1258: hr_organization_information hoi1,
1259: hr_organization_information hoi2,
1334: FROM per_all_people_f peo,
1335: per_all_assignments_f ass,
1336: per_jobs job,
1337: hr_lookups hrl,
1338: per_periods_of_service pps
1339: WHERE peo.person_id = ass.person_id
1340: AND peo.person_id = pps.person_id
1341: AND peo.business_group_id = p_business_group_id
1342: AND ass.business_group_id = p_business_group_id
1487: --
1488: cursor c_tot_emps is
1489: SELECT count(distinct paf.person_id) num_people
1490: FROM per_all_assignments_f paf
1491: ,per_periods_of_service pps --8667924
1492: WHERE paf.business_group_id = p_business_group_id
1493: AND paf.primary_flag = 'Y'
1494: AND paf.assignment_type = 'E'
1495: and paf.person_id = pps.person_id