VIEW: APPS.PAYLV_ELEMENT_CLASSIFICATION_V

Source

View Text - Preformatted

SELECT PEC.CLASSIFICATION_NAME ,PEC.CLASSIFICATION_ID ,CASE WHEN ((PEC.BUSINESS_GROUP_ID IS NULL AND PEC.LEGISLATION_CODE IS NULL) OR (PEC.BUSINESS_GROUP_ID IS NULL AND PEC.LEGISLATION_CODE = NVL(hr_bis.get_legislation_code,PEC.LEGISLATION_CODE)) OR (PEC.BUSINESS_GROUP_ID= NVL(hr_bis.get_sec_profile_bg_id, PEC.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE ,PEC.CLASSIFICATION_NAME ORDER_BY FROM PAY_ELEMENT_CLASSIFICATIONS_VL PEC UNION ALL SELECT null ,-1 ,'Y' ,' ' order_by FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT PEC.CLASSIFICATION_NAME
, PEC.CLASSIFICATION_ID
, CASE WHEN ((PEC.BUSINESS_GROUP_ID IS NULL
AND PEC.LEGISLATION_CODE IS NULL) OR (PEC.BUSINESS_GROUP_ID IS NULL
AND PEC.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PEC.LEGISLATION_CODE)) OR (PEC.BUSINESS_GROUP_ID= NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEC.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, PEC.CLASSIFICATION_NAME ORDER_BY
FROM PAY_ELEMENT_CLASSIFICATIONS_VL PEC UNION ALL SELECT NULL
, -1
, 'Y'
, ' ' ORDER_BY
FROM DUAL WITH READ ONLY