1793: ,ai.relationship_id
1794: FROM ap_terms,
1795: ap_terms_lines,
1796: ap_invoices ai,
1797: ap_recurring_payments arp --bug 5332569
1798: WHERE ap_terms.term_id = ap_terms_lines.term_id
1799: AND ap_terms_lines.term_id = P_Terms_Id
1800: AND ap_terms_lines.sequence_num = l_sequence_num
1801: AND ai.Invoice_Id = P_Invoice_Id
1893:
1894: FROM ap_terms,
1895: ap_terms_lines,
1896: ap_invoices ai,
1897: ap_recurring_payments arp
1898: WHERE ap_terms.term_id = ap_terms_lines.term_id
1899: AND ap_terms_lines.term_id = P_Terms_Id
1900: AND ap_terms_lines.sequence_num = l_sequence_num
1901: AND ai.Invoice_Id = P_Invoice_Id
2126: ,ai.relationship_id
2127: FROM ap_terms,
2128: ap_terms_lines,
2129: ap_invoices ai,
2130: ap_recurring_payments arp
2131: WHERE ap_terms.term_id = ap_terms_lines.term_id
2132: AND ap_terms_lines.term_id = P_Terms_Id
2133: AND ap_terms_lines.sequence_num = l_sequence_num
2134: AND ai.invoice_id = P_Invoice_Id