DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKC_LINE_STYLES_V

Line 1218: okc_line_styles_v b

1214: l_temp_sold_fee VARCHAR2(1);
1215: CURSOR sold_service_fee_csr ( p_cle_id NUMBER ) IS
1216: SELECT '1'
1217: FROM okc_k_lines_v a,
1218: okc_line_styles_v b
1219: WHERE a.lse_id = b.id
1220: AND b.lty_code = 'SOLD_SERVICE'
1221: AND a.id = p_cle_id;
1222:

Line 1226: okc_line_styles_v b,

1222:
1223: CURSOR get_service_inv_csr ( p_cle_id NUMBER ) IS
1224: SELECT c.object1_id1
1225: FROM okc_k_lines_v a,
1226: okc_line_styles_v b,
1227: okc_k_items c
1228: WHERE a.lse_id = b.id
1229: AND b.lty_code = 'SOLD_SERVICE'
1230: AND a.id = p_cle_id