APPS.PER_VETS_MAG_REPORT dependencies on PER_PERIODS_OF_SERVICE

Line 977: from per_periods_of_service pds,

973: nvl(count(decode(peo.per_information5,'OTEV',1,'OTEDV',1,'DVOEV',1,
974: 'VOEVV',1,'NSOP',1,'NSDISOP',1,'VIETNSOP',1,'VIETDISNSOP',1,
975: null)),0) no_other_vets,
976: hrl.lookup_code
977: from per_periods_of_service pds,
978: per_people_f peo,
979: per_assignments_f ass,
980: hr_organization_information hoi1,
981: hr_organization_information hoi2,

Line 1056: from per_periods_of_service pds,

1052: null))
1053: ,0)
1054: no_other_vets,
1055: decode(hrl.lookup_code,10,1,hrl.lookup_code) lookup_code
1056: from per_periods_of_service pds,
1057: per_all_people_f peo,
1058: per_all_assignments_f ass,
1059: hr_organization_information hoi1,
1060: hr_organization_information hoi2,

Line 1141: from per_periods_of_service pds,

1137: count(decode(peo.per_information5,'NS',1,'NSDIS',1,'NSOP',1,
1138: 'NSDISOP',1,'VIETNS',1,'VIETDISNS',1,'VIETNSOP',1,
1139: 'VIETDISNSOP',1,null)) no_nh_newly_sep_vets,
1140: hrl.lookup_code
1141: from per_periods_of_service pds,
1142: per_people_f peo,
1143: per_assignments_f ass,
1144: hr_organization_information hoi1,
1145: hr_organization_information hoi2,

Line 1222: per_periods_of_service pps

1218: FROM per_all_people_f peo,
1219: per_all_assignments_f ass,
1220: per_jobs job,
1221: hr_lookups hrl,
1222: per_periods_of_service pps
1223: WHERE peo.person_id = ass.person_id
1224: AND peo.person_id = pps.person_id
1225: AND peo.business_group_id = p_business_group_id
1226: AND ass.business_group_id = p_business_group_id