View: PA_REVENUE_SCHEDULES_LOV_V

Product:	PA - Projects
Description:	This view displays all the defined valid revenue schedules.
Implementation/DBA Data:	APPS.PA_REVENUE_SCHEDULES_LOV_V

View Text

SELECT IRS.IND_RATE_SCH_ID
, IRS.IND_RATE_SCH_NAME
FROM PA_IND_RATE_SCHEDULES IRS
WHERE IRS.PROJECT_ID IS NULL
AND TRUNC(SYSDATE) BETWEEN TRUNC(IRS.START_DATE_ACTIVE )
AND NVL (IRS.END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns