DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on OKC_LINE_STYLES_V

Line 2347: okc_line_styles_v b

2343:
2344: CURSOR sold_service_fee_csr ( p_cle_id NUMBER ) IS
2345: SELECT '1'
2346: FROM okc_k_lines_v a,
2347: okc_line_styles_v b
2348: WHERE a.lse_id = b.id
2349: AND b.lty_code = 'SOLD_SERVICE'
2350: AND a.id = p_cle_id;
2351:

Line 2355: okc_line_styles_v b,

2351:
2352: CURSOR get_service_inv_csr ( p_cle_id NUMBER ) IS
2353: SELECT c.object1_id1
2354: FROM okc_k_lines_v a,
2355: okc_line_styles_v b,
2356: okc_k_items c
2357: WHERE a.lse_id = b.id
2358: AND b.lty_code = 'SOLD_SERVICE'
2359: AND a.id = p_cle_id