VIEW: APPS.PAYLV_RUN_TYPES_V

Source

View Text - Preformatted

SELECT T.RUN_TYPE_NAME , B.RUN_TYPE_ID , CASE WHEN ((B.BUSINESS_GROUP_ID IS NULL AND B.LEGISLATION_CODE IS NULL) OR (B.BUSINESS_GROUP_ID IS NULL AND B.LEGISLATION_CODE = NVL(hr_bis.get_legislation_code,B.LEGISLATION_CODE)) OR (B.BUSINESS_GROUP_ID= NVL(hr_bis.get_sec_profile_bg_id, B.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE , T.RUN_TYPE_NAME ORDER_BY FROM PAY_RUN_TYPES_F_TL T , PAY_RUN_TYPES_F B WHERE B.RUN_TYPE_ID = T.RUN_TYPE_ID AND T.LANGUAGE = USERENV('LANG') UNION ALL SELECT null ,-1 ,'Y' ,' ' order_by FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT T.RUN_TYPE_NAME
, B.RUN_TYPE_ID
, CASE WHEN ((B.BUSINESS_GROUP_ID IS NULL
AND B.LEGISLATION_CODE IS NULL) OR (B.BUSINESS_GROUP_ID IS NULL
AND B.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, B.LEGISLATION_CODE)) OR (B.BUSINESS_GROUP_ID= NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, B.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, T.RUN_TYPE_NAME ORDER_BY
FROM PAY_RUN_TYPES_F_TL T
, PAY_RUN_TYPES_F B
WHERE B.RUN_TYPE_ID = T.RUN_TYPE_ID
AND T.LANGUAGE = USERENV('LANG') UNION ALL SELECT NULL
, -1
, 'Y'
, ' ' ORDER_BY
FROM DUAL WITH READ ONLY