APPS.FV_THIRD_PARTY_REMIT_PKG dependencies on AP_INVOICE_SELECTION_CRITERIA

Line 424: l_bank_account_id Ap_Invoice_Selection_Criteria.bank_account_id%TYPE;

420: l_discount_amount Ap_Invoices.discount_amount_taken%TYPE;
421: l_assignment_id Fv_Tpp_Assignments.assignment_id%TYPE;
422: l_checkrun_name Fv_Tpp_Check_Details.checkrun_name%TYPE;
423: l_check_num_fvtpp Fv_Tpp_Check_Details.check_number%TYPE;
424: l_bank_account_id Ap_Invoice_Selection_Criteria.bank_account_id%TYPE;
425: l_invoice_id Ap_Invoices.invoice_id%TYPE;
426: l_vendor_name Po_Vendors.vendor_name%TYPE;
427: l_site_code Po_Vendor_Sites.vendor_site_code%TYPE;
428: l_exists VARCHAR2(1);

Line 514: FROM fv_tpp_check_details fvcd, fv_tpp_assignments_all tpp, ap_invoice_selection_criteria apisc

510:
511: l_row_select := '
512: SELECT fvcd.assignment_id, tpp.original_supplier_id, tpp.original_supplier_site_id,
513: tpp.third_party_agent_id, tpp.third_party_site_id, fvcd.checkrun_name, fvcd.check_number
514: FROM fv_tpp_check_details fvcd, fv_tpp_assignments_all tpp, ap_invoice_selection_criteria apisc
515: WHERE '|| l_where_clause ||'
516: fvcd.checkrun_name = apisc.checkrun_name
517: AND apisc.status = '||''''|| 'CONFIRMED' ||''''||'
518: AND fvcd.set_of_books_id = '|| g_sob_id ||'

Line 617: FROM ap_invoice_selection_criteria

613:
614: BEGIN
615: SELECT bank_account_id
616: INTO l_bank_account_id
617: FROM ap_invoice_selection_criteria
618: WHERE checkrun_name = l_checkrun_name;
619:
620: g_message := ' Bank Account Id: '|| l_bank_account_id;
621: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);