APPS.AP_PPA_PKG dependencies on AP_TERMS_LINES

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: