View: PAY_PAYROLLS_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_PAYROLLS_V

View Text

SELECT PR.ROWID ROW_ID
, PR.PAYROLL_ID
, PR.PAYROLL_NAME
, PR.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PR.CONSOLIDATION_SET_ID
, CS.CONSOLIDATION_SET_NAME CSNAME
, PR.PERIOD_TYPE
, PTP.PAY_ADVICE_DATE
, PTP.REGULAR_PAYMENT_DATE
, PTP.PERIOD_NAME
, PTP.START_DATE PERIOD_START_DATE
, PTP.END_DATE PERIOD_END_DATE
FROM PAY_PAYROLLS_F PR
, PER_TIME_PERIODS PTP
, PAY_CONSOLIDATION_SETS CS
, FND_SESSIONS FND
WHERE PR.PAYROLL_ID = PTP.PAYROLL_ID
AND PR.CONSOLIDATION_SET_ID = CS.CONSOLIDATION_SET_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN PR.EFFECTIVE_START_DATE
AND PR.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN PTP.START_DATE
AND PTP.END_DATE UNION ALL SELECT PR.ROWID ROW_ID
, PR.PAYROLL_ID
, PR.PAYROLL_NAME
, PR.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, FND_NUMBER.CANONICAL_TO_NUMBER (NULL)
, NULL
, PR.PERIOD_TYPE
, TO_DATE (NULL
, 'YYYY/MM/DD')
, TO_DATE (NULL
, 'YYYY/MM/DD')
, NULL
, TO_DATE (NULL
, 'YYYY/MM/DD')
, TO_DATE (NULL
, 'YYYY/MM/DD')
FROM PAY_PAYROLLS_F PR
, FND_SESSIONS FND
WHERE FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN PR.EFFECTIVE_START_DATE
AND PR.EFFECTIVE_END_DATE
AND NOT EXISTS ( SELECT 1
FROM PER_TIME_PERIODS PTP
WHERE PR.PAYROLL_ID = PTP.PAYROLL_ID
AND FND.EFFECTIVE_DATE BETWEEN PTP.START_DATE
AND PTP.END_DATE )

Columns