APPS.HR_360_MESSAGE dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 219: PER_ASS_STATUS_TYPE_AMENDS AMD,

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 ,
223: HR_ALL_ORGANIZATION_UNITS_TL OTL1 ,

Line 220: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL,

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 ,
223: HR_ALL_ORGANIZATION_UNITS_TL OTL1 ,
224: pay_all_payrolls_f pay,

Line 350: PER_ASS_STATUS_TYPE_AMENDS AMD,

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
354: p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date

Line 351: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL

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
354: p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date
355: and p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date