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

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