DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_BILL_CONT_LINES

Line 6862: FROM oks_bill_cont_lines bcl

6858: SELECT NVL (SUM (amount), 0)
6859: FROM oks_bill_sub_lines bsl
6860: WHERE bsl.cle_id = p_cle_id
6861: AND EXISTS (SELECT 1
6862: FROM oks_bill_cont_lines bcl
6863: WHERE bcl.ID = bsl.bcl_id AND bill_action = 'TR');
6864:
6865: --bug start 3736860
6866: CURSOR get_oks_line_dtls (p_id NUMBER)

Line 7734: FROM oks_bill_cont_lines bcl

7730: SELECT NVL (SUM (amount), 0)
7731: FROM oks_bill_sub_lines bsl
7732: WHERE bsl.cle_id = p_cle_id
7733: AND EXISTS (SELECT 1
7734: FROM oks_bill_cont_lines bcl
7735: WHERE bcl.ID = bsl.bcl_id AND bill_action = 'TR');
7736:
7737: -- bug start 3736860
7738: CURSOR get_oks_line_dtls (p_id NUMBER)