APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on HR_LOCATIONS_ALL

Line 4048: l_location_id hr_locations_all.location_id%type;

4044: ar_system_parameters.tax_rounding_allow_override%type;
4045: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
4046: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
4047: l_tax_rule_set ar_system_parameters.global_attribute13%type;
4048: l_location_id hr_locations_all.location_id%type;
4049: l_org_class hr_locations_all.global_attribute1%type;
4050: l_taxable_basis ar_vat_tax.taxable_basis%type;
4051: l_tax_calculation_plsql_block
4052: ar_vat_tax.tax_calculation_plsql_block%type;

Line 4049: l_org_class hr_locations_all.global_attribute1%type;

4045: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
4046: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
4047: l_tax_rule_set ar_system_parameters.global_attribute13%type;
4048: l_location_id hr_locations_all.location_id%type;
4049: l_org_class hr_locations_all.global_attribute1%type;
4050: l_taxable_basis ar_vat_tax.taxable_basis%type;
4051: l_tax_calculation_plsql_block
4052: ar_vat_tax.tax_calculation_plsql_block%type;
4053: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;

Line 4065: FROM HR_LOCATIONS_ALL HRL ,

4061: -- Added by ssohal for Bug#8260273
4062: CURSOR get_org_class (c_org_id HR_ORGANIZATION_UNITS.organization_id%TYPE) IS
4063: SELECT HRL.LOCATION_ID,
4064: HRL.GLOBAL_ATTRIBUTE1
4065: FROM HR_LOCATIONS_ALL HRL ,
4066: HR_ORGANIZATION_UNITS ORG
4067: WHERE ORG.LOCATION_ID = HRL.LOCATION_ID
4068: AND ORG.ORGANIZATION_ID = c_org_id;
4069:

Line 4306: FROM HR_LOCATIONS_ALL HRL ,

4302: SELECT HRL.LOCATION_ID,
4303: NVL(HRL.GLOBAL_ATTRIBUTE1, 'DEFAULT')
4304: INTO l_location_id,
4305: l_org_class
4306: FROM HR_LOCATIONS_ALL HRL ,
4307: HR_ORGANIZATION_UNITS ORG
4308: WHERE ORG.LOCATION_ID = HRL.LOCATION_ID
4309: --++ nipatel verify this join condition
4310: --++ Condition changed for Bug#7438620