APPS.PER_VETS_MAG_REPORT dependencies on PER_ALL_PEOPLE_F

Line 1171: per_all_people_f peo,

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,
1175: per_jobs job,

Line 1208: from per_all_people_f peo2

1204: )
1205: --
1206: and peo.effective_start_date =
1207: (select max(peo2.effective_start_date)
1208: from per_all_people_f peo2
1209: where peo2.person_id = peo.person_id
1210: and peo.current_employee_flag = 'Y'
1211: and peo2.effective_start_date < p_end_date
1212: )

Line 1334: FROM per_all_people_f peo,

1330: 'VIETDISNSOP',1,'AFSMNS',1,'AFSMDISNS',1,'AFSMNSOP',1,
1331: 'AFSMNSVIET',1,'AFSMNSDISOP',1,'AFSMVIETNSOP',1,'AFSMVIETNSDIS',1,
1332: 'AFSMVIETNSDISOP',1,null)) no_nh_newly_sep_vets,
1333: decode(hrl.lookup_code,'10','1',hrl.lookup_code) lookup_code
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