APPS.OKS_BILLING_PUB dependencies on OKS_BILL_SUB_LINE_DTLS

Line 266: oks_bill_sub_line_dtls bsd

262: Cursor l_tot_csr Is
263: SELECT NVL(Sum(NVL(bsd.Result,0)),0)
264: FROM oks_bill_cont_lines bcl,
265: oks_bill_sub_lines bsl,
266: oks_bill_sub_line_dtls bsd
267: WHERE bsl.cle_id = p_cle_id
268: AND bsl.bcl_id = bcl.id
269: AND bcl.bill_action <> 'AVG'
270: AND bsd.bsl_id = bsl.id;

Line 663: oks_bill_sub_line_dtls bsd

659: rline.dnz_chr_id
660: FROM
661: oks_k_lines_b rline,
662: oks_bill_sub_lines bsl,
663: oks_bill_sub_line_dtls bsd
664: WHERE bsl.bcl_id = p_bcl_id
665: AND bsl.id = bsd.bsl_id
666: AND rline.cle_id = bsl.cle_id
667: AND p_prv = 1

Line 1477: Delete from OKS_BILL_SUB_LINE_DTLS

1473: Begin
1474:
1475: If p_prv=1 Then
1476:
1477: Delete from OKS_BILL_SUB_LINE_DTLS
1478: where bsl_id in
1479: (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);
1480:
1481: Delete from OKS_BILL_SUB_LINES

Line 3684: oks_bill_sub_line_dtls bsd

3680: rline.dnz_chr_id
3681: FROM
3682: oks_k_lines_b rline,
3683: oks_bill_sub_lines bsl,
3684: oks_bill_sub_line_dtls bsd
3685: WHERE bsl.bcl_id = p_bcl_id
3686: AND bsl.id = bsd.bsl_id
3687: AND rline.cle_id = bsl.cle_id
3688: AND p_prv = 1