APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on HR_LOCATIONS_ALL

Line 47: l_location_id hr_locations_all.location_id%type;

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
51: ar_vat_tax.tax_calculation_plsql_block%type;

Line 48: l_org_class hr_locations_all.global_attribute1%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
51: ar_vat_tax.tax_calculation_plsql_block%type;
52: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;

Line 290: FROM HR_LOCATIONS_ALL HRL,

286: SELECT HRL.LOCATION_ID,
287: NVL(HRL.GLOBAL_ATTRIBUTE1, 'DEFAULT')
288: INTO l_location_id,
289: l_org_class
290: FROM HR_LOCATIONS_ALL HRL,
291: HR_ORGANIZATION_UNITS ORG
292: WHERE ORG.LOCATION_ID = HRL.LOCATION_ID
293: AND ORG.ORGANIZATION_ID = NVL(p_ship_from_org_id,
294: NVL(p_invoice_to_org_id,