VIEW: APPS.PAY_PAYROLLS_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )