eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_360_MESSAGE dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 216: PER_ASS_STATUS_TYPE_AMENDS AMD,

212: HR_LOCATIONS_ALL_TL LOCTL,
213: HR_LOCATIONS_ALL LOC,
214: PER_ASSIGNMENT_STATUS_TYPES ST ,
215: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
216: PER_ASS_STATUS_TYPE_AMENDS AMD,
217: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL,
218: HR_ALL_ORGANIZATION_UNITS O,
219: HR_ALL_ORGANIZATION_UNITS_TL OTL ,
220: HR_ALL_ORGANIZATION_UNITS_TL OTL1 ,

Line 217: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL,

213: HR_LOCATIONS_ALL LOC,
214: PER_ASSIGNMENT_STATUS_TYPES ST ,
215: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
216: PER_ASS_STATUS_TYPE_AMENDS AMD,
217: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL,
218: HR_ALL_ORGANIZATION_UNITS O,
219: HR_ALL_ORGANIZATION_UNITS_TL OTL ,
220: HR_ALL_ORGANIZATION_UNITS_TL OTL1 ,
221: pay_all_payrolls_f pay,

Line 342: PER_ASS_STATUS_TYPE_AMENDS AMD,

338: NVL(AMDTL.USER_STATUS , STTL.USER_STATUS) ASSIGNMENT_STATUS
339: FROM per_all_assignments_f papf , per_all_people_f ppf ,
340: PER_ASSIGNMENT_STATUS_TYPES ST ,
341: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
342: PER_ASS_STATUS_TYPE_AMENDS AMD,
343: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL
344:
345: WHERE
346: SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date

Line 343: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL

339: FROM per_all_assignments_f papf , per_all_people_f ppf ,
340: PER_ASSIGNMENT_STATUS_TYPES ST ,
341: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
342: PER_ASS_STATUS_TYPE_AMENDS AMD,
343: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL
344:
345: WHERE
346: SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date
347: and papf.business_group_id = P_BUSINESS_GROUP_ID