APPS.OKS_BILL_UTIL_PUB dependencies on OKS_K_LINES_B

Line 1205: FROM oks_k_lines_b

1201: And sequence_no = l_seq_no;
1202:
1203: CURSOR l_bill_type_csr(p_line_id NUMBER) IS
1204: SELECT nvl(billing_schedule_type,'T') billing_schedule_type
1205: FROM oks_k_lines_b
1206: WHERE cle_id = p_line_id;
1207:
1208: l_get_line_sll_rec l_get_line_sll_csr%ROWTYPE;
1209: l_get_cp_rec l_get_cp_csr%ROWTYPE;

Line 1444: UPDATE oks_k_lines_b SET billing_schedule_type = NULL

1440: BEGIN
1441:
1442: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1443:
1444: UPDATE oks_k_lines_b SET billing_schedule_type = NULL
1445: WHERE cle_id =p_cle_id;
1446:
1447: DELETE FROM oks_stream_levels_b where cle_id = P_CLE_ID;
1448:

Line 1675: FROM oks_k_lines_b

1671: WHERE cle_id = p_cle_id;
1672:
1673: CURSOR l_bill_type_csr IS
1674: SELECT nvl(billing_schedule_type,'T') billing_schedule_type
1675: FROM oks_k_lines_b
1676: WHERE cle_id = p_cle_id;
1677:
1678:
1679: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;