APPS.ZX_TAX_RECOVERY_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43

                SELECT pod.recovery_rate
                FROM po_distributions_all pod
                WHERE pod.po_distribution_id = p_distribution_id;

Line: 317

   SELECT chart_of_accounts_id
   INTO l_chart_of_accts
   FROM gl_sets_of_books,ap_system_parameters_all
   WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;

Line: 427

                SELECT tr.recovery_rate,tr.function,
		tr.concatenated_segment_low,tr.concatenated_segment_high
                FROM ap_tax_recvry_rates_all tr
	        WHERE tr.rule_id = p_rule
                AND p_tax_date BETWEEN tr.start_date AND nvl(tr.end_date,p_tax_date+ 1)
                AND tr.enabled_flag = 'Y'
		AND tr.condition_value IS NULL;

Line: 437

                SELECT tr.recovery_rate,tr.function,
		tr.concatenated_segment_low,tr.concatenated_segment_high
                FROM ap_tax_recvry_rates_all tr
	        WHERE tr.rule_id = p_rule
                AND p_tax_date BETWEEN tr.start_date AND nvl(tr.end_date,p_tax_date+ 1)
                AND tr.enabled_flag = 'Y'
		AND tr.condition_value = p_vendorclass;

Line: 649

                 SELECT pll.tax_code_id
                 from   po_line_locations_all pll,
                        po_distributions_all po
                 where pll.line_location_id = po.line_location_id and
                       po.po_distribution_id = p_distribution_id;

Line: 663

                SELECT tc.tax_recovery_rule_id, tc.tax_recovery_rate
                FROM ap_tax_codes_all tc
                WHERE tc.name = p_tax_code
                   AND p_tax_date BETWEEN tc.start_date
                AND nvl(tc.inactive_date,p_tax_date)
                AND tc.enabled_flag='Y' ;

Line: 678

                SELECT tc.tax_recovery_rule_id,tc.tax_recovery_rate
                FROM ap_tax_codes_all tc
                WHERE tc.tax_id = p_tax_id
                         AND tc.enabled_flag='Y';

Line: 684

                SELECT vendor_type_lookup_code
                FROM po_vendors
                WHERE po_vendors.vendor_id = p_vendor_id;

Line: 694

                SELECT match_on_tax_flag
                FROM ap_system_parameters_all;

Line: 704

                SELECT non_recoverable_tax_flag
                FROM FINANCIALS_SYSTEM_PARAMS_ALL;

Line: 710

                SELECT tax_from_po_flag
                FROM ap_system_parameters_all;

Line: 718

               SELECT tax_type
               FROM ap_tax_codes_all
               WHERE tax_id = p_tax_id;

Line: 723

               SELECT tax_type
               FROM ap_tax_codes_all
               WHERE tax_id in (SELECT
                     tax_id
                     FROM ap_tax_codes_all
                     WHERE
                     name = p_tax_code and
                     p_tax_date between start_date and
                     inactive_date and enabled_flag = 'Y');

Line: 822

                SELECT chart_of_accounts_id
                FROM gl_sets_of_books,ap_system_parameters_all
                WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;