DBA Data[Home] [Help]

APPS.HR_360_MESSAGE dependencies on HR_GENERAL

Line 187: HR_GENERAL.DECODE_POSITION_LATEST_NAME(PA.POSITION_ID) POSITION_NAME,

183: PCR.FULL_NAME CONTACT_NAME,
184: PCR.MEANING RELATIONSHIP,
185: JBT.NAME EMP_JOB_NAME,
186: GDT.NAME EMP_GRADE_NAME,
187: HR_GENERAL.DECODE_POSITION_LATEST_NAME(PA.POSITION_ID) POSITION_NAME,
188: HR_GENERAL.DECODE_LOOKUP('EMP_CAT', PA.EMPLOYMENT_CATEGORY) EMPLOYMENT_CATEGORY,
189: PA.NORMAL_HOURS,
190: LOCTL.LOCATION_CODE ASG_LOCATION ,
191: NVL(AMDTL.USER_STATUS , STTL.USER_STATUS) ASSIGNMENT_STATUS ,

Line 188: HR_GENERAL.DECODE_LOOKUP('EMP_CAT', PA.EMPLOYMENT_CATEGORY) EMPLOYMENT_CATEGORY,

184: PCR.MEANING RELATIONSHIP,
185: JBT.NAME EMP_JOB_NAME,
186: GDT.NAME EMP_GRADE_NAME,
187: HR_GENERAL.DECODE_POSITION_LATEST_NAME(PA.POSITION_ID) POSITION_NAME,
188: HR_GENERAL.DECODE_LOOKUP('EMP_CAT', PA.EMPLOYMENT_CATEGORY) EMPLOYMENT_CATEGORY,
189: PA.NORMAL_HOURS,
190: LOCTL.LOCATION_CODE ASG_LOCATION ,
191: NVL(AMDTL.USER_STATUS , STTL.USER_STATUS) ASSIGNMENT_STATUS ,
192: OTL.NAME DEPARTMENT_NAME ,