APPS.FV_ECON_BENF_DISC_PVT dependencies on AP_TERMS_LINES

Line 123: -- Bug 11834795: Discount_Pct is null if there are multiple rows in ap_terms_lines

119: BEGIN
120:
121:
122: /*Discount_Pct := (X_Discount_Amount / X_Invoice_Amount);*/
123: -- Bug 11834795: Discount_Pct is null if there are multiple rows in ap_terms_lines
124: IF Discount_Pct IS NULL THEN
125: Discount_Pct := (X_Discount_Amount / X_Invoice_Amount);
126: END IF;
127:

Line 626: -- Bug 11834795 : Pick discount % from ap_terms_lines table instead of calculating

622: --local variable l_discount_date passed to x_discount_date in CALCULATE_DISCOUNT
623: --which is defined as IN OUT parameter in CALCULATE_DISCOUNT.
624: l_discount_date:=x_discount_date;
625:
626: -- Bug 11834795 : Pick discount % from ap_terms_lines table instead of calculating
627: BEGIN
628: SELECT discount_percent/100 into
629: Discount_Pct
630: FROM ap_terms_lines

Line 630: FROM ap_terms_lines

626: -- Bug 11834795 : Pick discount % from ap_terms_lines table instead of calculating
627: BEGIN
628: SELECT discount_percent/100 into
629: Discount_Pct
630: FROM ap_terms_lines
631: WHERE term_id = x_terms_id;
632: EXCEPTION
633: WHEN OTHERS then
634: Discount_Pct := NULL;