[Home] [Help]
1904: AND id = p_line_id
1905: AND (date_terminated IS NULL OR date_terminated > TRUNC(SYSDATE))
1906: AND date_cancelled IS NULL
1907: AND sts_code NOT IN ('CANCELLED', 'TERMINATED')
1908: AND end_date > NVL(oks_bill_util_pub.get_billed_upto(id, p_intent),
1909: end_date - 1);
1910:
1911: BEGIN
1912: