218: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
219: PER_ASS_STATUS_TYPE_AMENDS AMD,
220: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL,
221: HR_ALL_ORGANIZATION_UNITS O,
222: HR_ALL_ORGANIZATION_UNITS_TL OTL ,
223: HR_ALL_ORGANIZATION_UNITS_TL OTL1 ,
224: pay_all_payrolls_f pay,
225:
226:
219: PER_ASS_STATUS_TYPE_AMENDS AMD,
220: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL,
221: HR_ALL_ORGANIZATION_UNITS O,
222: HR_ALL_ORGANIZATION_UNITS_TL OTL ,
223: HR_ALL_ORGANIZATION_UNITS_TL OTL1 ,
224: pay_all_payrolls_f pay,
225:
226:
227: ( SELECT FULL_NAME ,