APPS.PER_VETS_MAG_100A_REPORT dependencies on PER_JOBS

Line 1214: per_jobs job,

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,
1215: hr_lookups hrl
1216: where
1217: pds.date_start <= p_end_date
1218: and nvl(pds.actual_termination_date,p_end_date + 1) >= p_end_date

Line 1279: per_jobs job,

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,
1280: hr_lookups hrl
1281: where
1282: pds.date_start <= p_end_date
1283: and nvl(pds.actual_termination_date,p_end_date + 1) >= p_end_date

Line 1343: per_jobs job,

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
1346: WHERE peo.person_id = ass.person_id
1347: AND peo.person_id = pps.person_id

Line 1401: per_jobs job,

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
1404: WHERE peo.person_id = ass.person_id
1405: AND peo.person_id = pps.person_id

Line 1500: --, per_jobs_vl job

1496:
1497: cursor c_tot_emps is
1498: SELECT count(distinct paf.person_id) num_people
1499: FROM per_all_assignments_f paf
1500: --, per_jobs_vl job
1501: ,per_periods_of_service pps --8667924
1502: WHERE
1503: -- job.job_information_category = 'US'
1504: -- and p_end_date between job.date_from and nvl(job.date_to,p_end_date)