APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on HR_ORGANIZATION_UNITS

Line 4062: CURSOR get_org_class (c_org_id HR_ORGANIZATION_UNITS.organization_id%TYPE) IS

4058: l_global_attribute6 mtl_system_items.global_attribute2%type;
4059: l_tax_classification_code ar_vat_tax_all_b.tax_code%type;
4060:
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

Line 4066: HR_ORGANIZATION_UNITS ORG

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:
4070: BEGIN

Line 4307: HR_ORGANIZATION_UNITS ORG

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
4311: AND ORG.ORGANIZATION_ID = NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_org_id(p_index),