567: PAS.ASS_ATTRIBUTE29,
568: PAS.ASS_ATTRIBUTE30,
569: PAS.EFFECTIVE_START_DATE
570: FROM PER_ALL_PEOPLE_F PER,
571: PER_JOBS_V PJ,
572: HR_POSITIONS_F PP,
573: HR_LOCATIONS LOC,
574: PER_ORGANIZATION_UNITS_PERF PO,
575: PER_ASSIGNMENTS_F PAS
680: PAS.ASS_ATTRIBUTE29,
681: PAS.ASS_ATTRIBUTE30,
682: PAS.EFFECTIVE_START_DATE
683: FROM PER_PEOPLE_F PER,
684: PER_JOBS_V PJ,
685: HR_POSITIONS_F PP,
686: HR_LOCATIONS LOC,
687: PER_ORGANIZATION_UNITS_PERF PO,
688: PER_ASSIGNMENTS_F PAS