DBA Data[Home] [Help]

APPS.PER_US_VETS_TAP dependencies on PER_PEOPLE_F

Line 190: per_people_f peo,

186: nvl(count(peo.person_id),0),
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

Line 269: FROM per_people_f peo,

265: 'TRANSFER_NO_NH_OT_EV=P',
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,