APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on OKL_LA_LINK_SERVICE_UV

Line 421: FROM okl_la_link_service_uv

417: SELECT contract_number,
418: currency_code,
419: customer_id,
420: bill_to_id
421: FROM okl_la_link_service_uv
422: WHERE chr_id = p_chr_id;
423:
424: CURSOR oks_info_csr9 (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
425: SELECT contract_number,

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 467: l_oks_customer_id OKL_LA_LINK_SERVICE_UV.CUSTOMER_ID%TYPE;

463: l_okl_currency OKC_K_HEADERS_V.CURRENCY_CODE%TYPE;
464: l_oks_currency OKC_K_HEADERS_V.CURRENCY_CODE%TYPE;
465:
466: l_okl_customer_id OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE;
467: l_oks_customer_id OKL_LA_LINK_SERVICE_UV.CUSTOMER_ID%TYPE;
468:
469: l_okl_bill_to_id OKC_RULES_V.OBJECT1_ID1%TYPE;
470: l_oks_bill_to_id OKL_LA_LINK_SERVICE_UV.BILL_TO_ID%TYPE;
471:

Line 470: l_oks_bill_to_id OKL_LA_LINK_SERVICE_UV.BILL_TO_ID%TYPE;

466: l_okl_customer_id OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE;
467: l_oks_customer_id OKL_LA_LINK_SERVICE_UV.CUSTOMER_ID%TYPE;
468:
469: l_okl_bill_to_id OKC_RULES_V.OBJECT1_ID1%TYPE;
470: l_oks_bill_to_id OKL_LA_LINK_SERVICE_UV.BILL_TO_ID%TYPE;
471:
472: l_oks_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
473: l_okl_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
474:

Line 3570: FROM okl_la_link_service_uv

3566: l_oks_ver VARCHAR2(3);
3567:
3568: CURSOR oks_serv_csr (p_oks_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3569: SELECT DISTINCT cle_id
3570: FROM okl_la_link_service_uv
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

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,