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_PERIODS_OF_SERVICE

Line 1209: from per_periods_of_service pds,

1205: 1,'AFSMNSDISOP',1,'AFSMOP',1,'AFSMNSOP',1,'AFSMNS',1,null)) no_armed_vets,
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,

Line 1274: from per_periods_of_service pds,

1270: select
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,

Line 1345: per_periods_of_service pps

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
1348: AND peo.business_group_id = p_business_group_id
1349: AND ass.business_group_id = p_business_group_id

Line 1403: per_periods_of_service pps

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
1406: AND peo.business_group_id = p_business_group_id
1407: AND ass.business_group_id = p_business_group_id

Line 1501: ,per_periods_of_service pps --8667924

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)
1505: paf.person_id = pps.person_id