APPS.PER_VETS_MAG_100A_REPORT dependencies on PER_ALL_PEOPLE_F

Line 179: function check_recent_or_not(l_person_id IN per_all_people_f.person_id%TYPE,

175: l_all_estab varchar2(1);
176: l_tot_emps number;
177: --
178:
179: function check_recent_or_not(l_person_id IN per_all_people_f.person_id%TYPE,
180: l_report_end_date IN date)
181: return number
182: is
183: l_count number;

Line 1210: per_all_people_f peo,

1206: count(decode(peo.per_information25,'NOTVET',1,NULL,1,'VET',1,null)) no_not_vets,
1207: count(1) no_tot_vets, --#10118692
1208: hrl.lookup_code lookup_code
1209: from per_periods_of_service pds,
1210: per_all_people_f peo,
1211: per_all_assignments_f ass,
1212: hr_organization_information hoi1,
1213: hr_organization_information hoi2,
1214: per_jobs job,

Line 1239: from per_all_people_f peo2

1235: and paf2.effective_start_date <= p_end_date
1236: )
1237: and peo.effective_start_date =
1238: (select max(peo2.effective_start_date)
1239: from per_all_people_f peo2
1240: where peo2.person_id = peo.person_id
1241: and peo.current_employee_flag = 'Y'
1242: and peo2.effective_start_date < p_end_date
1243: )

Line 1275: per_all_people_f peo,

1271: count(decode(peo.per_information25,'NS',1,'AFSMNSDIS',1,'NSDIS',1,'AFSMNSDISOP',
1272: 1,'NSOP',1,'AFSMNSOP',1,'AFSMNS',1,'NSDISOP',1,null)) no_recently_vets ,
1273: hrl.lookup_code lookup_code
1274: from per_periods_of_service pds,
1275: per_all_people_f peo,
1276: per_all_assignments_f ass,
1277: hr_organization_information hoi1,
1278: hr_organization_information hoi2,
1279: per_jobs job,

Line 1304: from per_all_people_f peo2

1300: and paf2.effective_start_date <= p_end_date
1301: )
1302: and peo.effective_start_date =
1303: (select max(peo2.effective_start_date)
1304: from per_all_people_f peo2
1305: where peo2.person_id = peo.person_id
1306: and peo.current_employee_flag = 'Y'
1307: and peo2.effective_start_date < p_end_date
1308: )

Line 1341: FROM per_all_people_f peo,

1337: 'AFSMNSDISOP',1,'AFSMOP',1,'AFSMNSOP',1,'AFSMNS',1,null)) nh_armed_vets,
1338: count(decode(peo.per_information25,'NOTVET',1,NULL,1,'VET',1,null)) nh_not_vets,
1339: count(1) no_nh_tot_vets, --#10118692
1340: hrl.lookup_code lookup_code
1341: FROM per_all_people_f peo,
1342: per_all_assignments_f ass,
1343: per_jobs job,
1344: hr_lookups hrl,
1345: per_periods_of_service pps

Line 1399: FROM per_all_people_f peo,

1395: count(decode(peo.per_information25,'NS',1,'AFSMNSDIS',1,'NSDIS',1,
1396: 'AFSMNSDISOP',1,'NSOP',1,'AFSMNSOP',1,'AFSMNS',
1397: 1,'NSDISOP',1,null)) nh_recently_vets ,
1398: hrl.lookup_code lookup_code
1399: FROM per_all_people_f peo,
1400: per_all_assignments_f ass,
1401: per_jobs job,
1402: hr_lookups hrl,
1403: per_periods_of_service pps