VIEW: APPS.HRI_CL_RQNVAC_REQSTN_BX_V

Source

View Text - Preformatted

SELECT req.requisition_id ID ,req.name VALUE ,req.date_from START_DATE ,req.date_to DATE_TO ,req.business_group_id BUSINESS_GROUP_ID FROM per_requisitions req WHERE TRUNC(SYSDATE) BETWEEN req.date_from AND nvl(req.date_to, hr_general.end_of_time) AND req.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,req.business_group_id) UNION ALL SELECT -1 ID , '' VALUE , hr_general.start_of_time START_DATE , hr_general.end_of_time END_DATE , -1 BUSINESS_GROUP_ID FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT REQ.REQUISITION_ID ID
, REQ.NAME VALUE
, REQ.DATE_FROM START_DATE
, REQ.DATE_TO DATE_TO
, REQ.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_REQUISITIONS REQ
WHERE TRUNC(SYSDATE) BETWEEN REQ.DATE_FROM
AND NVL(REQ.DATE_TO
, HR_GENERAL.END_OF_TIME)
AND REQ.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, REQ.BUSINESS_GROUP_ID) UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, -1 BUSINESS_GROUP_ID
FROM DUAL WITH READ ONLY