DBA Data[Home] [Help]

APPS.OKL_FUNDING_PVT dependencies on OKC_STATUSES_B

Line 1783: from okc_statuses_b ste,

1779:
1780: CURSOR c (p_contract_id NUMBER)
1781: IS
1782: select 1
1783: from okc_statuses_b ste,
1784: okc_k_headers_b chr
1785: where ste.code = chr.sts_code
1786: and ste.ste_code in ('ENTERED', 'ACTIVE','SIGNED')
1787: and chr.id = p_contract_id

Line 2373: okc_statuses_b sts,

2369: FROM okc_k_lines_b cleb_cov_asset,
2370: okl_k_lines_full_v kle_cov_asset,
2371: okc_k_items cim_cov_asset,
2372: okc_k_lines_b cleb_fin,
2373: okc_statuses_b sts,
2374: okl_k_lines kle
2375: WHERE kle_cov_asset.id = cleb_cov_asset.id
2376: AND cim_cov_asset.cle_id = cleb_cov_asset.id
2377: AND cim_cov_asset.dnz_chr_id = cleb_cov_asset.dnz_chr_id

Line 2653: okc_statuses_b sts,

2649: FROM okc_k_lines_b cleb_cov_asset,
2650: okl_k_lines_full_v kle_cov_asset,
2651: okc_k_items cim_cov_asset,
2652: okc_k_lines_b cleb_fin,
2653: okc_statuses_b sts,
2654: okl_k_lines kle
2655: WHERE kle_cov_asset.id = cleb_cov_asset.id
2656: AND cim_cov_asset.cle_id = cleb_cov_asset.id
2657: AND cim_cov_asset.dnz_chr_id = cleb_cov_asset.dnz_chr_id