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_US_VETS_100A_LIST_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 148: per_all_assignments_f asg,

144: decode(peo.per_information25,'VETDIS','L','AFSMNSDIS','L','OTEDV','L','AFSMDIS','L','NSDIS','L','AFSMDISOP','L','AFSMNSDISOP','L','NSDISOP','L')||
145: decode(peo.per_information25,'OTEV','M','OTEDV','M','AFSMDISOP','M','AFSMNSDISOP','M','AFSMOP','M','NSOP','M','AFSMNSOP','M','NSDISOP','M')||
146: decode(peo.per_information25,'AFSM','N','AFSMNSDIS','N','AFSMDIS','N','AFSMDISOP','N','AFSMNSDISOP','N','AFSMOP','N','AFSMNSOP','N','AFSMNS','N') veteran_category
147: from per_all_people_f peo,
148: per_all_assignments_f asg,
149: per_jobs_vl job
150: where peo.person_id = asg.person_id
151: and job.job_information_category = 'US'
152: and l_end_date between job.date_from and nvl(job.date_to,l_end_date)

Line 170: from per_all_assignments_f ass1

166: AND hoi2.organization_id = P_BUSINESS_GROUP_ID
167: AND hoi2.org_information_context = 'Reporting Categories' )
168: and asg.effective_start_date =
169: (select max(ass1.effective_start_date)
170: from per_all_assignments_f ass1
171: where l_end_date between ass1.effective_start_date and ass1.effective_end_date
172: and asg.person_id = ass1.person_id
173: and ass1.assignment_type = 'E'
174: and ass1.primary_flag = 'Y'

Line 200: per_all_assignments_f asg,

196: ,job.job_information1 job_category
197: ,asg.assignment_id
198: ,decode(peo.per_information25,'NS','O','AFSMNSDIS','O','NSDIS','O','AFSMNSDISOP','O', 'NSOP','O','AFSMNSOP','O','AFSMNS','O','NSDISOP','O') veteran_category
199: from per_all_people_f peo,
200: per_all_assignments_f asg,
201: per_jobs_vl job
202: where peo.person_id = asg.person_id
203: and job.job_information_category = 'US'
204: and l_end_date between job.date_from and nvl(job.date_to,l_end_date)

Line 222: from per_all_assignments_f ass1

218: AND hoi2.organization_id = P_BUSINESS_GROUP_ID
219: AND hoi2.org_information_context = 'Reporting Categories' )
220: and asg.effective_start_date =
221: (select max(ass1.effective_start_date)
222: from per_all_assignments_f ass1
223: where l_end_date between ass1.effective_start_date and ass1.effective_end_date
224: and asg.person_id = ass1.person_id
225: and ass1.assignment_type = 'E'
226: and ass1.primary_flag = 'Y'

Line 253: per_all_assignments_f asg,

249: ,peo.per_information25 veteran
250: ,asg.assignment_id
251:
252: from per_all_people_f peo,
253: per_all_assignments_f asg,
254: per_jobs_vl job
255: where peo.person_id = asg.person_id
256: and job.job_information_category = 'US'
257: and l_end_date between job.date_from and nvl(job.date_to,l_end_date)

Line 275: from per_all_assignments_f ass1

271: AND hoi2.organization_id = P_BUSINESS_GROUP_ID
272: AND hoi2.org_information_context = 'Reporting Categories' )
273: and asg.effective_start_date =
274: (select max(ass1.effective_start_date)
275: from per_all_assignments_f ass1
276: where l_end_date between ass1.effective_start_date and ass1.effective_end_date
277: and asg.person_id = ass1.person_id
278: and ass1.assignment_type = 'E'
279: and ass1.primary_flag = 'Y'

Line 304: per_all_assignments_f asg,

300: ,peo.employee_number
301: ,peo.per_information25 veteran
302: ,asg.assignment_id
303: from per_all_people_f peo,
304: per_all_assignments_f asg,
305: per_jobs_vl job
306: where peo.person_id = asg.person_id
307: and job.job_information_category = 'US'
308: and l_end_date between job.date_from and nvl(job.date_to,l_end_date)

Line 326: from per_all_assignments_f ass1

322: AND hoi2.organization_id = P_BUSINESS_GROUP_ID
323: AND hoi2.org_information_context = 'Reporting Categories' )
324: and asg.effective_start_date =
325: (select max(ass1.effective_start_date)
326: from per_all_assignments_f ass1
327: where l_end_date between ass1.effective_start_date and ass1.effective_end_date
328: and asg.person_id = ass1.person_id
329: and ass1.assignment_type = 'E'
330: and ass1.primary_flag = 'Y'

Line 353: from per_all_assignments_f asg,

349: --Made fix for 8724355 - Removed the join condition with per_jobs_vl
350: select
351: count(distinct asg.person_id)
352: into l_count_emps
353: from per_all_assignments_f asg,
354: per_periods_of_service pps /*8667924*/
355: where
356: asg.business_group_id = P_BUSINESS_GROUP_ID
357: and asg.assignment_type = 'E'

Line 378: from per_all_assignments_f ass1

374: months_between(l_end_date,pps.actual_termination_date) between 0 and 12 /*8667924*/
375: )
376: and asg.effective_start_date =
377: (select max(ass1.effective_start_date)
378: from per_all_assignments_f ass1
379: where l_end_date between ass1.effective_start_date and ass1.effective_end_date
380: and asg.person_id = ass1.person_id
381: and ass1.assignment_type = 'E'
382: and ass1.primary_flag = 'Y'