732: --mirror type of PER_ASSIGNMENTS_V
733:
734: TYPE g_asg_type IS RECORD
735: (
736: ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
737: ROW_ID VARCHAR2(16),
738: EFFECTIVE_START_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE%TYPE,
739: D_EFFECTIVE_END_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE,
740: EFFECTIVE_END_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE,
734: TYPE g_asg_type IS RECORD
735: (
736: ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
737: ROW_ID VARCHAR2(16),
738: EFFECTIVE_START_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE%TYPE,
739: D_EFFECTIVE_END_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE,
740: EFFECTIVE_END_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE,
741: BUSINESS_GROUP_ID PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID%TYPE,
742: GRADE_ID PER_ALL_ASSIGNMENTS_F.GRADE_ID%TYPE,
735: (
736: ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
737: ROW_ID VARCHAR2(16),
738: EFFECTIVE_START_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE%TYPE,
739: D_EFFECTIVE_END_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE,
740: EFFECTIVE_END_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE,
741: BUSINESS_GROUP_ID PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID%TYPE,
742: GRADE_ID PER_ALL_ASSIGNMENTS_F.GRADE_ID%TYPE,
743: GRADE_NAME PER_GRADES_TL.NAME%TYPE,
736: ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
737: ROW_ID VARCHAR2(16),
738: EFFECTIVE_START_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE%TYPE,
739: D_EFFECTIVE_END_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE,
740: EFFECTIVE_END_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE,
741: BUSINESS_GROUP_ID PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID%TYPE,
742: GRADE_ID PER_ALL_ASSIGNMENTS_F.GRADE_ID%TYPE,
743: GRADE_NAME PER_GRADES_TL.NAME%TYPE,
744: POSITION_ID PER_ALL_ASSIGNMENTS_F.POSITION_ID%TYPE,
737: ROW_ID VARCHAR2(16),
738: EFFECTIVE_START_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE%TYPE,
739: D_EFFECTIVE_END_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE,
740: EFFECTIVE_END_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE,
741: BUSINESS_GROUP_ID PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID%TYPE,
742: GRADE_ID PER_ALL_ASSIGNMENTS_F.GRADE_ID%TYPE,
743: GRADE_NAME PER_GRADES_TL.NAME%TYPE,
744: POSITION_ID PER_ALL_ASSIGNMENTS_F.POSITION_ID%TYPE,
745: POSITION_NAME VARCHAR2(240),
738: EFFECTIVE_START_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE%TYPE,
739: D_EFFECTIVE_END_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE,
740: EFFECTIVE_END_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE,
741: BUSINESS_GROUP_ID PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID%TYPE,
742: GRADE_ID PER_ALL_ASSIGNMENTS_F.GRADE_ID%TYPE,
743: GRADE_NAME PER_GRADES_TL.NAME%TYPE,
744: POSITION_ID PER_ALL_ASSIGNMENTS_F.POSITION_ID%TYPE,
745: POSITION_NAME VARCHAR2(240),
746: JOB_ID PER_ALL_ASSIGNMENTS_F.JOB_ID%TYPE,
740: EFFECTIVE_END_DATE PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE,
741: BUSINESS_GROUP_ID PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID%TYPE,
742: GRADE_ID PER_ALL_ASSIGNMENTS_F.GRADE_ID%TYPE,
743: GRADE_NAME PER_GRADES_TL.NAME%TYPE,
744: POSITION_ID PER_ALL_ASSIGNMENTS_F.POSITION_ID%TYPE,
745: POSITION_NAME VARCHAR2(240),
746: JOB_ID PER_ALL_ASSIGNMENTS_F.JOB_ID%TYPE,
747: JOB_NAME PER_JOBS_TL.NAME%TYPE,
748: ASSIGNMENT_STATUS_TYPE_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE,
742: GRADE_ID PER_ALL_ASSIGNMENTS_F.GRADE_ID%TYPE,
743: GRADE_NAME PER_GRADES_TL.NAME%TYPE,
744: POSITION_ID PER_ALL_ASSIGNMENTS_F.POSITION_ID%TYPE,
745: POSITION_NAME VARCHAR2(240),
746: JOB_ID PER_ALL_ASSIGNMENTS_F.JOB_ID%TYPE,
747: JOB_NAME PER_JOBS_TL.NAME%TYPE,
748: ASSIGNMENT_STATUS_TYPE_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE,
749: USER_STATUS PER_ASS_STATUS_TYPE_AMENDS_TL.USER_STATUS%TYPE,
750: PER_SYSTEM_STATUS PER_ASS_STATUS_TYPE_AMENDS.PER_SYSTEM_STATUS%TYPE,
744: POSITION_ID PER_ALL_ASSIGNMENTS_F.POSITION_ID%TYPE,
745: POSITION_NAME VARCHAR2(240),
746: JOB_ID PER_ALL_ASSIGNMENTS_F.JOB_ID%TYPE,
747: JOB_NAME PER_JOBS_TL.NAME%TYPE,
748: ASSIGNMENT_STATUS_TYPE_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE,
749: USER_STATUS PER_ASS_STATUS_TYPE_AMENDS_TL.USER_STATUS%TYPE,
750: PER_SYSTEM_STATUS PER_ASS_STATUS_TYPE_AMENDS.PER_SYSTEM_STATUS%TYPE,
751: PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE,
752: PAYROLL_NAME PAY_ALL_PAYROLLS_F.PAYROLL_NAME%TYPE,
747: JOB_NAME PER_JOBS_TL.NAME%TYPE,
748: ASSIGNMENT_STATUS_TYPE_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE,
749: USER_STATUS PER_ASS_STATUS_TYPE_AMENDS_TL.USER_STATUS%TYPE,
750: PER_SYSTEM_STATUS PER_ASS_STATUS_TYPE_AMENDS.PER_SYSTEM_STATUS%TYPE,
751: PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE,
752: PAYROLL_NAME PAY_ALL_PAYROLLS_F.PAYROLL_NAME%TYPE,
753: LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE,
754: LOCATION_CODE HR_LOCATIONS_ALL_TL.LOCATION_CODE%TYPE,
755: SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE,
749: USER_STATUS PER_ASS_STATUS_TYPE_AMENDS_TL.USER_STATUS%TYPE,
750: PER_SYSTEM_STATUS PER_ASS_STATUS_TYPE_AMENDS.PER_SYSTEM_STATUS%TYPE,
751: PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE,
752: PAYROLL_NAME PAY_ALL_PAYROLLS_F.PAYROLL_NAME%TYPE,
753: LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE,
754: LOCATION_CODE HR_LOCATIONS_ALL_TL.LOCATION_CODE%TYPE,
755: SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE,
756: SUPERVISOR_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
757: SUPERVISOR_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
751: PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE,
752: PAYROLL_NAME PAY_ALL_PAYROLLS_F.PAYROLL_NAME%TYPE,
753: LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE,
754: LOCATION_CODE HR_LOCATIONS_ALL_TL.LOCATION_CODE%TYPE,
755: SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE,
756: SUPERVISOR_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
757: SUPERVISOR_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
758: SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE,
759: SPINAL_POINT PER_SPINAL_POINTS.SPINAL_POINT%TYPE,
754: LOCATION_CODE HR_LOCATIONS_ALL_TL.LOCATION_CODE%TYPE,
755: SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE,
756: SUPERVISOR_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
757: SUPERVISOR_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
758: SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE,
759: SPINAL_POINT PER_SPINAL_POINTS.SPINAL_POINT%TYPE,
760: SPINAL_POINT_STEP_SEQUENCE PER_SPINAL_POINT_STEPS_F.SEQUENCE%TYPE,
761: PERSON_ID PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE,
762: ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE,
757: SUPERVISOR_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
758: SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE,
759: SPINAL_POINT PER_SPINAL_POINTS.SPINAL_POINT%TYPE,
760: SPINAL_POINT_STEP_SEQUENCE PER_SPINAL_POINT_STEPS_F.SEQUENCE%TYPE,
761: PERSON_ID PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE,
762: ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE,
763: ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE,
764: PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE,
765: ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE,
758: SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE,
759: SPINAL_POINT PER_SPINAL_POINTS.SPINAL_POINT%TYPE,
760: SPINAL_POINT_STEP_SEQUENCE PER_SPINAL_POINT_STEPS_F.SEQUENCE%TYPE,
761: PERSON_ID PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE,
762: ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE,
763: ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE,
764: PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE,
765: ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE,
766: PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE,
760: SPINAL_POINT_STEP_SEQUENCE PER_SPINAL_POINT_STEPS_F.SEQUENCE%TYPE,
761: PERSON_ID PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE,
762: ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE,
763: ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE,
764: PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE,
765: ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE,
766: PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE,
767: ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE,
768: CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE,
761: PERSON_ID PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE,
762: ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE,
763: ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE,
764: PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE,
765: ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE,
766: PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE,
767: ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE,
768: CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE,
769: CHANGE_REASON_MEANING VARCHAR2(240),
762: ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE,
763: ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE,
764: PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE,
765: ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE,
766: PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE,
767: ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE,
768: CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE,
769: CHANGE_REASON_MEANING VARCHAR2(240),
770: COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE,
763: ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE,
764: PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE,
765: ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE,
766: PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE,
767: ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE,
768: CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE,
769: CHANGE_REASON_MEANING VARCHAR2(240),
770: COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE,
771: COMMENT_TEXT HR_COMMENTS.COMMENT_TEXT%TYPE,
764: PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE,
765: ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE,
766: PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE,
767: ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE,
768: CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE,
769: CHANGE_REASON_MEANING VARCHAR2(240),
770: COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE,
771: COMMENT_TEXT HR_COMMENTS.COMMENT_TEXT%TYPE,
772: DATE_PROBATION_END PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END%TYPE,
766: PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE,
767: ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE,
768: CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE,
769: CHANGE_REASON_MEANING VARCHAR2(240),
770: COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE,
771: COMMENT_TEXT HR_COMMENTS.COMMENT_TEXT%TYPE,
772: DATE_PROBATION_END PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END%TYPE,
773: D_DATE_PROBATION_END PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END%TYPE,
774: FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE,
768: CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE,
769: CHANGE_REASON_MEANING VARCHAR2(240),
770: COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE,
771: COMMENT_TEXT HR_COMMENTS.COMMENT_TEXT%TYPE,
772: DATE_PROBATION_END PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END%TYPE,
773: D_DATE_PROBATION_END PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END%TYPE,
774: FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE,
775: FREQUENCY_MEANING VARCHAR2(240),
776: INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE,
769: CHANGE_REASON_MEANING VARCHAR2(240),
770: COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE,
771: COMMENT_TEXT HR_COMMENTS.COMMENT_TEXT%TYPE,
772: DATE_PROBATION_END PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END%TYPE,
773: D_DATE_PROBATION_END PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END%TYPE,
774: FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE,
775: FREQUENCY_MEANING VARCHAR2(240),
776: INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE,
777: MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE,
770: COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE,
771: COMMENT_TEXT HR_COMMENTS.COMMENT_TEXT%TYPE,
772: DATE_PROBATION_END PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END%TYPE,
773: D_DATE_PROBATION_END PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END%TYPE,
774: FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE,
775: FREQUENCY_MEANING VARCHAR2(240),
776: INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE,
777: MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE,
778: NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE,
772: DATE_PROBATION_END PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END%TYPE,
773: D_DATE_PROBATION_END PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END%TYPE,
774: FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE,
775: FREQUENCY_MEANING VARCHAR2(240),
776: INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE,
777: MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE,
778: NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE,
779: PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE,
780: PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE,
773: D_DATE_PROBATION_END PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END%TYPE,
774: FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE,
775: FREQUENCY_MEANING VARCHAR2(240),
776: INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE,
777: MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE,
778: NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE,
779: PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE,
780: PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE,
781: PROBATION_UNIT_MEANING VARCHAR2(240),
774: FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE,
775: FREQUENCY_MEANING VARCHAR2(240),
776: INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE,
777: MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE,
778: NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE,
779: PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE,
780: PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE,
781: PROBATION_UNIT_MEANING VARCHAR2(240),
782: TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE,
775: FREQUENCY_MEANING VARCHAR2(240),
776: INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE,
777: MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE,
778: NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE,
779: PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE,
780: PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE,
781: PROBATION_UNIT_MEANING VARCHAR2(240),
782: TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE,
783: TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE,
776: INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE,
777: MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE,
778: NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE,
779: PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE,
780: PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE,
781: PROBATION_UNIT_MEANING VARCHAR2(240),
782: TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE,
783: TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE,
784: BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE,
778: NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE,
779: PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE,
780: PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE,
781: PROBATION_UNIT_MEANING VARCHAR2(240),
782: TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE,
783: TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE,
784: BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE,
785: BARGAINING_UNIT_CODE_MEANING VARCHAR2(240),
786: LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE,
779: PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE,
780: PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE,
781: PROBATION_UNIT_MEANING VARCHAR2(240),
782: TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE,
783: TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE,
784: BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE,
785: BARGAINING_UNIT_CODE_MEANING VARCHAR2(240),
786: LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE,
787: HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE,
780: PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE,
781: PROBATION_UNIT_MEANING VARCHAR2(240),
782: TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE,
783: TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE,
784: BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE,
785: BARGAINING_UNIT_CODE_MEANING VARCHAR2(240),
786: LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE,
787: HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE,
788: HOURLY_SALARIED_CODE_MEANING VARCHAR2(240),
782: TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE,
783: TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE,
784: BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE,
785: BARGAINING_UNIT_CODE_MEANING VARCHAR2(240),
786: LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE,
787: HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE,
788: HOURLY_SALARIED_CODE_MEANING VARCHAR2(240),
789: LAST_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_DATE%TYPE,
790: LAST_UPDATED_BY PER_ALL_ASSIGNMENTS_F.LAST_UPDATED_BY%TYPE,
783: TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE,
784: BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE,
785: BARGAINING_UNIT_CODE_MEANING VARCHAR2(240),
786: LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE,
787: HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE,
788: HOURLY_SALARIED_CODE_MEANING VARCHAR2(240),
789: LAST_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_DATE%TYPE,
790: LAST_UPDATED_BY PER_ALL_ASSIGNMENTS_F.LAST_UPDATED_BY%TYPE,
791: LAST_UPDATE_LOGIN PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_LOGIN%TYPE,
785: BARGAINING_UNIT_CODE_MEANING VARCHAR2(240),
786: LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE,
787: HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE,
788: HOURLY_SALARIED_CODE_MEANING VARCHAR2(240),
789: LAST_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_DATE%TYPE,
790: LAST_UPDATED_BY PER_ALL_ASSIGNMENTS_F.LAST_UPDATED_BY%TYPE,
791: LAST_UPDATE_LOGIN PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_LOGIN%TYPE,
792: CREATED_BY PER_ALL_ASSIGNMENTS_F.CREATED_BY%TYPE,
793: CREATION_DATE PER_ALL_ASSIGNMENTS_F.CREATION_DATE%TYPE,
786: LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE,
787: HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE,
788: HOURLY_SALARIED_CODE_MEANING VARCHAR2(240),
789: LAST_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_DATE%TYPE,
790: LAST_UPDATED_BY PER_ALL_ASSIGNMENTS_F.LAST_UPDATED_BY%TYPE,
791: LAST_UPDATE_LOGIN PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_LOGIN%TYPE,
792: CREATED_BY PER_ALL_ASSIGNMENTS_F.CREATED_BY%TYPE,
793: CREATION_DATE PER_ALL_ASSIGNMENTS_F.CREATION_DATE%TYPE,
794: SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE,
787: HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE,
788: HOURLY_SALARIED_CODE_MEANING VARCHAR2(240),
789: LAST_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_DATE%TYPE,
790: LAST_UPDATED_BY PER_ALL_ASSIGNMENTS_F.LAST_UPDATED_BY%TYPE,
791: LAST_UPDATE_LOGIN PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_LOGIN%TYPE,
792: CREATED_BY PER_ALL_ASSIGNMENTS_F.CREATED_BY%TYPE,
793: CREATION_DATE PER_ALL_ASSIGNMENTS_F.CREATION_DATE%TYPE,
794: SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE,
795: SAL_REV_PERIOD_FREQ_MEANING VARCHAR2(240),
788: HOURLY_SALARIED_CODE_MEANING VARCHAR2(240),
789: LAST_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_DATE%TYPE,
790: LAST_UPDATED_BY PER_ALL_ASSIGNMENTS_F.LAST_UPDATED_BY%TYPE,
791: LAST_UPDATE_LOGIN PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_LOGIN%TYPE,
792: CREATED_BY PER_ALL_ASSIGNMENTS_F.CREATED_BY%TYPE,
793: CREATION_DATE PER_ALL_ASSIGNMENTS_F.CREATION_DATE%TYPE,
794: SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE,
795: SAL_REV_PERIOD_FREQ_MEANING VARCHAR2(240),
796: SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE,
789: LAST_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_DATE%TYPE,
790: LAST_UPDATED_BY PER_ALL_ASSIGNMENTS_F.LAST_UPDATED_BY%TYPE,
791: LAST_UPDATE_LOGIN PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_LOGIN%TYPE,
792: CREATED_BY PER_ALL_ASSIGNMENTS_F.CREATED_BY%TYPE,
793: CREATION_DATE PER_ALL_ASSIGNMENTS_F.CREATION_DATE%TYPE,
794: SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE,
795: SAL_REV_PERIOD_FREQ_MEANING VARCHAR2(240),
796: SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE,
797: PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE,
790: LAST_UPDATED_BY PER_ALL_ASSIGNMENTS_F.LAST_UPDATED_BY%TYPE,
791: LAST_UPDATE_LOGIN PER_ALL_ASSIGNMENTS_F.LAST_UPDATE_LOGIN%TYPE,
792: CREATED_BY PER_ALL_ASSIGNMENTS_F.CREATED_BY%TYPE,
793: CREATION_DATE PER_ALL_ASSIGNMENTS_F.CREATION_DATE%TYPE,
794: SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE,
795: SAL_REV_PERIOD_FREQ_MEANING VARCHAR2(240),
796: SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE,
797: PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE,
798: PERF_REV_PERIOD_FREQ_MEANING VARCHAR2(240),
792: CREATED_BY PER_ALL_ASSIGNMENTS_F.CREATED_BY%TYPE,
793: CREATION_DATE PER_ALL_ASSIGNMENTS_F.CREATION_DATE%TYPE,
794: SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE,
795: SAL_REV_PERIOD_FREQ_MEANING VARCHAR2(240),
796: SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE,
797: PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE,
798: PERF_REV_PERIOD_FREQ_MEANING VARCHAR2(240),
799: PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE,
800: PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE,
793: CREATION_DATE PER_ALL_ASSIGNMENTS_F.CREATION_DATE%TYPE,
794: SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE,
795: SAL_REV_PERIOD_FREQ_MEANING VARCHAR2(240),
796: SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE,
797: PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE,
798: PERF_REV_PERIOD_FREQ_MEANING VARCHAR2(240),
799: PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE,
800: PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE,
801: SALARY_BASIS PER_PAY_BASES.NAME%TYPE,
795: SAL_REV_PERIOD_FREQ_MEANING VARCHAR2(240),
796: SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE,
797: PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE,
798: PERF_REV_PERIOD_FREQ_MEANING VARCHAR2(240),
799: PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE,
800: PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE,
801: SALARY_BASIS PER_PAY_BASES.NAME%TYPE,
802: PAY_BASIS PER_PAY_BASES.PAY_BASIS%TYPE,
803: RECRUITER_ID PER_ALL_ASSIGNMENTS_F.RECRUITER_ID%TYPE,
796: SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE,
797: PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE,
798: PERF_REV_PERIOD_FREQ_MEANING VARCHAR2(240),
799: PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE,
800: PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE,
801: SALARY_BASIS PER_PAY_BASES.NAME%TYPE,
802: PAY_BASIS PER_PAY_BASES.PAY_BASIS%TYPE,
803: RECRUITER_ID PER_ALL_ASSIGNMENTS_F.RECRUITER_ID%TYPE,
804: PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE,
799: PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE,
800: PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE,
801: SALARY_BASIS PER_PAY_BASES.NAME%TYPE,
802: PAY_BASIS PER_PAY_BASES.PAY_BASIS%TYPE,
803: RECRUITER_ID PER_ALL_ASSIGNMENTS_F.RECRUITER_ID%TYPE,
804: PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE,
805: RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE,
806: SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE,
807: SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE,
800: PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE,
801: SALARY_BASIS PER_PAY_BASES.NAME%TYPE,
802: PAY_BASIS PER_PAY_BASES.PAY_BASIS%TYPE,
803: RECRUITER_ID PER_ALL_ASSIGNMENTS_F.RECRUITER_ID%TYPE,
804: PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE,
805: RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE,
806: SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE,
807: SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE,
808: VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE,
801: SALARY_BASIS PER_PAY_BASES.NAME%TYPE,
802: PAY_BASIS PER_PAY_BASES.PAY_BASIS%TYPE,
803: RECRUITER_ID PER_ALL_ASSIGNMENTS_F.RECRUITER_ID%TYPE,
804: PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE,
805: RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE,
806: SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE,
807: SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE,
808: VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE,
809: ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE,
802: PAY_BASIS PER_PAY_BASES.PAY_BASIS%TYPE,
803: RECRUITER_ID PER_ALL_ASSIGNMENTS_F.RECRUITER_ID%TYPE,
804: PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE,
805: RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE,
806: SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE,
807: SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE,
808: VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE,
809: ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE,
810: APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE,
803: RECRUITER_ID PER_ALL_ASSIGNMENTS_F.RECRUITER_ID%TYPE,
804: PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE,
805: RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE,
806: SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE,
807: SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE,
808: VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE,
809: ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE,
810: APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE,
811: DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE,
804: PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE,
805: RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE,
806: SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE,
807: SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE,
808: VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE,
809: ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE,
810: APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE,
811: DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE,
812: PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE,
805: RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE,
806: SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE,
807: SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE,
808: VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE,
809: ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE,
810: APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE,
811: DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE,
812: PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE,
813: SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE,
806: SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE,
807: SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE,
808: VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE,
809: ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE,
810: APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE,
811: DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE,
812: PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE,
813: SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE,
814: D_SET_OF_BOOKS GL_SETS_OF_BOOKS.NAME%TYPE,
807: SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE,
808: VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE,
809: ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE,
810: APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE,
811: DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE,
812: PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE,
813: SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE,
814: D_SET_OF_BOOKS GL_SETS_OF_BOOKS.NAME%TYPE,
815: GL_KEYFLEX_STRUCTURE GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
808: VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE,
809: ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE,
810: APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE,
811: DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE,
812: PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE,
813: SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE,
814: D_SET_OF_BOOKS GL_SETS_OF_BOOKS.NAME%TYPE,
815: GL_KEYFLEX_STRUCTURE GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
816: SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE,
809: ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE,
810: APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE,
811: DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE,
812: PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE,
813: SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE,
814: D_SET_OF_BOOKS GL_SETS_OF_BOOKS.NAME%TYPE,
815: GL_KEYFLEX_STRUCTURE GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
816: SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE,
817: REQUEST_ID PER_ALL_ASSIGNMENTS_F.REQUEST_ID%TYPE,
812: PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE,
813: SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE,
814: D_SET_OF_BOOKS GL_SETS_OF_BOOKS.NAME%TYPE,
815: GL_KEYFLEX_STRUCTURE GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
816: SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE,
817: REQUEST_ID PER_ALL_ASSIGNMENTS_F.REQUEST_ID%TYPE,
818: PROGRAM_APPLICATION_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_APPLICATION_ID%TYPE,
819: PROGRAM_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_ID%TYPE,
820: PROGRAM_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.PROGRAM_UPDATE_DATE%TYPE,
813: SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE,
814: D_SET_OF_BOOKS GL_SETS_OF_BOOKS.NAME%TYPE,
815: GL_KEYFLEX_STRUCTURE GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
816: SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE,
817: REQUEST_ID PER_ALL_ASSIGNMENTS_F.REQUEST_ID%TYPE,
818: PROGRAM_APPLICATION_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_APPLICATION_ID%TYPE,
819: PROGRAM_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_ID%TYPE,
820: PROGRAM_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.PROGRAM_UPDATE_DATE%TYPE,
821: ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE,
814: D_SET_OF_BOOKS GL_SETS_OF_BOOKS.NAME%TYPE,
815: GL_KEYFLEX_STRUCTURE GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
816: SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE,
817: REQUEST_ID PER_ALL_ASSIGNMENTS_F.REQUEST_ID%TYPE,
818: PROGRAM_APPLICATION_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_APPLICATION_ID%TYPE,
819: PROGRAM_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_ID%TYPE,
820: PROGRAM_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.PROGRAM_UPDATE_DATE%TYPE,
821: ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE,
822: ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE,
815: GL_KEYFLEX_STRUCTURE GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
816: SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE,
817: REQUEST_ID PER_ALL_ASSIGNMENTS_F.REQUEST_ID%TYPE,
818: PROGRAM_APPLICATION_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_APPLICATION_ID%TYPE,
819: PROGRAM_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_ID%TYPE,
820: PROGRAM_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.PROGRAM_UPDATE_DATE%TYPE,
821: ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE,
822: ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE,
823: ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE,
816: SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE,
817: REQUEST_ID PER_ALL_ASSIGNMENTS_F.REQUEST_ID%TYPE,
818: PROGRAM_APPLICATION_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_APPLICATION_ID%TYPE,
819: PROGRAM_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_ID%TYPE,
820: PROGRAM_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.PROGRAM_UPDATE_DATE%TYPE,
821: ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE,
822: ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE,
823: ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE,
824: ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE,
817: REQUEST_ID PER_ALL_ASSIGNMENTS_F.REQUEST_ID%TYPE,
818: PROGRAM_APPLICATION_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_APPLICATION_ID%TYPE,
819: PROGRAM_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_ID%TYPE,
820: PROGRAM_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.PROGRAM_UPDATE_DATE%TYPE,
821: ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE,
822: ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE,
823: ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE,
824: ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE,
825: ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE,
818: PROGRAM_APPLICATION_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_APPLICATION_ID%TYPE,
819: PROGRAM_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_ID%TYPE,
820: PROGRAM_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.PROGRAM_UPDATE_DATE%TYPE,
821: ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE,
822: ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE,
823: ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE,
824: ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE,
825: ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE,
826: ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE,
819: PROGRAM_ID PER_ALL_ASSIGNMENTS_F.PROGRAM_ID%TYPE,
820: PROGRAM_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.PROGRAM_UPDATE_DATE%TYPE,
821: ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE,
822: ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE,
823: ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE,
824: ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE,
825: ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE,
826: ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE,
827: ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE,
820: PROGRAM_UPDATE_DATE PER_ALL_ASSIGNMENTS_F.PROGRAM_UPDATE_DATE%TYPE,
821: ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE,
822: ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE,
823: ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE,
824: ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE,
825: ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE,
826: ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE,
827: ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE,
828: ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE,
821: ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE,
822: ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE,
823: ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE,
824: ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE,
825: ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE,
826: ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE,
827: ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE,
828: ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE,
829: ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE,
822: ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE,
823: ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE,
824: ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE,
825: ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE,
826: ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE,
827: ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE,
828: ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE,
829: ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE,
830: ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE,
823: ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE,
824: ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE,
825: ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE,
826: ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE,
827: ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE,
828: ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE,
829: ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE,
830: ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE,
831: ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE,
824: ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE,
825: ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE,
826: ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE,
827: ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE,
828: ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE,
829: ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE,
830: ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE,
831: ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE,
832: ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE,
825: ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE,
826: ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE,
827: ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE,
828: ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE,
829: ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE,
830: ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE,
831: ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE,
832: ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE,
833: ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE,
826: ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE,
827: ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE,
828: ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE,
829: ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE,
830: ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE,
831: ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE,
832: ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE,
833: ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE,
834: ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE,
827: ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE,
828: ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE,
829: ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE,
830: ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE,
831: ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE,
832: ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE,
833: ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE,
834: ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE,
835: ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE,
828: ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE,
829: ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE,
830: ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE,
831: ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE,
832: ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE,
833: ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE,
834: ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE,
835: ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE,
836: ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE,
829: ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE,
830: ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE,
831: ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE,
832: ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE,
833: ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE,
834: ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE,
835: ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE,
836: ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE,
837: ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE,
830: ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE,
831: ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE,
832: ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE,
833: ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE,
834: ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE,
835: ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE,
836: ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE,
837: ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE,
838: ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE,
831: ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE,
832: ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE,
833: ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE,
834: ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE,
835: ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE,
836: ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE,
837: ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE,
838: ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE,
839: ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE,
832: ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE,
833: ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE,
834: ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE,
835: ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE,
836: ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE,
837: ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE,
838: ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE,
839: ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE,
840: ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE,
833: ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE,
834: ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE,
835: ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE,
836: ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE,
837: ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE,
838: ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE,
839: ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE,
840: ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE,
841: ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE,
834: ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE,
835: ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE,
836: ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE,
837: ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE,
838: ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE,
839: ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE,
840: ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE,
841: ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE,
842: ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE,
835: ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE,
836: ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE,
837: ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE,
838: ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE,
839: ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE,
840: ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE,
841: ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE,
842: ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE,
843: ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE,
836: ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE,
837: ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE,
838: ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE,
839: ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE,
840: ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE,
841: ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE,
842: ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE,
843: ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE,
844: ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE,
837: ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE,
838: ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE,
839: ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE,
840: ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE,
841: ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE,
842: ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE,
843: ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE,
844: ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE,
845: ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE,
838: ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE,
839: ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE,
840: ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE,
841: ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE,
842: ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE,
843: ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE,
844: ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE,
845: ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE,
846: ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE,
839: ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE,
840: ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE,
841: ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE,
842: ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE,
843: ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE,
844: ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE,
845: ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE,
846: ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE,
847: ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE,
840: ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE,
841: ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE,
842: ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE,
843: ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE,
844: ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE,
845: ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE,
846: ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE,
847: ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE,
848: ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE,
841: ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE,
842: ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE,
843: ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE,
844: ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE,
845: ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE,
846: ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE,
847: ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE,
848: ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE,
849: ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE,
842: ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE,
843: ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE,
844: ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE,
845: ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE,
846: ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE,
847: ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE,
848: ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE,
849: ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE,
850: ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE,
843: ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE,
844: ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE,
845: ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE,
846: ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE,
847: ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE,
848: ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE,
849: ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE,
850: ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE,
851: ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE,
844: ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE,
845: ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE,
846: ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE,
847: ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE,
848: ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE,
849: ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE,
850: ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE,
851: ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE,
852: EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE,
845: ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE,
846: ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE,
847: ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE,
848: ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE,
849: ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE,
850: ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE,
851: ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE,
852: EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE,
853: EMPLOYMENT_CATEGORY_MEANING VARCHAR2(240),
846: ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE,
847: ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE,
848: ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE,
849: ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE,
850: ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE,
851: ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE,
852: EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE,
853: EMPLOYMENT_CATEGORY_MEANING VARCHAR2(240),
854: ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE,
847: ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE,
848: ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE,
849: ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE,
850: ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE,
851: ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE,
852: EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE,
853: EMPLOYMENT_CATEGORY_MEANING VARCHAR2(240),
854: ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE,
855: COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE,
848: ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE,
849: ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE,
850: ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE,
851: ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE,
852: EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE,
853: EMPLOYMENT_CATEGORY_MEANING VARCHAR2(240),
854: ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE,
855: COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE,
856: CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE,
850: ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE,
851: ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE,
852: EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE,
853: EMPLOYMENT_CATEGORY_MEANING VARCHAR2(240),
854: ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE,
855: COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE,
856: CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE,
857: CAGR_GRADE_DEF_ID PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID%TYPE,
858: CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE,
851: ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE,
852: EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE,
853: EMPLOYMENT_CATEGORY_MEANING VARCHAR2(240),
854: ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE,
855: COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE,
856: CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE,
857: CAGR_GRADE_DEF_ID PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID%TYPE,
858: CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE,
859: AGREEMENT_NAME PER_COLLECTIVE_AGREEMENTS.NAME%TYPE,
852: EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE,
853: EMPLOYMENT_CATEGORY_MEANING VARCHAR2(240),
854: ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE,
855: COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE,
856: CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE,
857: CAGR_GRADE_DEF_ID PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID%TYPE,
858: CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE,
859: AGREEMENT_NAME PER_COLLECTIVE_AGREEMENTS.NAME%TYPE,
860: ESTABLISHMENT_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE,
853: EMPLOYMENT_CATEGORY_MEANING VARCHAR2(240),
854: ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE,
855: COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE,
856: CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE,
857: CAGR_GRADE_DEF_ID PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID%TYPE,
858: CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE,
859: AGREEMENT_NAME PER_COLLECTIVE_AGREEMENTS.NAME%TYPE,
860: ESTABLISHMENT_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE,
861: REFERENCE PER_CONTRACTS_F.REFERENCE%TYPE,
854: ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE,
855: COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE,
856: CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE,
857: CAGR_GRADE_DEF_ID PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID%TYPE,
858: CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE,
859: AGREEMENT_NAME PER_COLLECTIVE_AGREEMENTS.NAME%TYPE,
860: ESTABLISHMENT_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE,
861: REFERENCE PER_CONTRACTS_F.REFERENCE%TYPE,
862: NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE,
858: CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE,
859: AGREEMENT_NAME PER_COLLECTIVE_AGREEMENTS.NAME%TYPE,
860: ESTABLISHMENT_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE,
861: REFERENCE PER_CONTRACTS_F.REFERENCE%TYPE,
862: NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE,
863: NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE,
864: NOTICE_PERIOD_UOM_MEANING VARCHAR2(240),
865: EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE,
866: EMPLOYEE_CATEGORY_MEANING VARCHAR2(240),
859: AGREEMENT_NAME PER_COLLECTIVE_AGREEMENTS.NAME%TYPE,
860: ESTABLISHMENT_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE,
861: REFERENCE PER_CONTRACTS_F.REFERENCE%TYPE,
862: NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE,
863: NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE,
864: NOTICE_PERIOD_UOM_MEANING VARCHAR2(240),
865: EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE,
866: EMPLOYEE_CATEGORY_MEANING VARCHAR2(240),
867: WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE,
861: REFERENCE PER_CONTRACTS_F.REFERENCE%TYPE,
862: NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE,
863: NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE,
864: NOTICE_PERIOD_UOM_MEANING VARCHAR2(240),
865: EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE,
866: EMPLOYEE_CATEGORY_MEANING VARCHAR2(240),
867: WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE,
868: JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE,
869: TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE,
863: NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE,
864: NOTICE_PERIOD_UOM_MEANING VARCHAR2(240),
865: EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE,
866: EMPLOYEE_CATEGORY_MEANING VARCHAR2(240),
867: WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE,
868: JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE,
869: TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE,
870: PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE,
871: PERIOD_OF_PLACEMENT_DATE_START PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START%TYPE,
864: NOTICE_PERIOD_UOM_MEANING VARCHAR2(240),
865: EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE,
866: EMPLOYEE_CATEGORY_MEANING VARCHAR2(240),
867: WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE,
868: JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE,
869: TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE,
870: PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE,
871: PERIOD_OF_PLACEMENT_DATE_START PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START%TYPE,
872: VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE,
865: EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE,
866: EMPLOYEE_CATEGORY_MEANING VARCHAR2(240),
867: WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE,
868: JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE,
869: TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE,
870: PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE,
871: PERIOD_OF_PLACEMENT_DATE_START PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START%TYPE,
872: VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE,
873: VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE,
866: EMPLOYEE_CATEGORY_MEANING VARCHAR2(240),
867: WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE,
868: JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE,
869: TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE,
870: PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE,
871: PERIOD_OF_PLACEMENT_DATE_START PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START%TYPE,
872: VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE,
873: VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE,
874: VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE,
867: WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE,
868: JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE,
869: TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE,
870: PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE,
871: PERIOD_OF_PLACEMENT_DATE_START PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START%TYPE,
872: VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE,
873: VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE,
874: VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE,
875: VENDOR_SITE_CODE PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
868: JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE,
869: TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE,
870: PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE,
871: PERIOD_OF_PLACEMENT_DATE_START PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START%TYPE,
872: VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE,
873: VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE,
874: VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE,
875: VENDOR_SITE_CODE PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
876: PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE,
870: PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE,
871: PERIOD_OF_PLACEMENT_DATE_START PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START%TYPE,
872: VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE,
873: VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE,
874: VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE,
875: VENDOR_SITE_CODE PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
876: PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE,
877: PO_NUMBER PO_HEADERS_ALL.SEGMENT1%TYPE,
878: PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE,
872: VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE,
873: VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE,
874: VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE,
875: VENDOR_SITE_CODE PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
876: PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE,
877: PO_NUMBER PO_HEADERS_ALL.SEGMENT1%TYPE,
878: PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE,
879: PO_LINE_NUMBER PO_LINES_ALL.LINE_NUM%TYPE,
880: PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE,
874: VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE,
875: VENDOR_SITE_CODE PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
876: PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE,
877: PO_NUMBER PO_HEADERS_ALL.SEGMENT1%TYPE,
878: PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE,
879: PO_LINE_NUMBER PO_LINES_ALL.LINE_NUM%TYPE,
880: PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE,
881: VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE,
882: VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE,
876: PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE,
877: PO_NUMBER PO_HEADERS_ALL.SEGMENT1%TYPE,
878: PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE,
879: PO_LINE_NUMBER PO_LINES_ALL.LINE_NUM%TYPE,
880: PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE,
881: VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE,
882: VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE,
883: ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE,
884: GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE,
877: PO_NUMBER PO_HEADERS_ALL.SEGMENT1%TYPE,
878: PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE,
879: PO_LINE_NUMBER PO_LINES_ALL.LINE_NUM%TYPE,
880: PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE,
881: VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE,
882: VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE,
883: ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE,
884: GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE,
885: SUPERVISOR_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID%TYPE,
878: PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE,
879: PO_LINE_NUMBER PO_LINES_ALL.LINE_NUM%TYPE,
880: PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE,
881: VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE,
882: VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE,
883: ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE,
884: GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE,
885: SUPERVISOR_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID%TYPE,
886: GRADE_LADDER_NAME BEN_PGM_F.NAME%TYPE,
879: PO_LINE_NUMBER PO_LINES_ALL.LINE_NUM%TYPE,
880: PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE,
881: VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE,
882: VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE,
883: ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE,
884: GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE,
885: SUPERVISOR_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID%TYPE,
886: GRADE_LADDER_NAME BEN_PGM_F.NAME%TYPE,
887: SUPERVISOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
880: PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE,
881: VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE,
882: VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE,
883: ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE,
884: GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE,
885: SUPERVISOR_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID%TYPE,
886: GRADE_LADDER_NAME BEN_PGM_F.NAME%TYPE,
887: SUPERVISOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
888: );
881: VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE,
882: VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE,
883: ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE,
884: GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE,
885: SUPERVISOR_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID%TYPE,
886: GRADE_LADDER_NAME BEN_PGM_F.NAME%TYPE,
887: SUPERVISOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
888: );
889:
883: ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE,
884: GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE,
885: SUPERVISOR_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID%TYPE,
886: GRADE_LADDER_NAME BEN_PGM_F.NAME%TYPE,
887: SUPERVISOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
888: );
889:
890: -- update_assgn_context_value
891: --
888: );
889:
890: -- update_assgn_context_value
891: --
892: -- populates the per_all_assignments_f.ass_attribute_category value
893: --
894: PROCEDURE update_assgn_context_value(
895: p_business_group_id IN number
896: ,p_person_id IN number