APPS.PER_US_VETC_TAP dependencies on PER_JOBS

Line 261: per_jobs job

257: per_assignments_f ass,
258: hr_organization_information hoi1,
259: hr_organization_information hoi2,
260: hr_soft_coding_keyflex scf,
261: per_jobs job
262: WHERE peo.person_id = ass.person_id
263: AND job.job_information_category = 'US'
264: AND job.date_from <=
265: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')

Line 352: per_jobs job

348: per_assignments_f ass,
349: hr_organization_information hoi1,
350: hr_organization_information hoi2,
351: hr_soft_coding_keyflex scf,
352: per_jobs job
353: WHERE peo.person_id = ass.person_id
354: AND job.job_information_category = 'US'
355: AND job.date_from <=
356: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')

Line 437: per_jobs job

433: hr_locations hl,
434: pay_state_rules psr,
435: hr_organization_information hoi1,
436: hr_soft_coding_keyflex scf,
437: per_jobs job
438: WHERE job.job_information_category = 'US'
439: AND job.date_from <=
440: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')
441: AND nvl(job.date_to, to_date('31-12-4712', 'DD-MM-YYYY')) >=

Line 497: per_jobs job

493: count (distinct pds.person_id)
494: FROM per_periods_of_service pds,
495: per_assignments_f ass,
496: hr_soft_coding_keyflex scf,
497: per_jobs job
498: WHERE pds.date_start <
499: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_START'),'YYYY/MM/DD HH24:MI:SS')
500: AND (nvl(pds.actual_termination_date,
501: to_date('12/31/4712','MM/DD/YYYY')) >