APPS.FV_THIRD_PARTY_REMIT_PKG dependencies on FV_TPP_CHECK_DETAILS

Line 10: g_org_id Fv_Tpp_Check_Details.org_id%TYPE;

6: -- -------------------------------------------------------------
7: g_module_name VARCHAR2(100) ;
8: g_errbuf VARCHAR2(1000);
9: g_retcode NUMBER := 0;
10: g_org_id Fv_Tpp_Check_Details.org_id%TYPE;
11: g_sob_id gl_ledgers.ledger_id%TYPE;
12: g_sob_name gl_ledgers.name%TYPE;
13: g_pay_date_from DATE;
14: g_pay_date_to DATE;

Line 396: -- fv_tpp_check_details table for Third Party Remittance

392: -- -------------------------------------------------------------
393: -- PROCEDURE PROCESS_TPP_CHECK_DETAIL_RECS
394: -- -------------------------------------------------------------
395: -- The purpose of this procedure is to process records in
396: -- fv_tpp_check_details table for Third Party Remittance
397: -- reporting
398: -- -------------------------------------------------------------
399: PROCEDURE PROCESS_TPP_CHECK_DETAIL_RECS IS
400: l_module_name VARCHAR2(200) ;

Line 422: l_checkrun_name Fv_Tpp_Check_Details.checkrun_name%TYPE;

418: l_invoice_num Ap_Invoices.invoice_num%TYPE;
419: l_invoice_amount Ap_Invoices.invoice_amount%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;

Line 423: l_check_num_fvtpp Fv_Tpp_Check_Details.check_number%TYPE;

419: l_invoice_amount Ap_Invoices.invoice_amount%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;

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 ||'