DBA Data[Home] [Help]

APPS.OKL_POOLCONC_PVT dependencies on OKC_STATUSES_TL

Line 115: ,okc_statuses_tl psts

111: CURSOR l_okl_pol_csr IS
112: SELECT polv.pool_number pool_number
113: ,psts.meaning pool_status
114: FROM OKL_POOLS polv -- to take care of org_id
115: ,okc_statuses_tl psts
116: WHERE polv.id = p_pol_id
117: AND polv.status_code = psts.code
118: AND psts.LANGUAGE = USERENV('LANG');
119:

Line 1651: ,okc_statuses_tl psts

1647: ,polv.date_last_reconciled date_last_reconciled
1648: ,polv.total_principal_amount total_net_asset_net_investment
1649: ,polv.date_total_principal_calc date_last_calculated
1650: FROM OKL_POOLS polv -- to take care of org_id
1651: ,okc_statuses_tl psts
1652: WHERE polv.id = p_pol_id
1653: AND polv.status_code = psts.code
1654: AND psts.LANGUAGE = USERENV('LANG');
1655: