DBA Data[Home] [Help]

APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on OKL_LA_LINK_SERVICE_UV9

Line 429: FROM okl_la_link_service_uv9

425: SELECT contract_number,
426: currency_code,
427: customer_id,
428: bill_to_id
429: FROM okl_la_link_service_uv9
430: WHERE chr_id = p_chr_id;
431:
432: CURSOR okl_curr_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
433: SELECT contract_number,

Line 3575: FROM okl_la_link_service_uv9

3571: WHERE chr_id = p_oks_chr_id;
3572:
3573: CURSOR oks_serv_csr9 (p_oks_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3574: SELECT DISTINCT cle_id
3575: FROM okl_la_link_service_uv9
3576: WHERE chr_id = p_oks_chr_id;
3577:
3578: CURSOR oks_cov_csr(p_oks_serv_id OKC_K_LINES_V.ID%TYPE) IS
3579: SELECT line.id,