APPS.OKS_BILL_SCH dependencies on OKS_SUBSCR_ELEMENTS

Line 8141: FROM OKS_SUBSCR_ELEMENTS

8137: IS
8138:
8139: CURSOR l_subcription_amt_csr(p_line_id NUMBER, p_term_dt DATE) IS
8140: SELECT nvl(SUM(amount) ,0) sub_amt
8141: FROM OKS_SUBSCR_ELEMENTS
8142: WHERE dnz_cle_id = p_line_id;
8143:
8144: ----commented for bug#3222008.terminate program first call recreate fulfillemt schedule so
8145: ----take amt from rest of fulfillemt sch.