DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_BILL_CONT_LINES

Line 6694: FROM oks_bill_cont_lines bcl

6690: SELECT NVL (SUM (amount), 0)
6691: FROM oks_bill_sub_lines bsl
6692: WHERE bsl.cle_id = p_cle_id
6693: AND EXISTS (SELECT 1
6694: FROM oks_bill_cont_lines bcl
6695: WHERE bcl.ID = bsl.bcl_id AND bill_action = 'TR');
6696:
6697: --bug start 3736860
6698: CURSOR get_oks_line_dtls (p_id NUMBER)

Line 7553: FROM oks_bill_cont_lines bcl

7549: SELECT NVL (SUM (amount), 0)
7550: FROM oks_bill_sub_lines bsl
7551: WHERE bsl.cle_id = p_cle_id
7552: AND EXISTS (SELECT 1
7553: FROM oks_bill_cont_lines bcl
7554: WHERE bcl.ID = bsl.bcl_id AND bill_action = 'TR');
7555:
7556: -- bug start 3736860
7557: CURSOR get_oks_line_dtls (p_id NUMBER)