APPS.OKL_VP_STS_PVT dependencies on FND_LOOKUPS

Line 26: okc_statuses_v S, fnd_lookups ST

22: decode(S.DEFAULT_YN,'Y','*',' ') DEF,
23: ST.meaning STATUS_TYPE,
24: S.ste_code STE_CODE1
25: FROM
26: okc_statuses_v S, fnd_lookups ST
27: WHERE
28: S.ste_code IN (NVL(p_ste_code,'ENTERED'),decode(p_ste_code,NULL, 'CANCELLED','ENTERED','CANCELLED',
29: 'ACTIVE','HOLD', 'SIGNED','HOLD', 'HOLD',DECODE(NVL(sign(months_between
30: (p_start_date,SYSDATE+1)),1), -1,

Line 50: ,fnd_lookups ST

46: ,DECODE(S.DEFAULT_YN, 'Y', '*', '') DEF
47: ,ST.meaning STATUS_TYPE
48: ,S.ste_code STE_CODE1
49: FROM okc_statuses_v S
50: ,fnd_lookups ST
51: WHERE S.ste_code IN ('ENTERED', 'CANCELLED')
52: AND SYSDATE BETWEEN S.start_date AND NVL(S.end_date, SYSDATE)
53: AND ST.lookup_type = 'OKC_STATUS_TYPE'
54: AND ST.lookup_code=S.ste_code