VIEW: APPS.PA_PAY_COSTED_SET_LOV_V

Source

View Text - Preformatted

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 , Nvl(aud.source_start_date,aud.pay_period_start_date) source_start_date, Nvl(aud.source_end_date,aud.pay_period_end_date ) source_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 , Nvl(aud.source_start_date,aud.pay_period_start_date) source_start_date, Nvl(aud.source_end_date,aud.pay_period_end_date ) source_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'

View Text - HTML Formatted

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
, NVL(AUD.SOURCE_START_DATE
, AUD.PAY_PERIOD_START_DATE) SOURCE_START_DATE
, NVL(AUD.SOURCE_END_DATE
, AUD.PAY_PERIOD_END_DATE ) SOURCE_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
, NVL(AUD.SOURCE_START_DATE
, AUD.PAY_PERIOD_START_DATE) SOURCE_START_DATE
, NVL(AUD.SOURCE_END_DATE
, AUD.PAY_PERIOD_END_DATE ) SOURCE_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'