1606:
1607: --cursor to get asset number for error message
1608: cursor l_astnum_csr (p_cle_id in number) is
1609: select clet.name
1610: from okc_k_lines_tl clet
1611: where id = p_cle_id
1612: and language = userenv('LANG');
1613:
1614: l_asset_number okc_k_lines_tl.name%TYPE;
1610: from okc_k_lines_tl clet
1611: where id = p_cle_id
1612: and language = userenv('LANG');
1613:
1614: l_asset_number okc_k_lines_tl.name%TYPE;
1615:
1616: begin
1617: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1618: -- Call start_activity to create savepoint, check compatibility
2865: ,subb.receipt_method_code receipt_method_code
2866: ,subb.customer_visible_yn customer_visible_yn
2867: from okl_subsidies_b subb,
2868: okc_k_lines_b sub_cleb,
2869: okc_k_lines_tl sub_clet,
2870: okl_k_lines sub_kle,
2871: okc_k_party_roles_b cplb,
2872: po_vendors pov,
2873: okl_party_payment_dtls ppyd
5292: ,cplb.object1_id1 vendor_id
5293: ,cplb.id cpl_id
5294: ,kle.sty_id sty_id
5295: from okl_k_lines kle,
5296: okc_k_lines_tl clet,
5297: okc_k_lines_b cleb,
5298: okc_statuses_b stsb,
5299: okc_line_styles_b lseb,
5300: okc_k_party_roles_b cplb
5326: ,cplb.object1_id1 vendor_id
5327: ,cplb.id cpl_id
5328: ,kle.sty_id sty_id
5329: from okl_k_lines kle,
5330: okc_k_lines_tl clet,
5331: okc_k_lines_b cleb,
5332: okc_statuses_b stsb,
5333: okc_line_styles_b lseb,
5334: okc_k_party_roles_b cplb
5437: from
5438: okc_k_lines_b asst_cleb,
5439: okc_statuses_b asst_sts,
5440: okc_k_party_roles_b cplb,
5441: okc_k_lines_tl clet,
5442: okl_k_lines kle,
5443: okc_line_styles_b lseb,
5444: okc_k_lines_b cleb
5445: