APPS.AP_PPA_PKG dependencies on AP_TERMS

Line 262: FROM ap_terms t,

258: ps.external_bank_account_id,
259: nvl(i.payment_currency_code,i.invoice_currency_code),
260: i.terms_date,
261: i.goods_received_date
262: FROM ap_terms t,
263: ap_invoice_distributions d,
264: ap_invoices i,
265: ap_payment_schedules ps
266: WHERE i.payment_status_flag = 'N'

Line 734: FROM ap_terms t

730:
731:
732: SELECT nvl(t.rank, 999), t.name
733: INTO p_po_rank, p_po_terms_name
734: FROM ap_terms t
735: WHERE t.term_id = p_po_term_id;
736:
737: --AP_LOGGING_PKG.AP_End_Block(l_debug_loc);
738:

Line 1130: FROM ap_terms_lines

1126: -------------------------------
1127:
1128: SELECT count(*)
1129: INTO p_last_term_ps_pay_num
1130: FROM ap_terms_lines
1131: WHERE term_id = p_term_id;
1132:
1133: ------------------------------------------------
1134: -- get percentage of amt_remaining vs gross_amt

Line 1376: FROM ap_terms_lines

1372: print(l_debug_info, l_debug_loc); --bug 9162299
1373:
1374: SELECT calendar
1375: INTO l_terms_calendar
1376: FROM ap_terms_lines
1377: WHERE term_id = p_term_id
1378: AND sequence_num = p_ps_pay_num;
1379:
1380: l_debug_info := 'l_terms_calendar '||l_terms_calendar;

Line 1551: FROM ap_terms t, ap_terms_lines atl

1547: p_discount_percent_2,
1548: p_discount_percent_3,
1549: p_due_amount,
1550: p_due_percent
1551: FROM ap_terms t, ap_terms_lines atl
1552: WHERE t.term_id = atl.term_id
1553: AND atl.term_id = p_term_id
1554: AND atl.sequence_num = p_ps_pay_num;
1555:

Line 1572: FROM ap_terms t, ap_terms_lines atl

1568: ROUND(due_amount / p_payment_cross_rate,l_precision),
1569: ROUND((due_amount / p_payment_cross_rate)/ l_min_unit) * l_min_unit))
1570: into p_gross_amount,
1571: p_inv_curr_gross_amount
1572: FROM ap_terms t, ap_terms_lines atl
1573: WHERE t.term_id = atl.term_id
1574: AND atl.term_id = p_term_id
1575: AND atl.sequence_num < p_ps_pay_num;
1576: