View: PA_PAY_COSTED_SET_LOV_V

Product:	PA - Projects
Description:	PA_PAY_COSTED_SET_LOV_V stores the payroll cost set list of values
Implementation/DBA Data:	APPS.PA_PAY_COSTED_SET_LOV_V

View Text

SELECT INTERFACE_RUN_ID
, PAYROLL_NAME || '-'|| TRUNC(AUD.PAY_PERIOD_START_DATE )|| ' TO ' || TRUNC(AUD.PAY_PERIOD_END_DATE ) ||'-' || AUD.RUN_SEQUENCE
, PAY.PAYROLL_NAME
, AUD.PAY_PERIOD_START_DATE
, AUD.PAY_PERIOD_END_DATE
, AUD.RUN_SEQUENCE
FROM PA_PAY_AUDIT AUD
, PAY_PAYROLLS_F PAY
WHERE AUD.PAYROLL_ID = PAY.PAYROLL_ID UNION SELECT INTERFACE_RUN_ID
, PAYROLL_NAME || '-'|| TRUNC(AUD.PAY_PERIOD_START_DATE )|| ' TO ' || TRUNC(AUD.PAY_PERIOD_END_DATE ) ||'-' || AUD.RUN_SEQUENCE
, PAY.PAYROLL_NAME
, AUD.PAY_PERIOD_START_DATE
, AUD.PAY_PERIOD_END_DATE
, AUD.RUN_SEQUENCE
FROM PA_PAY_AUDIT AUD
, PA_PAY_EXTERNAL_PAYROLL PAY
WHERE AUD.PAYROLL_ID = PAY.PAYROLL_ID
AND AUD.INT_EXT_INDICATOR = 'EXT'

Columns