DBA Data[Home] [Help]

APPS.OKS_CHANGE_STATUS_PVT dependencies on FND_LOOKUPS

Line 1817: ,fnd_lookups ST

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')

Line 1848: ,FND_LOOKUPS ST

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