APPS.PER_US_VETC_TAP dependencies on HR_ORGANIZATION_INFORMATION

Line 258: hr_organization_information hoi1,

254: 'TRANSFER_NO_OT_EV=P',
255: nvl(count(decode(peo.per_information5,'OTEV',1,'OTEDV',1,'DVOEV',1,'VOEVV',1,null)),0)
256: FROM per_people_f peo,
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

Line 259: hr_organization_information hoi2,

255: nvl(count(decode(peo.per_information5,'OTEV',1,'OTEDV',1,'DVOEV',1,'VOEVV',1,null)),0)
256: FROM per_people_f peo,
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'

Line 349: hr_organization_information hoi1,

345: 'TRANSFER_NO_NH_OT_EV=P',
346: nvl(count(decode(peo.per_information5,'OTEV',1,'OTEDV',1,'DVOEV',1,'VOEVV',1,null)),0)
347: FROM per_people_f peo,
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

Line 350: hr_organization_information hoi2,

346: nvl(count(decode(peo.per_information5,'OTEV',1,'OTEDV',1,'DVOEV',1,'VOEVV',1,null)),0)
347: FROM per_people_f peo,
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'

Line 435: hr_organization_information hoi1,

431: FROM per_assignments_f ass,
432: hr_establishments_v hev,
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 <=