APPS.AP_PPA_PKG dependencies on AP_TERMS

Line 240: FROM ap_terms t,

236: ps.external_bank_account_id,
237: nvl(i.payment_currency_code,i.invoice_currency_code),
238: i.terms_date,
239: i.goods_received_date
240: FROM ap_terms t,
241: ap_invoice_distributions d,
242: ap_invoices i,
243: ap_payment_schedules ps
244: WHERE i.payment_status_flag = 'N'

Line 709: FROM ap_terms t

705:
706:
707: SELECT nvl(t.rank, 999), t.name
708: INTO p_po_rank, p_po_terms_name
709: FROM ap_terms t
710: WHERE t.term_id = p_po_term_id;
711:
712: --AP_LOGGING_PKG.AP_End_Block(l_debug_loc);
713:

Line 1089: FROM ap_terms_lines

1085: -------------------------------
1086:
1087: SELECT count(*)
1088: INTO p_last_term_ps_pay_num
1089: FROM ap_terms_lines
1090: WHERE term_id = p_term_id;
1091:
1092: ------------------------------------------------
1093: -- get percentage of amt_remaining vs gross_amt

Line 1329: FROM ap_terms_lines

1325: l_debug_info := 'Get calendar for terms lines';
1326: --
1327: SELECT calendar
1328: INTO l_terms_calendar
1329: FROM ap_terms_lines
1330: WHERE term_id = p_term_id
1331: AND sequence_num = p_ps_pay_num;
1332:
1333: l_debug_info := 'Get due date info';

Line 1498: FROM ap_terms t, ap_terms_lines atl

1494: p_discount_percent_2,
1495: p_discount_percent_3,
1496: p_due_amount,
1497: p_due_percent
1498: FROM ap_terms t, ap_terms_lines atl
1499: WHERE t.term_id = atl.term_id
1500: AND atl.term_id = p_term_id
1501: AND atl.sequence_num = p_ps_pay_num;
1502: