1813: S.CODE STATUS_CODE
1814: ,S.STE_CODE STE_CODE
1815: from
1816: okc_statuses_v S
1817: ,fnd_lookups ST
1818: where
1819: S.STE_CODE in
1820: (
1821: NVL(l_old_ste_code,'ENTERED')
1844: UNION ALL
1845: SELECT S.CODE STATUS_CODE
1846: ,S.STE_CODE STE_CODE1
1847: FROM OKC_STATUSES_V S
1848: ,FND_LOOKUPS ST
1849: WHERE S.STE_CODE in ('ENTERED', 'CANCELLED')
1850: AND SYSDATE BETWEEN S.START_DATE AND NVL(S.END_DATE, SYSDATE)
1851: AND ST.LOOKUP_TYPE = 'OKC_STATUS_TYPE'
1852: AND ST.LOOKUP_CODE=S.STE_CODE