DBA Data[Home] [Help]

APPS.HR_360_MESSAGE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 217: PER_ASSIGNMENT_STATUS_TYPES ST ,

213: PER_GRADES_TL GDT,
214: PER_JOBS_TL JBT ,
215: HR_LOCATIONS_ALL_TL LOCTL,
216: HR_LOCATIONS_ALL LOC,
217: PER_ASSIGNMENT_STATUS_TYPES ST ,
218: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
219: PER_ASS_STATUS_TYPE_AMENDS AMD,
220: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL,
221: HR_ALL_ORGANIZATION_UNITS O,

Line 218: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,

214: PER_JOBS_TL JBT ,
215: HR_LOCATIONS_ALL_TL LOCTL,
216: HR_LOCATIONS_ALL LOC,
217: PER_ASSIGNMENT_STATUS_TYPES ST ,
218: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
219: PER_ASS_STATUS_TYPE_AMENDS AMD,
220: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL,
221: HR_ALL_ORGANIZATION_UNITS O,
222: HR_ALL_ORGANIZATION_UNITS_TL OTL ,

Line 348: PER_ASSIGNMENT_STATUS_TYPES ST ,

344: SELECT ppf.full_name,
345: decode ( ppf.CURRENT_NPW_FLAG , 'Y',ppf.NPW_NUMBER,ppf.EMPLOYEE_NUMBER) employee_number ,
346: NVL(AMDTL.USER_STATUS , STTL.USER_STATUS) ASSIGNMENT_STATUS
347: FROM per_all_assignments_f papf , per_all_people_f ppf ,
348: PER_ASSIGNMENT_STATUS_TYPES ST ,
349: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
350: PER_ASS_STATUS_TYPE_AMENDS AMD,
351: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL
352:

Line 349: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,

345: decode ( ppf.CURRENT_NPW_FLAG , 'Y',ppf.NPW_NUMBER,ppf.EMPLOYEE_NUMBER) employee_number ,
346: NVL(AMDTL.USER_STATUS , STTL.USER_STATUS) ASSIGNMENT_STATUS
347: FROM per_all_assignments_f papf , per_all_people_f ppf ,
348: PER_ASSIGNMENT_STATUS_TYPES ST ,
349: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
350: PER_ASS_STATUS_TYPE_AMENDS AMD,
351: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL
352:
353: WHERE