APPS.OKS_BILLING_PUB dependencies on OKS_BCL_PR

Line 1509: Delete from OKS_BCL_PR

1505: Delete from OKS_BSL_PR
1506: where id in
1507: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1508:
1509: Delete from OKS_BCL_PR
1510: where id in
1511: (select usg_bcl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1512:
1513: end if;