DBA Data[Home] [Help]

APPS.PER_US_VETC_TAP dependencies on PER_PEOPLE_F

Line 256: FROM per_people_f peo,

252: 'TRANSFER_NO_VIET_VETS=P',
253: count(decode(peo.per_information5,'VIETVET',1,'VIETVETDIS',1,'DVOEV',1,'VOEVV',1,null)) no_viet_vets,
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,

Line 347: FROM per_people_f peo,

343: 'TRANSFER_NO_NH_VIET_VETS=P',
344: count(decode(peo.per_information5,'VIETVET',1,'VIETVETDIS',1,'DVOEV',1,'VOEVV',1,null))no_nh_viet_vets,
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,