APPS.OKS_BILL_UTIL_PUB dependencies on OKS_K_LINES_B

Line 1239: FROM oks_k_lines_b

1235: And sequence_no = l_seq_no;
1236:
1237: CURSOR l_bill_type_csr(p_line_id NUMBER) IS
1238: SELECT nvl(billing_schedule_type,'T') billing_schedule_type
1239: FROM oks_k_lines_b
1240: WHERE cle_id = p_line_id;
1241:
1242: l_get_line_sll_rec l_get_line_sll_csr%ROWTYPE;
1243: l_get_cp_rec l_get_cp_csr%ROWTYPE;

Line 1478: UPDATE oks_k_lines_b SET billing_schedule_type = NULL

1474: BEGIN
1475:
1476: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1477:
1478: UPDATE oks_k_lines_b SET billing_schedule_type = NULL
1479: WHERE cle_id =p_cle_id;
1480:
1481: DELETE FROM oks_stream_levels_b where cle_id = P_CLE_ID;
1482:

Line 1709: FROM oks_k_lines_b

1705: WHERE cle_id = p_cle_id;
1706:
1707: CURSOR l_bill_type_csr IS
1708: SELECT nvl(billing_schedule_type,'T') billing_schedule_type
1709: FROM oks_k_lines_b
1710: WHERE cle_id = p_cle_id;
1711:
1712:
1713: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;