DBA Data[Home] [Help]

APPS.OKS_CHANGE_STATUS_PVT dependencies on FND_LOOKUPS

Line 1873: ,fnd_lookups ST

1869: S.CODE STATUS_CODE
1870: ,S.STE_CODE STE_CODE
1871: from
1872: okc_statuses_v S
1873: ,fnd_lookups ST
1874: where
1875: S.STE_CODE in
1876: (
1877: NVL(l_old_ste_code,'ENTERED')

Line 1904: ,FND_LOOKUPS ST

1900: UNION ALL
1901: SELECT S.CODE STATUS_CODE
1902: ,S.STE_CODE STE_CODE1
1903: FROM OKC_STATUSES_V S
1904: ,FND_LOOKUPS ST
1905: WHERE S.STE_CODE in ('ENTERED', 'CANCELLED')
1906: AND SYSDATE BETWEEN S.START_DATE AND NVL(S.END_DATE, SYSDATE)
1907: AND ST.LOOKUP_TYPE = 'OKC_STATUS_TYPE'
1908: AND ST.LOOKUP_CODE=S.STE_CODE