APPS.ZX_TAX_RECOVERY_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 319: FROM gl_sets_of_books,ap_system_parameters_all

315: -- Get chart_of_account_id
316:
317: SELECT chart_of_accounts_id
318: INTO l_chart_of_accts
319: FROM gl_sets_of_books,ap_system_parameters_all
320: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
321:
322:
323: -- Call fnd_flex_ext.get_delimiter to get delimiter

Line 320: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;

316:
317: SELECT chart_of_accounts_id
318: INTO l_chart_of_accts
319: FROM gl_sets_of_books,ap_system_parameters_all
320: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
321:
322:
323: -- Call fnd_flex_ext.get_delimiter to get delimiter
324:

Line 634: -- == l_tax_from_po_flag ap_system_parameters_all.tax_from_po_flag%TYPE;

630: i number;
631: l_rec_rate NUMBER;
632: l_tax_code_id NUMBER ;
633: -- == l_non_rec_tax_flag financials_system_params_all.non_recoverable_tax_flag%TYPE;
634: -- == l_tax_from_po_flag ap_system_parameters_all.tax_from_po_flag%TYPE;
635: l_tax_rule_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;
636: lp_concatenate varchar2(2000);
637: l_cond_val po_vendors.vendor_type_lookup_code%TYPE;
638: l_tax_type ap_tax_codes_all.tax_type%type;

Line 640: -- == l_match_on_tax_flag ap_system_parameters_all.match_on_tax_flag%type;--added for bug 3960162.

636: lp_concatenate varchar2(2000);
637: l_cond_val po_vendors.vendor_type_lookup_code%TYPE;
638: l_tax_type ap_tax_codes_all.tax_type%type;
639: l_get_rule_rate NUMBER;
640: -- == l_match_on_tax_flag ap_system_parameters_all.match_on_tax_flag%type;--added for bug 3960162.
641:
642: --REM
643: --REM-----------------------------------------------------------------------+
644: --REM To get the Tax code from PO

Line 695: FROM ap_system_parameters_all;

691: the recovery rate when PO matched with invoice.*/
692: /* ==
693: CURSOR c_get_match_on_tax_flag IS
694: SELECT match_on_tax_flag
695: FROM ap_system_parameters_all;
696: --end for 3960162
697: == */
698:
699: -- Bug Fix for 1003548 and Bug fix 1094321

Line 711: FROM ap_system_parameters_all;

707:
708: /* ==
709: CURSOR c_get_ap_system_parameter IS
710: SELECT tax_from_po_flag
711: FROM ap_system_parameters_all;
712: == */
713:
714: /* Bugfix 1161905 */
715:

Line 823: FROM gl_sets_of_books,ap_system_parameters_all

819:
820:
821: CURSOR c_chart_of_accts IS
822: SELECT chart_of_accounts_id
823: FROM gl_sets_of_books,ap_system_parameters_all
824: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
825:
826: BEGIN
827:

Line 824: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;

820:
821: CURSOR c_chart_of_accts IS
822: SELECT chart_of_accounts_id
823: FROM gl_sets_of_books,ap_system_parameters_all
824: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
825:
826: BEGIN
827:
828: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');