[Home] [Help]
View: PAYLV_PAYROLL_H_V
View Text
SELECT PPF.PAYROLL_ID
, PPF.EFFECTIVE_START_DATE
, PPF.EFFECTIVE_END_DATE
, PPF.BUSINESS_GROUP_ID
, PPF.PAYROLL_NAME
, CASE WHEN PPF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPF.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, PPF. PAYROLL_NAME ORDER_BY
FROM PAY_PAYROLLS_F PPF UNION ALL SELECT -1
, HR_GENERAL.START_OF_TIME
, HR_GENERAL.END_OF_TIME
, -1
, NULL
, 'Y'
, ' ' ORDER_BY
FROM DUAL
Columns
Name |
PAYROLL_ID |
START_DATE |
END_DATE |
BUSINESS_GROUP_ID |
PAYROLL_NAME |
BG_SECURITY_FLAG_CODE |
ORDER_BY |