APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on HR_LOCATIONS_ALL

Line 3726: l_location_id hr_locations_all.location_id%type;

3722: ar_system_parameters.tax_rounding_allow_override%type;
3723: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
3724: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
3725: l_tax_rule_set ar_system_parameters.global_attribute13%type;
3726: l_location_id hr_locations_all.location_id%type;
3727: l_org_class hr_locations_all.global_attribute1%type;
3728: l_taxable_basis ar_vat_tax.taxable_basis%type;
3729: l_tax_calculation_plsql_block
3730: ar_vat_tax.tax_calculation_plsql_block%type;

Line 3727: l_org_class hr_locations_all.global_attribute1%type;

3723: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
3724: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
3725: l_tax_rule_set ar_system_parameters.global_attribute13%type;
3726: l_location_id hr_locations_all.location_id%type;
3727: l_org_class hr_locations_all.global_attribute1%type;
3728: l_taxable_basis ar_vat_tax.taxable_basis%type;
3729: l_tax_calculation_plsql_block
3730: ar_vat_tax.tax_calculation_plsql_block%type;
3731: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;

Line 3929: FROM HR_LOCATIONS_ALL HRL ,

3925: SELECT HRL.LOCATION_ID,
3926: NVL(HRL.GLOBAL_ATTRIBUTE1, 'DEFAULT')
3927: INTO l_location_id,
3928: l_org_class
3929: FROM HR_LOCATIONS_ALL HRL ,
3930: HR_ORGANIZATION_UNITS ORG
3931: WHERE ORG.LOCATION_ID = HRL.LOCATION_ID
3932: --++ nipatel verify this join condition
3933: --++ Condition changed for Bug#7438620