APPS.OKL_POOLCONC_PVT dependencies on FND_LOOKUPS

Line 155: FROM FND_LOOKUPS

151:
152: CURSOR l_okl_book_class_csr
153: IS
154: SELECT meaning
155: FROM FND_LOOKUPS
156: WHERE lookup_type='OKL_BOOK_CLASS'
157: AND NVL(start_date_active,SYSDATE) <=SYSDATE
158: AND NVL(end_date_active,SYSDATE+1) > SYSDATE
159: AND enabled_flag = 'Y'

Line 165: FROM FND_LOOKUPS

161:
162: CURSOR l_okl_tax_owner_csr
163: IS
164: SELECT meaning
165: FROM FND_LOOKUPS
166: WHERE lookup_type='OKL_TAX_OWNER'
167: AND NVL(start_date_active,SYSDATE) <=SYSDATE
168: AND NVL(end_date_active,SYSDATE+1) > SYSDATE
169: AND enabled_flag = 'Y'

Line 181: FROM fnd_lookups

177:
178: CURSOR l_okl_sty_subclass_csr
179: IS
180: SELECT meaning
181: FROM fnd_lookups
182: WHERE lookup_type = 'OKL_STREAM_TYPE_SUBCLASS'
183: AND lookup_code = p_stream_type_subclass;
184:
185: --Added ssdeshpa

Line 203: FROM fnd_lookups

199: CURSOR l_okl_reject_codes_csr
200: IS
201: SELECT lookup_code,
202: meaning
203: FROM fnd_lookups
204: WHERE LOOKUP_TYPE LIKE 'OKL_POOL_REJECT_REASON'
205: ORDER BY LOOKUP_CODE;
206: */
207:

Line 1691: FROM FND_LOOKUPS

1687:
1688: CURSOR l_okl_book_class_csr
1689: IS
1690: SELECT meaning
1691: FROM FND_LOOKUPS
1692: WHERE lookup_type='OKL_BOOK_CLASS'
1693: AND NVL(start_date_active,SYSDATE) <=SYSDATE
1694: AND NVL(end_date_active,SYSDATE+1) > SYSDATE
1695: AND enabled_flag = 'Y'

Line 1701: FROM FND_LOOKUPS

1697:
1698: CURSOR l_okl_tax_owner_csr
1699: IS
1700: SELECT meaning
1701: FROM FND_LOOKUPS
1702: WHERE lookup_type='OKL_TAX_OWNER'
1703: AND NVL(start_date_active,SYSDATE) <=SYSDATE
1704: AND NVL(end_date_active,SYSDATE+1) > SYSDATE
1705: AND enabled_flag = 'Y'

Line 1744: FROM fnd_lookups

1740:
1741: CURSOR l_okl_sty_subclass_csr
1742: IS
1743: SELECT meaning
1744: FROM fnd_lookups
1745: WHERE lookup_type = 'OKL_STREAM_TYPE_SUBCLASS'
1746: AND lookup_code = p_stream_type_subclass;
1747:
1748: --Added ssdeshpa