VIEW: APPS.HRI_OBI_CL_GRD_GRADE_V

Source

View Text - Preformatted

SELECT grd.grade_id grd_grade_pk, grt.name grd_grade_name, grt.name || ' (' || to_char(grd.grade_id) || ')' grd_grade_name_unq, grd.date_from grd_valid_from, nvl(grd.date_to, hr_general.end_of_time) grd_valid_to, grt.name grd_order_by FROM per_grades grd, per_grades_tl grt WHERE grd.grade_id=grt.grade_id AND grt.LANGUAGE = userenv('LANG') UNION ALL SELECT id grd_grade_pk, hri_oltp_view_message.get_unassigned_msg grd_grade_name, hri_oltp_view_message.get_unassigned_msg || ' (' || to_char(id) || ')' grd_grade_name_unq, hr_general.start_of_time grd_valid_from, hr_general.end_of_time grd_valid_to, VALUE grd_order_by FROM hri_unassigned WITH READ ONLY

View Text - HTML Formatted

SELECT GRD.GRADE_ID GRD_GRADE_PK
, GRT.NAME GRD_GRADE_NAME
, GRT.NAME || ' (' || TO_CHAR(GRD.GRADE_ID) || ')' GRD_GRADE_NAME_UNQ
, GRD.DATE_FROM GRD_VALID_FROM
, NVL(GRD.DATE_TO
, HR_GENERAL.END_OF_TIME) GRD_VALID_TO
, GRT.NAME GRD_ORDER_BY
FROM PER_GRADES GRD
, PER_GRADES_TL GRT
WHERE GRD.GRADE_ID=GRT.GRADE_ID
AND GRT.LANGUAGE = USERENV('LANG') UNION ALL SELECT ID GRD_GRADE_PK
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG GRD_GRADE_NAME
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG || ' (' || TO_CHAR(ID) || ')' GRD_GRADE_NAME_UNQ
, HR_GENERAL.START_OF_TIME GRD_VALID_FROM
, HR_GENERAL.END_OF_TIME GRD_VALID_TO
, VALUE GRD_ORDER_BY
FROM HRI_UNASSIGNED WITH READ ONLY