APPS.JL_AR_AP_AWT_REPORTS_PKG dependencies on IBY_FD_PAYMENTS_V

Line 51: FROM iby_fd_payments_v

47:
48: CURSOR c_void_certificates (P_payment_Id IN Number) IS
49: SELECT payment_instruction_id,
50: paper_document_number
51: FROM iby_fd_payments_v
52: WHERE payment_id = p_payment_id;
53:
54: ------------------------------
55: BEGIN

Line 174: FROM IBY_FD_PAYMENTS_V ipmt,

170: aid.awt_gross_amount*nvl(aid.exchange_rate,1) taxable_base_amount,
171: ipmt.payment_date withholding_date,
172: atc.name tax_name,
173: docs.legal_entity_id legal_entity_id
174: FROM IBY_FD_PAYMENTS_V ipmt,
175: CE_BANK_ACCOUNTS aba,
176: IBY_FD_DOCS_PAYABLE_V docs,
177: AP_TAX_CODES_ALL atc,
178: AP_INVOICE_DISTRIBUTIONS_ALL aid,

Line 211: FROM iby_fd_payments_v ipmt,

207: aid.gross_amount taxable_base_amoun,
208: ipmt.payment_date withholding_date,
209: atc.name tax_name,
210: docs.legal_entity_id legal_entity_id
211: FROM iby_fd_payments_v ipmt,
212: ce_bank_accounts aba,
213: iby_fd_docs_payable_v docs,
214: ap_tax_codes_all atc,
215: AP_AWT_TEMP_DISTRIBUTIONS_ALL aid,