564: IS
565: SELECT
566: invoicing_rule_id
567: FROM
568: oe_order_lines_all
569: WHERE
570: line_id = p_line_id;
571:
572: l_proc varchar2(72) := g_package||'get_invoice_rule';
873: p_exist OUT NOCOPY VARCHAR2)
874: IS
875:
876: l_proc varchar2(72) := g_package||'check_invoice';
877: l_invoice_quantity oe_order_lines.invoiced_quantity%type;
878:
879:
880: CURSOR c_invoice IS
881: SELECT
880: CURSOR c_invoice IS
881: SELECT
882: decode(invoiced_quantity,null,0,invoiced_quantity)
883: FROM
884: oe_order_lines_all
885: WHERE
886: line_id = p_line_id;
887:
888: