APPS.PER_VETS_MAG_REPORT dependencies on PER_ALL_PEOPLE_F

Line 1057: per_all_people_f peo,

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

Line 1094: from per_all_people_f peo2

1090: )
1091: --
1092: and peo.effective_start_date =
1093: (select max(peo2.effective_start_date)
1094: from per_all_people_f peo2
1095: where peo2.person_id = peo.person_id
1096: and peo.current_employee_flag = 'Y'
1097: and peo2.effective_start_date < p_end_date
1098: )

Line 1218: FROM per_all_people_f peo,

1214: 'VIETDISNSOP',1,'AFSMNS',1,'AFSMDISNS',1,'AFSMNSOP',1,
1215: 'AFSMNSVIET',1,'AFSMNSDISOP',1,'AFSMVIETNSOP',1,'AFSMVIETNSDIS',1,
1216: 'AFSMVIETNSDISOP',1,null)) no_nh_newly_sep_vets,
1217: decode(hrl.lookup_code,'10','1',hrl.lookup_code) lookup_code
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