APPS.OKS_BILL_REC_PUB dependencies on OKS_BSL_PR

Line 6443: ,oks_bsl_pr line

6439:
6440: Cursor l_actual_counter_csr_prv (p_cle_id IN NUMBER , p_start_date IN DATE) IS
6441: SELECT nvl(end_reading,0) qty
6442: FROM Oks_bsd_pr ldtl
6443: ,oks_bsl_pr line
6444: WHERE line.cle_id = p_cle_id
6445: AND ldtl.bsl_id = line.id
6446: AND nvl(end_reading,0) > 0
6447: AND trunc(date_billed_from) < trunc(p_start_date)

Line 6464: ,oks_bsl_pr line

6460:
6461: Cursor l_actual_csr_prv(p_cle_id IN NUMBER) Is
6462: SELECT NVL(sign(ldtl.amount)*Result,0) + nvl(base_reading,0) qty
6463: FROM Oks_bsd_pr ldtl
6464: ,oks_bsl_pr line
6465: WHERE line.cle_id = p_cle_id
6466: AND ldtl.bsl_id = line.id
6467: ORDER BY date_billed_to desc;
6468:

Line 6485: ,oks_bsl_pr line

6481:
6482: Cursor l_ccr_id_csr_prv (p_cle_id IN NUMBER , p_start_date IN DATE) IS
6483: SELECT end_reading read,ccr_id,cgr_id
6484: FROM Oks_bsd_pr ldtl
6485: ,oks_bsl_pr line
6486: WHERE line.cle_id = p_cle_id
6487: AND ldtl.bsl_id = line.id
6488: AND trunc(line.date_billed_from) < trunc(p_start_date)
6489: -- Bug#4730007 nechatur 1-Dec-2005

Line 7032: UPDATE oks_bsl_pr

7028: SET amount = nvl(amount,0) + round_amount,
7029: currency_code = l_cur_holder
7030: WHERE id = p_bcl_id;
7031:
7032: UPDATE oks_bsl_pr
7033: SET amount = round_amount,
7034: average = 0
7035: WHERE id = p_bsl_id;
7036:

Line 7402: SUBTYPE l_bsl_pr_tbl_type is OKS_BSL_PRINT_PREVIEW_PVT.bsl_pr_tbl_type;

7398:
7399: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;
7400: l_bcl_pr_tbl_in l_bcl_pr_tbl_type;
7401: l_bcl_pr_tbl_out l_bcl_pr_tbl_type;
7402: SUBTYPE l_bsl_pr_tbl_type is OKS_BSL_PRINT_PREVIEW_PVT.bsl_pr_tbl_type;
7403: l_bsl_pr_tbl_in l_bsl_pr_tbl_type;
7404: l_bsl_pr_tbl_out l_bsl_pr_tbl_type;
7405: SUBTYPE l_bsd_pr_tbl_type is OKS_BSD_PRINT_PREVIEW_PVT.bsd_pr_tbl_type;
7406: l_bsd_pr_tbl_in l_bsd_pr_tbl_type;