APPS.PER_US_VETS_TAP dependencies on PER_ASSIGNMENTS_F

Line 191: per_assignments_f ass,

187: 'TRANSFER_NO_OT_EV=P',
188: nvl(count(decode(peo.per_information5,'OTEV',1,'OTEDV',1,'DVOEV',1,'VOEVV',1,'NSOP',1,'NSDISOP',1,'VIETNSOP',1,'VIETDISNSOP',1,null)),0)
189: FROM per_periods_of_service pds,
190: per_people_f peo,
191: per_assignments_f ass,
192: hr_organization_information hoi1,
193: hr_organization_information hoi2,
194: per_jobs job
195: WHERE (pds.date_start <= to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')

Line 221: from per_assignments_f paf2

217: AND peo.current_employee_flag = 'Y'
218: AND ass.assignment_type = 'E'
219: AND ass.primary_flag = 'Y'
220: AND ass.effective_start_date = (select max(paf2.effective_start_date)
221: from per_assignments_f paf2
222: where paf2.person_id = ass.person_id
223: and paf2.primary_flag = 'Y'
224: and paf2.assignment_type = 'E'
225: and paf2.effective_start_date <=

Line 270: per_assignments_f ass,

266: nvl(count(decode(peo.per_information5,'OTEV',1,'OTEDV',1,'DVOEV',1,'VOEVV',1,'NSOP',1,'NSDISOP',1,'VIETNSOP',1,'VIETDISNSOP',1,null)),0),
267: 'TRANSFER_NO_NH_SEP_VETS=P',
268: nvl(count(decode(peo.per_information5,'NS',1,'NSDIS',1,'NSOP',1,'NSDISOP',1,'VIETNS',1,'VIETDISNS',1,'VIETNSOP',1,'VIETDISNSOP',1,null)),0)
269: FROM per_people_f peo,
270: per_assignments_f ass,
271: hr_organization_information hoi1,
272: hr_organization_information hoi2,
273: per_periods_of_service pds,
274: per_jobs job

Line 298: from per_assignments_f paf2

294: AND peo.current_employee_flag = 'Y'
295: AND ass.assignment_type = 'E'
296: AND ass.primary_flag = 'Y'
297: AND ass.effective_start_date = (select max(paf2.effective_start_date)
298: from per_assignments_f paf2
299: where paf2.person_id = ass.person_id
300: and paf2.primary_flag = 'Y'
301: and paf2.assignment_type = 'E'
302: and paf2.effective_start_date <=

Line 341: FROM per_assignments_f ass,

337:
338: cursor S_VETS_ASG_COUNT is
339: SELECT 'TRANSFER_COUNT_ASSIGNMENTS=P',
340: count(ass.assignment_id)
341: FROM per_assignments_f ass,
342: hr_organization_information hoi1,
343: -- hr_organization_information hoi2,
344: per_jobs job
345: WHERE job.job_information_category = 'US'

Line 386: per_assignments_f ass,

382: cursor S_VETS_MIN_COUNT is
383: SELECT 'TRANSFER_MIN_COUNT_ASSIGNMENTS=P',
384: count (distinct pds.person_id)
385: FROM per_periods_of_service pds,
386: per_assignments_f ass,
387: hr_organization_information hoi1,
388: hr_organization_information hoi2,
389: per_jobs job
390: WHERE pds.date_start <=