eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_VETS_MAG_100A_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 1211: per_all_assignments_f ass,

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,
1215: hr_lookups hrl

Line 1231: from per_all_assignments_f paf2

1227: and ass.assignment_type = 'E'
1228: and ass.primary_flag = 'Y'
1229: and ass.effective_start_date =
1230: (select max(paf2.effective_start_date)
1231: from per_all_assignments_f paf2
1232: where paf2.person_id = ass.person_id
1233: and paf2.primary_flag = 'Y'
1234: and paf2.assignment_type = 'E'
1235: and paf2.effective_start_date <= p_end_date

Line 1276: per_all_assignments_f ass,

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,
1280: hr_lookups hrl

Line 1296: from per_all_assignments_f paf2

1292: and ass.assignment_type = 'E'
1293: and ass.primary_flag = 'Y'
1294: and ass.effective_start_date =
1295: (select max(paf2.effective_start_date)
1296: from per_all_assignments_f paf2
1297: where paf2.person_id = ass.person_id
1298: and paf2.primary_flag = 'Y'
1299: and paf2.assignment_type = 'E'
1300: and paf2.effective_start_date <= p_end_date

Line 1342: per_all_assignments_f ass,

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

Line 1361: from per_all_assignments_f paf2

1357: AND ass.effective_start_date <= p_end_date
1358: AND job.job_information1 = hrl.lookup_code
1359: AND hrl.lookup_type = 'US_EEO1_JOB_CATEGORIES'
1360: AND ass.effective_start_date = (select max(paf2.effective_start_date)
1361: from per_all_assignments_f paf2
1362: where paf2.person_id = ass.person_id
1363: and paf2.assignment_id = ass.assignment_id
1364: and paf2.effective_start_date = peo.effective_start_date
1365: and paf2.primary_flag = 'Y'

Line 1400: per_all_assignments_f ass,

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

Line 1419: from per_all_assignments_f paf2

1415: AND ass.effective_start_date <= p_end_date
1416: AND job.job_information1 = hrl.lookup_code
1417: AND hrl.lookup_type = 'US_EEO1_JOB_CATEGORIES'
1418: AND ass.effective_start_date = (select max(paf2.effective_start_date)
1419: from per_all_assignments_f paf2
1420: where paf2.person_id = ass.person_id
1421: and paf2.assignment_id = ass.assignment_id
1422: and paf2.effective_start_date = peo.effective_start_date
1423: and paf2.primary_flag = 'Y'

Line 1460: FROM per_all_assignments_f paf

1456: l_month_end_date date := null;
1457:
1458: cursor c_min_max is
1459: SELECT count(*) num_people
1460: FROM per_all_assignments_f paf
1461: WHERE paf.business_group_id = p_business_group_id
1462: AND paf.primary_flag = 'Y'
1463: AND paf.assignment_type = 'E'
1464: --9011580

Line 1469: from per_all_assignments_f paf2

1465: --AND l_month_start_date between asg.effective_start_date and asg.effective_end_date
1466: and paf.effective_end_date >= l_month_start_date
1467: AND l_month_end_date between paf.effective_start_date and paf.effective_end_date
1468: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1469: from per_all_assignments_f paf2
1470: where paf2.person_id = paf.person_id
1471: and paf2.primary_flag = 'Y'
1472: and paf2.assignment_type = 'E'
1473: and paf2.effective_start_date

Line 1499: FROM per_all_assignments_f paf

1495: l_min_max c_min_max%rowtype;
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'

Line 1514: from per_all_assignments_f paf2

1510: AND paf.primary_flag = 'Y'
1511: AND paf.assignment_type = 'E'
1512: and p_end_date between paf.effective_start_date and paf.effective_end_date
1513: and paf.effective_start_date = (select max(paf2.effective_start_date)
1514: from per_all_assignments_f paf2
1515: where paf2.person_id = paf.person_id
1516: and paf2.primary_flag = 'Y'
1517: and paf2.assignment_type = 'E'
1518: and paf2.effective_start_date