DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on AR_SYSTEM_PARAMETERS

Line 39: l_location_structure_id ar_system_parameters.location_structure_id%type;

35: p_unit_selling_price IN NUMBER,
36: p_org_id IN NUMBER) IS --Bug fix 2367111
37:
38: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
39: l_location_structure_id ar_system_parameters.location_structure_id%type;
40: l_location_segment_num number;
41: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
42: l_tax_rounding_allow_override
43: ar_system_parameters.tax_rounding_allow_override%type;

Line 41: l_set_of_books_id ar_system_parameters.set_of_books_id%type;

37:
38: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
39: l_location_structure_id ar_system_parameters.location_structure_id%type;
40: l_location_segment_num number;
41: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
42: l_tax_rounding_allow_override
43: ar_system_parameters.tax_rounding_allow_override%type;
44: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
45: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;

Line 43: ar_system_parameters.tax_rounding_allow_override%type;

39: l_location_structure_id ar_system_parameters.location_structure_id%type;
40: l_location_segment_num number;
41: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
42: l_tax_rounding_allow_override
43: ar_system_parameters.tax_rounding_allow_override%type;
44: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
45: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
46: l_tax_rule_set ar_system_parameters.global_attribute13%type;
47: l_location_id hr_locations_all.location_id%type;

Line 44: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;

40: l_location_segment_num number;
41: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
42: l_tax_rounding_allow_override
43: ar_system_parameters.tax_rounding_allow_override%type;
44: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
45: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
46: l_tax_rule_set ar_system_parameters.global_attribute13%type;
47: l_location_id hr_locations_all.location_id%type;
48: l_org_class hr_locations_all.global_attribute1%type;

Line 45: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;

41: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
42: l_tax_rounding_allow_override
43: ar_system_parameters.tax_rounding_allow_override%type;
44: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
45: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
46: l_tax_rule_set ar_system_parameters.global_attribute13%type;
47: l_location_id hr_locations_all.location_id%type;
48: l_org_class hr_locations_all.global_attribute1%type;
49: l_taxable_basis ar_vat_tax.taxable_basis%type;

Line 46: l_tax_rule_set ar_system_parameters.global_attribute13%type;

42: l_tax_rounding_allow_override
43: ar_system_parameters.tax_rounding_allow_override%type;
44: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
45: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
46: l_tax_rule_set ar_system_parameters.global_attribute13%type;
47: l_location_id hr_locations_all.location_id%type;
48: l_org_class hr_locations_all.global_attribute1%type;
49: l_taxable_basis ar_vat_tax.taxable_basis%type;
50: l_tax_calculation_plsql_block

Line 258: FROM ar_system_parameters_all sys --Bugfix 2367111

254: l_tax_rounding_allow_override,
255: l_tax_header_level_flag,
256: l_tax_rounding_rule,
257: l_tax_rule_set
258: FROM ar_system_parameters_all sys --Bugfix 2367111
259: WHERE nvl(sys.org_id,-99) = nvl(p_org_id,-99); --Bugfix 2367111;
260:
261: EXCEPTION
262: WHEN NO_DATA_FOUND THEN

Line 562: AR_SYSTEM_PARAMETERS SYS

558: HZ_CUST_ACCT_SITES ACCT_SITE,
559: HZ_CUST_SITE_USES SITE,
560: HZ_PARTIES PARTY,
561: HZ_CUST_ACCOUNTS CUST_ACCT,
562: AR_SYSTEM_PARAMETERS SYS
563: WHERE SITE.SITE_USE_ID = l_site_use_id
564: AND SITE.SITE_USE_CODE = l_site_use_code
565: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
566: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID