VIEW: APPS.PAYLV_INPUT_VALUE_V

Source

View Text - Preformatted

SELECT pivT.NAME ,piv.INPUT_VALUE_ID ,piv.EFFECTIVE_START_DATE ,piv.EFFECTIVE_END_DATE ,CASE WHEN ((piv.business_group_id IS NULL AND piv.legislation_code IS NULL) OR (piv.business_group_id IS NULL AND piv.legislation_code = NVL(hr_bis.get_legislation_code,piv.legislation_code)) OR (piv.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, piv.business_group_id))) THEN 'Y' ELSE 'N' END bg_security_flag_code, pivT.NAME order_by FROM pay_input_values_f piv ,pay_input_values_f_tl pivT WHERE piv.input_value_id = pivT.input_value_id and pivT.language = userenv('LANG') UNION ALL SELECT null ,-1 ,hr_general.start_of_time, hr_general.end_of_time,'Y' ,' ' order_by FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT PIVT.NAME
, PIV.INPUT_VALUE_ID
, PIV.EFFECTIVE_START_DATE
, PIV.EFFECTIVE_END_DATE
, CASE WHEN ((PIV.BUSINESS_GROUP_ID IS NULL
AND PIV.LEGISLATION_CODE IS NULL) OR (PIV.BUSINESS_GROUP_ID IS NULL
AND PIV.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PIV.LEGISLATION_CODE)) OR (PIV.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PIV.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, PIVT.NAME ORDER_BY
FROM PAY_INPUT_VALUES_F PIV
, PAY_INPUT_VALUES_F_TL PIVT
WHERE PIV.INPUT_VALUE_ID = PIVT.INPUT_VALUE_ID
AND PIVT.LANGUAGE = USERENV('LANG') UNION ALL SELECT NULL
, -1
, HR_GENERAL.START_OF_TIME
, HR_GENERAL.END_OF_TIME
, 'Y'
, ' ' ORDER_BY
FROM DUAL WITH READ ONLY