HRA_PF_DEFNS_VL

Details

• Schema: FUSION

• Object owner: HRA

• Object type: VIEW

Columns

Name

PROCESS_FLOW_ID BUSINESS_GROUP_ID DATE_FROM DATE_TO NAME DESCRIPTION STATUS_CODE WKR_PERF_DOC_FLAG MGR_PERF_DOC_FLAG CONFIRM_CRITERIA_FLAG PRELIMINARY_RATINGS_FLAG ASSIGN_PARTICIPANTS_FLAG MGR_SELECT_PCPNS_FLAG WRK_SELECT_PCPNS_FLAG MGR_TRACK_PCPNS_FLAG WRK_TRACK_PCPNS_FLAG WRK_VIEW_SUB_FDBCK_FLAG WRK_REQUEST_PCPNS_FLAG MGR_ADD_QUESTION_FLAG WRK_ADD_QUESTION_FLAG PARTICIPANT_EVAL_FLAG WKR_SELF_EVAL_FLAG MGR_EVAL_OF_WRKR_FLAG EVAL_TASKS_CONCURRENT_FLAG DISABLE_RESUBMIT_MGR_EVAL FIRST_APPROVAL_FLAG SECOND_APPROVAL_FLAG AUTO_SUBMIT_APPROVAL_FLAG SHARE_PERFORMANCE_DOC_FLAG CONDUCT_MEETINGS_FLAG FINAL_FEEDBACK_FLAG NEXT_PERIOD_GOALS_FLAG ALLOCATE_REWARDS_FLAG MANAGE_PROMOTIONS_FLAG MGR_SET_EVAL_CRTRIA_FLAG WKR_SET_EVAL_CRTRIA_FLAG MGR_CMPLT_EVAL_CRTRIA_FLAG WKR_CMPLT_EVAL_CRTRIA_FLAG MGR_ASSGN_PRTCPNT_FLAG WKR_ASSGN_PRTCPNT_FLAG MGR_CMPLT_ASSGNMNT_FLAG WKR_CMPLT_ASSGNMNT_FLAG FIRST_APPROVAL_ID SECOND_APPROVAL_ID WKR_ACK_DOC_FLAG WKR_ACK_REVIEW_MTG_FLAG WKR_FINAL_FEEDBCK_FLAG MGR_FINAL_FEEDBACK_FLAG ALLOW_SHARE_LOCK_FOR_CALIB MGR_REOPEN_PCPN_FDBCK_FLAG WRK_REOPEN_PCPN_FDBCK_FLAG PCPN_REOPEN_FDBCK_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN MODULE_ID

Query

SQL_Statement

SELECT PFDB.PROCESS_FLOW_ID, PFDB.BUSINESS_GROUP_ID, PFDB.DATE_FROM, PFDB.DATE_TO, PFDL.NAME, PFDL.DESCRIPTION, PFDB.STATUS_CODE, PFDB.WKR_PERF_DOC_FLAG, PFDB.MGR_PERF_DOC_FLAG, PFDB.CONFIRM_CRITERIA_FLAG, PFDB.PRELIMINARY_RATINGS_FLAG, PFDB.ASSIGN_PARTICIPANTS_FLAG, PFDB.MGR_SELECT_PCPNS_FLAG, PFDB.WRK_SELECT_PCPNS_FLAG, PFDB.MGR_TRACK_PCPNS_FLAG, PFDB.WRK_TRACK_PCPNS_FLAG, PFDB.WRK_VIEW_SUB_FDBCK_FLAG, PFDB.WRK_REQUEST_PCPNS_FLAG, PFDB.MGR_ADD_QUESTION_FLAG, PFDB.WRK_ADD_QUESTION_FLAG, PFDB.PARTICIPANT_EVAL_FLAG, PFDB.WKR_SELF_EVAL_FLAG, PFDB.MGR_EVAL_OF_WRKR_FLAG, PFDB.EVAL_TASKS_CONCURRENT_FLAG, PFDB.DISABLE_RESUBMIT_MGR_EVAL, PFDB.FIRST_APPROVAL_FLAG, PFDB.SECOND_APPROVAL_FLAG, PFDB.AUTO_SUBMIT_APPROVAL_FLAG, PFDB.SHARE_PERFORMANCE_DOC_FLAG, PFDB.CONDUCT_MEETINGS_FLAG, PFDB.FINAL_FEEDBACK_FLAG, PFDB.NEXT_PERIOD_GOALS_FLAG, PFDB.ALLOCATE_REWARDS_FLAG, PFDB.MANAGE_PROMOTIONS_FLAG, PFDB.MGR_SET_EVAL_CRTRIA_FLAG, PFDB.WKR_SET_EVAL_CRTRIA_FLAG, PFDB.MGR_CMPLT_EVAL_CRTRIA_FLAG, PFDB.WKR_CMPLT_EVAL_CRTRIA_FLAG, PFDB.MGR_ASSGN_PRTCPNT_FLAG, PFDB.WKR_ASSGN_PRTCPNT_FLAG, PFDB.MGR_CMPLT_ASSGNMNT_FLAG, PFDB.WKR_CMPLT_ASSGNMNT_FLAG, PFDB.FIRST_APPROVAL_ID, PFDB.SECOND_APPROVAL_ID, PFDB.WKR_ACK_DOC_FLAG, PFDB.WKR_ACK_REVIEW_MTG_FLAG, PFDB.WKR_FINAL_FEEDBCK_FLAG, PFDB.MGR_FINAL_FEEDBACK_FLAG, PFDB.ALLOW_SHARE_LOCK_FOR_CALIB, PFDB.MGR_REOPEN_PCPN_FDBCK_FLAG, PFDB.WRK_REOPEN_PCPN_FDBCK_FLAG, PFDB.PCPN_REOPEN_FDBCK_FLAG, PFDB.OBJECT_VERSION_NUMBER, PFDB.CREATED_BY, PFDB.CREATION_DATE, PFDB.LAST_UPDATED_BY, PFDB.LAST_UPDATE_DATE, PFDB.LAST_UPDATE_LOGIN, PFDB.MODULE_ID FROM HRA_PF_DEFNS_B PFDB, HRA_PF_DEFNS_TL PFDL WHERE PFDB.PROCESS_FLOW_ID = PFDL.PROCESS_FLOW_ID AND PFDB.BUSINESS_GROUP_ID = PFDL.BUSINESS_GROUP_ID AND PFDL.LANGUAGE = USERENV('LANG')