DBA Data[Home] [Help]

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 580: oks_bill_sub_line_dtls bsd

576: rline.dnz_chr_id
577: FROM
578: oks_k_lines_b rline,
579: oks_bill_sub_lines bsl,
580: oks_bill_sub_line_dtls bsd
581: WHERE bsl.bcl_id = p_bcl_id
582: AND bsl.id = bsd.bsl_id
583: AND rline.cle_id = bsl.cle_id
584: AND p_prv = 1