FA Prorate Convention Listing - draft

SELECT
        CT.PRORATE_CONVENTION_CODE                              PR_CODE,
        CT.DESCRIPTION                                          DESCR,
        LU.MEANING                              DEPR_FLAG,
        CO.START_DATE                  CONV_START,
        CO.END_DATE                      CONV_END,
        CO.PRORATE_DATE                  PRO_DATE
FROM
        FA_CONVENTIONS          CO,
        FA_CONVENTION_TYPES     CT,
        FA_FISCAL_YEAR          FY,
        FA_LOOKUPS	        	LU
WHERE
        FY.FISCAL_YEAR                  = :P_FY_YEAR
AND     FY.FISCAL_YEAR_NAME             = :P_FY_YEAR_NAME
AND
        CO.START_DATE           BETWEEN FY.START_DATE AND FY.END_DATE   AND
        CO.PRORATE_CONVENTION_CODE      = CT.PRORATE_CONVENTION_CODE
AND
        LU.LOOKUP_TYPE = 'YESNO'	AND
        LU.LOOKUP_CODE = CT.DEPR_WHEN_ACQUIRED_FLAG
ORDER BY
        CT.PRORATE_CONVENTION_CODE,
        CO.START_DATE