11: Type srch_criteria_record is RECORD
12: (p_person_id per_all_people_f.person_id%type default null,
13: p_start_person_id per_all_people_f.person_id%type default null,
14: p_end_person_id per_all_people_f.person_id%type default null,
15: p_assignment_id per_all_assignments_f.assignment_id%type default null,
16: p_first_name per_all_people_f.first_name%type default null,
17: p_last_name per_all_people_f.last_name%type default null,
18: p_bgrp_name hr_all_organization_units.name%type default null,
19: p_bgrp_id hr_all_organization_units.business_group_id%type default null,
199: );
200: /*Record type for assignment details*/
201: TYPE ASSGN_DETAILS is record
202: (
203: ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE
204: , EFFECTIVE_START_DATE varchar2(10)
205: , EFFECTIVE_END_DATE varchar2(10)
206: , RECRUITER_ID PER_ALL_ASSIGNMENTS_F.RECRUITER_ID%TYPE
207: , GRADE_ID PER_ALL_ASSIGNMENTS_F.GRADE_ID%TYPE
202: (
203: ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE
204: , EFFECTIVE_START_DATE varchar2(10)
205: , EFFECTIVE_END_DATE varchar2(10)
206: , RECRUITER_ID PER_ALL_ASSIGNMENTS_F.RECRUITER_ID%TYPE
207: , GRADE_ID PER_ALL_ASSIGNMENTS_F.GRADE_ID%TYPE
208: , GRADE_DESC PER_GRADES_TL.NAME%TYPE --(BASED ON LANG)
209: , POSITION_ID PER_ALL_ASSIGNMENTS_F.POSITION_ID%TYPE
210: , POSITION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE --(BASED ON LANG)
203: ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE
204: , EFFECTIVE_START_DATE varchar2(10)
205: , EFFECTIVE_END_DATE varchar2(10)
206: , RECRUITER_ID PER_ALL_ASSIGNMENTS_F.RECRUITER_ID%TYPE
207: , GRADE_ID PER_ALL_ASSIGNMENTS_F.GRADE_ID%TYPE
208: , GRADE_DESC PER_GRADES_TL.NAME%TYPE --(BASED ON LANG)
209: , POSITION_ID PER_ALL_ASSIGNMENTS_F.POSITION_ID%TYPE
210: , POSITION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE --(BASED ON LANG)
211: , JOB_ID PER_ALL_ASSIGNMENTS_F.JOB_ID%TYPE
205: , EFFECTIVE_END_DATE varchar2(10)
206: , RECRUITER_ID PER_ALL_ASSIGNMENTS_F.RECRUITER_ID%TYPE
207: , GRADE_ID PER_ALL_ASSIGNMENTS_F.GRADE_ID%TYPE
208: , GRADE_DESC PER_GRADES_TL.NAME%TYPE --(BASED ON LANG)
209: , POSITION_ID PER_ALL_ASSIGNMENTS_F.POSITION_ID%TYPE
210: , POSITION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE --(BASED ON LANG)
211: , JOB_ID PER_ALL_ASSIGNMENTS_F.JOB_ID%TYPE
212: , JOB_DESC PER_JOBS_TL.NAME%TYPE --(BASED ON LANG)
213: , ASSIGNMENT_STATUS_TYPE_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE
207: , GRADE_ID PER_ALL_ASSIGNMENTS_F.GRADE_ID%TYPE
208: , GRADE_DESC PER_GRADES_TL.NAME%TYPE --(BASED ON LANG)
209: , POSITION_ID PER_ALL_ASSIGNMENTS_F.POSITION_ID%TYPE
210: , POSITION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE --(BASED ON LANG)
211: , JOB_ID PER_ALL_ASSIGNMENTS_F.JOB_ID%TYPE
212: , JOB_DESC PER_JOBS_TL.NAME%TYPE --(BASED ON LANG)
213: , ASSIGNMENT_STATUS_TYPE_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE
214: , USER_STATUS PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE
215: , PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE
209: , POSITION_ID PER_ALL_ASSIGNMENTS_F.POSITION_ID%TYPE
210: , POSITION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE --(BASED ON LANG)
211: , JOB_ID PER_ALL_ASSIGNMENTS_F.JOB_ID%TYPE
212: , JOB_DESC PER_JOBS_TL.NAME%TYPE --(BASED ON LANG)
213: , ASSIGNMENT_STATUS_TYPE_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE
214: , USER_STATUS PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE
215: , PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE
216: , PER_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PER_SYSTEM_STATUS%TYPE
217: , PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE
213: , ASSIGNMENT_STATUS_TYPE_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE
214: , USER_STATUS PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE
215: , PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE
216: , PER_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PER_SYSTEM_STATUS%TYPE
217: , PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE
218: , PAYROLL_DESC PAY_PAYROLLS_F.PAYROLL_NAME%TYPE
219: , LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE
220: , LOCATION_DESC HR_LOCATIONS_ALL_TL.DESCRIPTION%TYPE --(BASED ON LANG)
221: , PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE
215: , PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE
216: , PER_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PER_SYSTEM_STATUS%TYPE
217: , PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE
218: , PAYROLL_DESC PAY_PAYROLLS_F.PAYROLL_NAME%TYPE
219: , LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE
220: , LOCATION_DESC HR_LOCATIONS_ALL_TL.DESCRIPTION%TYPE --(BASED ON LANG)
221: , PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE
222: , SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE
223: , SUPERVISOR_EMP_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE
217: , PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE
218: , PAYROLL_DESC PAY_PAYROLLS_F.PAYROLL_NAME%TYPE
219: , LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE
220: , LOCATION_DESC HR_LOCATIONS_ALL_TL.DESCRIPTION%TYPE --(BASED ON LANG)
221: , PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE
222: , SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE
223: , SUPERVISOR_EMP_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE
224: , SUPERVISOR_CWK_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE
225: , SUPERVISOR_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE
218: , PAYROLL_DESC PAY_PAYROLLS_F.PAYROLL_NAME%TYPE
219: , LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE
220: , LOCATION_DESC HR_LOCATIONS_ALL_TL.DESCRIPTION%TYPE --(BASED ON LANG)
221: , PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE
222: , SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE
223: , SUPERVISOR_EMP_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE
224: , SUPERVISOR_CWK_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE
225: , SUPERVISOR_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE
226: , SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE
222: , SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE
223: , SUPERVISOR_EMP_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE
224: , SUPERVISOR_CWK_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE
225: , SUPERVISOR_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE
226: , SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE
227: , RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE
228: , SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE
229: , ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE
230: , ORGANIZATION_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE -- (BASED ON LANG)
223: , SUPERVISOR_EMP_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE
224: , SUPERVISOR_CWK_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE
225: , SUPERVISOR_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE
226: , SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE
227: , RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE
228: , SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE
229: , ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE
230: , ORGANIZATION_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE -- (BASED ON LANG)
231: , PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE
224: , SUPERVISOR_CWK_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE
225: , SUPERVISOR_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE
226: , SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE
227: , RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE
228: , SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE
229: , ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE
230: , ORGANIZATION_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE -- (BASED ON LANG)
231: , PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE
232: , SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE
225: , SUPERVISOR_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE
226: , SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE
227: , RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE
228: , SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE
229: , ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE
230: , ORGANIZATION_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE -- (BASED ON LANG)
231: , PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE
232: , SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE
233: , VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE
227: , RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE
228: , SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE
229: , ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE
230: , ORGANIZATION_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE -- (BASED ON LANG)
231: , PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE
232: , SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE
233: , VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE
234: , VACANCY_DESC PER_VACANCIES.NAME%TYPE
235: , PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE
228: , SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE
229: , ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE
230: , ORGANIZATION_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE -- (BASED ON LANG)
231: , PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE
232: , SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE
233: , VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE
234: , VACANCY_DESC PER_VACANCIES.NAME%TYPE
235: , PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE
236: , PAY_BASIS_DESC PER_PAY_BASES.NAME%TYPE
229: , ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE
230: , ORGANIZATION_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE -- (BASED ON LANG)
231: , PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE
232: , SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE
233: , VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE
234: , VACANCY_DESC PER_VACANCIES.NAME%TYPE
235: , PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE
236: , PAY_BASIS_DESC PER_PAY_BASES.NAME%TYPE
237: , ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE
231: , PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE
232: , SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE
233: , VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE
234: , VACANCY_DESC PER_VACANCIES.NAME%TYPE
235: , PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE
236: , PAY_BASIS_DESC PER_PAY_BASES.NAME%TYPE
237: , ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE
238: , ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE -- LIKE E,C ETC
239: , PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE -- CHECK BOX
233: , VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE
234: , VACANCY_DESC PER_VACANCIES.NAME%TYPE
235: , PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE
236: , PAY_BASIS_DESC PER_PAY_BASES.NAME%TYPE
237: , ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE
238: , ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE -- LIKE E,C ETC
239: , PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE -- CHECK BOX
240: , APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE
241: , ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
234: , VACANCY_DESC PER_VACANCIES.NAME%TYPE
235: , PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE
236: , PAY_BASIS_DESC PER_PAY_BASES.NAME%TYPE
237: , ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE
238: , ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE -- LIKE E,C ETC
239: , PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE -- CHECK BOX
240: , APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE
241: , ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
242: , CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE
235: , PAY_BASIS_ID PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID%TYPE
236: , PAY_BASIS_DESC PER_PAY_BASES.NAME%TYPE
237: , ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE
238: , ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE -- LIKE E,C ETC
239: , PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE -- CHECK BOX
240: , APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE
241: , ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
242: , CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE
243: , CHANGE_REASON_DESC FND_LOOKUP_VALUES.MEANING%TYPE -- (BASED ON LANG /'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON')
236: , PAY_BASIS_DESC PER_PAY_BASES.NAME%TYPE
237: , ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE
238: , ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE -- LIKE E,C ETC
239: , PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE -- CHECK BOX
240: , APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE
241: , ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
242: , CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE
243: , CHANGE_REASON_DESC FND_LOOKUP_VALUES.MEANING%TYPE -- (BASED ON LANG /'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON')
244: , COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE
237: , ASSIGNMENT_SEQUENCE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE
238: , ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE -- LIKE E,C ETC
239: , PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE -- CHECK BOX
240: , APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE
241: , ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
242: , CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE
243: , CHANGE_REASON_DESC FND_LOOKUP_VALUES.MEANING%TYPE -- (BASED ON LANG /'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON')
244: , COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE
245: , DATE_PROBATION_END varchar2(10)
238: , ASSIGNMENT_TYPE PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE -- LIKE E,C ETC
239: , PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE -- CHECK BOX
240: , APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE
241: , ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
242: , CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE
243: , CHANGE_REASON_DESC FND_LOOKUP_VALUES.MEANING%TYPE -- (BASED ON LANG /'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON')
244: , COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE
245: , DATE_PROBATION_END varchar2(10)
246: , DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE
240: , APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE
241: , ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
242: , CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE
243: , CHANGE_REASON_DESC FND_LOOKUP_VALUES.MEANING%TYPE -- (BASED ON LANG /'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON')
244: , COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE
245: , DATE_PROBATION_END varchar2(10)
246: , DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE
247: , EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE
248: , EMPLOYMENT_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMP_CAT')
242: , CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE
243: , CHANGE_REASON_DESC FND_LOOKUP_VALUES.MEANING%TYPE -- (BASED ON LANG /'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON')
244: , COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE
245: , DATE_PROBATION_END varchar2(10)
246: , DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE
247: , EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE
248: , EMPLOYMENT_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMP_CAT')
249: , FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE
250: , FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
243: , CHANGE_REASON_DESC FND_LOOKUP_VALUES.MEANING%TYPE -- (BASED ON LANG /'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON')
244: , COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE
245: , DATE_PROBATION_END varchar2(10)
246: , DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE
247: , EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE
248: , EMPLOYMENT_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMP_CAT')
249: , FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE
250: , FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
251: , INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE
245: , DATE_PROBATION_END varchar2(10)
246: , DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE
247: , EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE
248: , EMPLOYMENT_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMP_CAT')
249: , FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE
250: , FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
251: , INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE
252: , MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE -- CHECK BOX
253: , NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE
247: , EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE
248: , EMPLOYMENT_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMP_CAT')
249: , FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE
250: , FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
251: , INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE
252: , MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE -- CHECK BOX
253: , NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE
254: , PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE
255: , PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE
248: , EMPLOYMENT_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMP_CAT')
249: , FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE
250: , FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
251: , INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE
252: , MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE -- CHECK BOX
253: , NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE
254: , PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE
255: , PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE
256: , PERF_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
249: , FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE
250: , FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
251: , INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE
252: , MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE -- CHECK BOX
253: , NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE
254: , PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE
255: , PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE
256: , PERF_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
257: , PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE
250: , FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
251: , INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE
252: , MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE -- CHECK BOX
253: , NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE
254: , PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE
255: , PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE
256: , PERF_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
257: , PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE
258: , PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE
251: , INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE
252: , MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE -- CHECK BOX
253: , NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE
254: , PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE
255: , PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE
256: , PERF_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
257: , PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE
258: , PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE
259: , PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE
253: , NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE
254: , PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE
255: , PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE
256: , PERF_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
257: , PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE
258: , PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE
259: , PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE
260: , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')
261: , SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE
254: , PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE
255: , PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE
256: , PERF_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
257: , PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE
258: , PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE
259: , PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE
260: , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')
261: , SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE
262: , SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE
255: , PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE
256: , PERF_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
257: , PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE
258: , PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE
259: , PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE
260: , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')
261: , SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE
262: , SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE
263: , SAL_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
257: , PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE
258: , PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE
259: , PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE
260: , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')
261: , SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE
262: , SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE
263: , SAL_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
264: , SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE
265: , SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE
258: , PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE
259: , PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE
260: , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')
261: , SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE
262: , SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE
263: , SAL_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
264: , SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE
265: , SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE
266: , TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE
260: , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')
261: , SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE
262: , SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE
263: , SAL_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
264: , SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE
265: , SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE
266: , TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE
267: , TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE
268: , BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE
261: , SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE
262: , SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE
263: , SAL_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
264: , SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE
265: , SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE
266: , TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE
267: , TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE
268: , BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE
269: , BARGAINING_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'BARGAINING_UNIT_CODE')
262: , SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE
263: , SAL_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
264: , SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE
265: , SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE
266: , TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE
267: , TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE
268: , BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE
269: , BARGAINING_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'BARGAINING_UNIT_CODE')
270: , LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE -- CHECK BOX
263: , SAL_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
264: , SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE
265: , SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE
266: , TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE
267: , TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE
268: , BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE
269: , BARGAINING_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'BARGAINING_UNIT_CODE')
270: , LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE -- CHECK BOX
271: , HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE
264: , SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE
265: , SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE
266: , TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE
267: , TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE
268: , BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE
269: , BARGAINING_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'BARGAINING_UNIT_CODE')
270: , LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE -- CHECK BOX
271: , HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE
272: , HOURLY_SALARIED_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'HOURLY_SALARIED_CODE')
266: , TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE
267: , TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE
268: , BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE
269: , BARGAINING_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'BARGAINING_UNIT_CODE')
270: , LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE -- CHECK BOX
271: , HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE
272: , HOURLY_SALARIED_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'HOURLY_SALARIED_CODE')
273: , CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE
274: , COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE
267: , TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE
268: , BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE
269: , BARGAINING_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'BARGAINING_UNIT_CODE')
270: , LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE -- CHECK BOX
271: , HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE
272: , HOURLY_SALARIED_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'HOURLY_SALARIED_CODE')
273: , CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE
274: , COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE
275: , COLLECTIVE_AGREEMENT_DESC PER_COLLECTIVE_AGREEMENTS.NAME%TYPE
269: , BARGAINING_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'BARGAINING_UNIT_CODE')
270: , LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE -- CHECK BOX
271: , HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE
272: , HOURLY_SALARIED_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'HOURLY_SALARIED_CODE')
273: , CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE
274: , COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE
275: , COLLECTIVE_AGREEMENT_DESC PER_COLLECTIVE_AGREEMENTS.NAME%TYPE
276: , CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE
277: , CAGR_GRADE_DEF_ID PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID%TYPE
270: , LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE -- CHECK BOX
271: , HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE
272: , HOURLY_SALARIED_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'HOURLY_SALARIED_CODE')
273: , CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE
274: , COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE
275: , COLLECTIVE_AGREEMENT_DESC PER_COLLECTIVE_AGREEMENTS.NAME%TYPE
276: , CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE
277: , CAGR_GRADE_DEF_ID PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID%TYPE
278: , ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE
272: , HOURLY_SALARIED_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'HOURLY_SALARIED_CODE')
273: , CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE
274: , COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE
275: , COLLECTIVE_AGREEMENT_DESC PER_COLLECTIVE_AGREEMENTS.NAME%TYPE
276: , CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE
277: , CAGR_GRADE_DEF_ID PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID%TYPE
278: , ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE
279: , ESTABLISHMENT_DESC HR_ESTABLISHMENTS_V.NAME%TYPE
280: , ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE
273: , CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE
274: , COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE
275: , COLLECTIVE_AGREEMENT_DESC PER_COLLECTIVE_AGREEMENTS.NAME%TYPE
276: , CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE
277: , CAGR_GRADE_DEF_ID PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID%TYPE
278: , ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE
279: , ESTABLISHMENT_DESC HR_ESTABLISHMENTS_V.NAME%TYPE
280: , ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE
281: , ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE
274: , COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE
275: , COLLECTIVE_AGREEMENT_DESC PER_COLLECTIVE_AGREEMENTS.NAME%TYPE
276: , CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE
277: , CAGR_GRADE_DEF_ID PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID%TYPE
278: , ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE
279: , ESTABLISHMENT_DESC HR_ESTABLISHMENTS_V.NAME%TYPE
280: , ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE
281: , ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE
282: , ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE
276: , CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE
277: , CAGR_GRADE_DEF_ID PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID%TYPE
278: , ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE
279: , ESTABLISHMENT_DESC HR_ESTABLISHMENTS_V.NAME%TYPE
280: , ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE
281: , ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE
282: , ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE
283: , ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE
284: , ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE
277: , CAGR_GRADE_DEF_ID PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID%TYPE
278: , ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE
279: , ESTABLISHMENT_DESC HR_ESTABLISHMENTS_V.NAME%TYPE
280: , ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE
281: , ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE
282: , ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE
283: , ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE
284: , ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE
285: , ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE
278: , ESTABLISHMENT_ID PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID%TYPE
279: , ESTABLISHMENT_DESC HR_ESTABLISHMENTS_V.NAME%TYPE
280: , ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE
281: , ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE
282: , ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE
283: , ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE
284: , ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE
285: , ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE
286: , ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE
279: , ESTABLISHMENT_DESC HR_ESTABLISHMENTS_V.NAME%TYPE
280: , ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE
281: , ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE
282: , ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE
283: , ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE
284: , ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE
285: , ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE
286: , ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE
287: , ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE
280: , ASS_ATTRIBUTE_CATEGORY PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE_CATEGORY%TYPE
281: , ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE
282: , ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE
283: , ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE
284: , ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE
285: , ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE
286: , ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE
287: , ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE
288: , ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE
281: , ASS_ATTRIBUTE1 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE1%TYPE
282: , ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE
283: , ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE
284: , ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE
285: , ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE
286: , ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE
287: , ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE
288: , ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE
289: , ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE
282: , ASS_ATTRIBUTE2 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE2%TYPE
283: , ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE
284: , ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE
285: , ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE
286: , ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE
287: , ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE
288: , ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE
289: , ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE
290: , ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE
283: , ASS_ATTRIBUTE3 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE3%TYPE
284: , ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE
285: , ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE
286: , ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE
287: , ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE
288: , ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE
289: , ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE
290: , ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE
291: , ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE
284: , ASS_ATTRIBUTE4 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE4%TYPE
285: , ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE
286: , ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE
287: , ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE
288: , ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE
289: , ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE
290: , ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE
291: , ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE
292: , ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE
285: , ASS_ATTRIBUTE5 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE5%TYPE
286: , ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE
287: , ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE
288: , ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE
289: , ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE
290: , ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE
291: , ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE
292: , ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE
293: , ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE
286: , ASS_ATTRIBUTE6 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE6%TYPE
287: , ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE
288: , ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE
289: , ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE
290: , ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE
291: , ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE
292: , ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE
293: , ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE
294: , ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE
287: , ASS_ATTRIBUTE7 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE7%TYPE
288: , ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE
289: , ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE
290: , ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE
291: , ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE
292: , ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE
293: , ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE
294: , ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE
295: , ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE
288: , ASS_ATTRIBUTE8 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE8%TYPE
289: , ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE
290: , ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE
291: , ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE
292: , ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE
293: , ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE
294: , ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE
295: , ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE
296: , ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE
289: , ASS_ATTRIBUTE9 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE9%TYPE
290: , ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE
291: , ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE
292: , ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE
293: , ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE
294: , ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE
295: , ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE
296: , ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE
297: , ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE
290: , ASS_ATTRIBUTE10 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE10%TYPE
291: , ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE
292: , ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE
293: , ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE
294: , ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE
295: , ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE
296: , ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE
297: , ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE
298: , ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE
291: , ASS_ATTRIBUTE11 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE11%TYPE
292: , ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE
293: , ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE
294: , ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE
295: , ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE
296: , ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE
297: , ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE
298: , ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE
299: , ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE
292: , ASS_ATTRIBUTE12 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE12%TYPE
293: , ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE
294: , ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE
295: , ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE
296: , ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE
297: , ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE
298: , ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE
299: , ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE
300: , ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE
293: , ASS_ATTRIBUTE13 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE13%TYPE
294: , ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE
295: , ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE
296: , ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE
297: , ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE
298: , ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE
299: , ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE
300: , ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE
301: , ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE
294: , ASS_ATTRIBUTE14 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE14%TYPE
295: , ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE
296: , ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE
297: , ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE
298: , ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE
299: , ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE
300: , ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE
301: , ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE
302: , ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE
295: , ASS_ATTRIBUTE15 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE15%TYPE
296: , ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE
297: , ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE
298: , ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE
299: , ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE
300: , ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE
301: , ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE
302: , ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE
303: , ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE
296: , ASS_ATTRIBUTE16 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE16%TYPE
297: , ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE
298: , ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE
299: , ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE
300: , ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE
301: , ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE
302: , ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE
303: , ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE
304: , ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE
297: , ASS_ATTRIBUTE17 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE17%TYPE
298: , ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE
299: , ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE
300: , ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE
301: , ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE
302: , ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE
303: , ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE
304: , ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE
305: , ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE
298: , ASS_ATTRIBUTE18 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE18%TYPE
299: , ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE
300: , ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE
301: , ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE
302: , ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE
303: , ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE
304: , ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE
305: , ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE
306: , ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE
299: , ASS_ATTRIBUTE19 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE19%TYPE
300: , ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE
301: , ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE
302: , ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE
303: , ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE
304: , ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE
305: , ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE
306: , ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE
307: , ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE
300: , ASS_ATTRIBUTE20 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE20%TYPE
301: , ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE
302: , ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE
303: , ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE
304: , ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE
305: , ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE
306: , ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE
307: , ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE
308: , ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE
301: , ASS_ATTRIBUTE21 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE21%TYPE
302: , ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE
303: , ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE
304: , ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE
305: , ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE
306: , ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE
307: , ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE
308: , ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE
309: , ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE
302: , ASS_ATTRIBUTE22 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE22%TYPE
303: , ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE
304: , ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE
305: , ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE
306: , ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE
307: , ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE
308: , ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE
309: , ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE
310: , ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE
303: , ASS_ATTRIBUTE23 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE23%TYPE
304: , ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE
305: , ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE
306: , ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE
307: , ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE
308: , ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE
309: , ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE
310: , ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE
311: , TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE
304: , ASS_ATTRIBUTE24 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE24%TYPE
305: , ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE
306: , ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE
307: , ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE
308: , ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE
309: , ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE
310: , ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE
311: , TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE
312: , NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE
305: , ASS_ATTRIBUTE25 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE25%TYPE
306: , ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE
307: , ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE
308: , ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE
309: , ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE
310: , ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE
311: , TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE
312: , NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE
313: , NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE
306: , ASS_ATTRIBUTE26 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE26%TYPE
307: , ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE
308: , ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE
309: , ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE
310: , ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE
311: , TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE
312: , NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE
313: , NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE
314: , EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE
307: , ASS_ATTRIBUTE27 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE27%TYPE
308: , ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE
309: , ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE
310: , ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE
311: , TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE
312: , NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE
313: , NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE
314: , EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE
315: , EMPLOYEE_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMPLOYEE_CATG')
308: , ASS_ATTRIBUTE28 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE28%TYPE
309: , ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE
310: , ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE
311: , TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE
312: , NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE
313: , NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE
314: , EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE
315: , EMPLOYEE_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMPLOYEE_CATG')
316: , WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE -- CHECK BOX
309: , ASS_ATTRIBUTE29 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE29%TYPE
310: , ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE
311: , TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE
312: , NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE
313: , NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE
314: , EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE
315: , EMPLOYEE_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMPLOYEE_CATG')
316: , WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE -- CHECK BOX
317: , JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE
310: , ASS_ATTRIBUTE30 PER_ALL_ASSIGNMENTS_F.ASS_ATTRIBUTE30%TYPE
311: , TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE
312: , NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE
313: , NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE
314: , EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE
315: , EMPLOYEE_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMPLOYEE_CATG')
316: , WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE -- CHECK BOX
317: , JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE
318: , POSTING_CONTENT_ID PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID%TYPE
312: , NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE
313: , NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE
314: , EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE
315: , EMPLOYEE_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMPLOYEE_CATG')
316: , WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE -- CHECK BOX
317: , JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE
318: , POSTING_CONTENT_ID PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID%TYPE
319: , PERIOD_OF_PLACEMENT_DATE_START varchar2(10)
320: , VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE
313: , NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE
314: , EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE
315: , EMPLOYEE_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMPLOYEE_CATG')
316: , WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE -- CHECK BOX
317: , JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE
318: , POSTING_CONTENT_ID PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID%TYPE
319: , PERIOD_OF_PLACEMENT_DATE_START varchar2(10)
320: , VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE
321: , VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE
314: , EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE
315: , EMPLOYEE_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMPLOYEE_CATG')
316: , WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE -- CHECK BOX
317: , JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE
318: , POSTING_CONTENT_ID PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID%TYPE
319: , PERIOD_OF_PLACEMENT_DATE_START varchar2(10)
320: , VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE
321: , VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE
322: , VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE
316: , WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE -- CHECK BOX
317: , JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE
318: , POSTING_CONTENT_ID PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID%TYPE
319: , PERIOD_OF_PLACEMENT_DATE_START varchar2(10)
320: , VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE
321: , VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE
322: , VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE
323: , ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE
324: , PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE
317: , JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE
318: , POSTING_CONTENT_ID PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID%TYPE
319: , PERIOD_OF_PLACEMENT_DATE_START varchar2(10)
320: , VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE
321: , VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE
322: , VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE
323: , ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE
324: , PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE
325: , APPLICANT_RANK PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK%TYPE
318: , POSTING_CONTENT_ID PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID%TYPE
319: , PERIOD_OF_PLACEMENT_DATE_START varchar2(10)
320: , VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE
321: , VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE
322: , VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE
323: , ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE
324: , PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE
325: , APPLICANT_RANK PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK%TYPE
326: , VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE
319: , PERIOD_OF_PLACEMENT_DATE_START varchar2(10)
320: , VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE
321: , VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE
322: , VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE
323: , ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE
324: , PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE
325: , APPLICANT_RANK PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK%TYPE
326: , VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE
327: , PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE
320: , VENDOR_ID PER_ALL_ASSIGNMENTS_F.VENDOR_ID%TYPE
321: , VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE
322: , VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE
323: , ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE
324: , PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE
325: , APPLICANT_RANK PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK%TYPE
326: , VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE
327: , PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE
328: , PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE
321: , VENDOR_EMPLOYEE_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER%TYPE
322: , VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE
323: , ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE
324: , PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE
325: , APPLICANT_RANK PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK%TYPE
326: , VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE
327: , PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE
328: , PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE
329: , PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE
322: , VENDOR_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER%TYPE
323: , ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE
324: , PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE
325: , APPLICANT_RANK PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK%TYPE
326: , VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE
327: , PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE
328: , PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE
329: , PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE
330: , GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE
323: , ASSIGNMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY%TYPE
324: , PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE
325: , APPLICANT_RANK PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK%TYPE
326: , VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE
327: , PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE
328: , PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE
329: , PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE
330: , GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE
331: , GRADE_LADDER_PGM_NAME BEN_PGM_F.NAME%TYPE -- FOR PGM TYPE CODE GSP
324: , PROJECT_TITLE PER_ALL_ASSIGNMENTS_F.PROJECT_TITLE%TYPE
325: , APPLICANT_RANK PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK%TYPE
326: , VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE
327: , PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE
328: , PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE
329: , PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE
330: , GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE
331: , GRADE_LADDER_PGM_NAME BEN_PGM_F.NAME%TYPE -- FOR PGM TYPE CODE GSP
332: , SUPERVISOR_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID%TYPE
325: , APPLICANT_RANK PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK%TYPE
326: , VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE
327: , PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE
328: , PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE
329: , PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE
330: , GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE
331: , GRADE_LADDER_PGM_NAME BEN_PGM_F.NAME%TYPE -- FOR PGM TYPE CODE GSP
332: , SUPERVISOR_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID%TYPE
333: );
326: , VENDOR_SITE_ID PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID%TYPE
327: , PO_HEADER_ID PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID%TYPE
328: , PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE
329: , PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE
330: , GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE
331: , GRADE_LADDER_PGM_NAME BEN_PGM_F.NAME%TYPE -- FOR PGM TYPE CODE GSP
332: , SUPERVISOR_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID%TYPE
333: );
334:
328: , PO_LINE_ID PER_ALL_ASSIGNMENTS_F.PO_LINE_ID%TYPE
329: , PROJECTED_ASSIGNMENT_END PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END%TYPE
330: , GRADE_LADDER_PGM_ID PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID%TYPE
331: , GRADE_LADDER_PGM_NAME BEN_PGM_F.NAME%TYPE -- FOR PGM TYPE CODE GSP
332: , SUPERVISOR_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID%TYPE
333: );
334:
335: /*Record Type definition for Location Address*/
336:
1236: REPORTEE_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
1237: REPORTEE_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
1238: REPORTEE_CWK_NUMBER PER_ALL_PEOPLe_F.NPW_NUMBER%TYPE,
1239: REPORTEE_APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
1240: REPORTEE_LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE,
1241: REPORTEE_LOCATION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE, --(BASED ON LANG)E,
1242: REPORTEE_ASG_STATUS_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE,
1243: REPORTEE_ASG_STATUS_DESC PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE
1244: );
1238: REPORTEE_CWK_NUMBER PER_ALL_PEOPLe_F.NPW_NUMBER%TYPE,
1239: REPORTEE_APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
1240: REPORTEE_LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE,
1241: REPORTEE_LOCATION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE, --(BASED ON LANG)E,
1242: REPORTEE_ASG_STATUS_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE,
1243: REPORTEE_ASG_STATUS_DESC PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE
1244: );
1245:
1246: TYPE ABSENCE_DETAILS IS RECORD