APPS.ZX_TAX_RECOVERY_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 333: FROM gl_sets_of_books,ap_system_parameters_all

329: -- Get chart_of_account_id
330:
331: SELECT chart_of_accounts_id
332: INTO l_chart_of_accts
333: FROM gl_sets_of_books,ap_system_parameters_all
334: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
335:
336:
337: -- Call fnd_flex_ext.get_delimiter to get delimiter

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

330:
331: SELECT chart_of_accounts_id
332: INTO l_chart_of_accts
333: FROM gl_sets_of_books,ap_system_parameters_all
334: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
335:
336:
337: -- Call fnd_flex_ext.get_delimiter to get delimiter
338:

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

644: i number;
645: l_rec_rate NUMBER;
646: l_tax_code_id NUMBER ;
647: -- == l_non_rec_tax_flag financials_system_params_all.non_recoverable_tax_flag%TYPE;
648: -- == l_tax_from_po_flag ap_system_parameters_all.tax_from_po_flag%TYPE;
649: l_tax_rule_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;
650: lp_concatenate varchar2(2000);
651: l_cond_val po_vendors.vendor_type_lookup_code%TYPE;
652: l_tax_type ap_tax_codes_all.tax_type%type;

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

650: lp_concatenate varchar2(2000);
651: l_cond_val po_vendors.vendor_type_lookup_code%TYPE;
652: l_tax_type ap_tax_codes_all.tax_type%type;
653: l_get_rule_rate NUMBER;
654: -- == l_match_on_tax_flag ap_system_parameters_all.match_on_tax_flag%type;--added for bug 3960162.
655:
656: --REM
657: --REM-----------------------------------------------------------------------+
658: --REM To get the Tax code from PO

Line 709: FROM ap_system_parameters_all;

705: the recovery rate when PO matched with invoice.*/
706: /* ==
707: CURSOR c_get_match_on_tax_flag IS
708: SELECT match_on_tax_flag
709: FROM ap_system_parameters_all;
710: --end for 3960162
711: == */
712:
713: -- Bug Fix for 1003548 and Bug fix 1094321

Line 725: FROM ap_system_parameters_all;

721:
722: /* ==
723: CURSOR c_get_ap_system_parameter IS
724: SELECT tax_from_po_flag
725: FROM ap_system_parameters_all;
726: == */
727:
728: /* Bugfix 1161905 */
729:

Line 837: FROM gl_sets_of_books,ap_system_parameters_all

833:
834:
835: CURSOR c_chart_of_accts IS
836: SELECT chart_of_accounts_id
837: FROM gl_sets_of_books,ap_system_parameters_all
838: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
839:
840: BEGIN
841:

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

834:
835: CURSOR c_chart_of_accts IS
836: SELECT chart_of_accounts_id
837: FROM gl_sets_of_books,ap_system_parameters_all
838: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
839:
840: BEGIN
841:
842: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');