APPS.PER_US_VETS_TAP dependencies on PER_JOBS

Line 194: per_jobs job

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')
196: and nvl(pds.actual_termination_date,to_date('31-12-4712','DD-MM-YYYY')) >=
197: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')
198: or pds.date_start between to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_START'),'YYYY/MM/DD HH24:MI:SS')

Line 274: per_jobs job

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
275: WHERE peo.person_id = ass.person_id
276: and pds.date_start between to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_START'),'YYYY/MM/DD HH24:MI:SS')
277: and to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')
278: and to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')

Line 344: per_jobs job

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'
346: AND job.date_from <=
347: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')
348: AND nvl(job.date_to, to_date('4712/12/31', 'YYYY/MM/DD')) >=

Line 389: per_jobs job

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 <=
391: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_START'),'YYYY/MM/DD HH24:MI:SS')
392: AND (nvl(pds.actual_termination_date,
393: to_date('12/31/4712','MM/DD/YYYY')) >=