DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on HR_ORGANIZATION_UNITS

Line 1456: hr_organization_units hou,

1452: /*CURSOR c_oper_unit_for_inv_org (p_txn_inv_org number) IS
1453: SELECT
1454: TO_NUMBER(hoi2.org_information3) OPERATING_UNIT
1455: FROM
1456: hr_organization_units hou,
1457: hr_organization_information hoi1,
1458: hr_organization_information hoi2,
1459: mtl_parameters mp
1460: WHERE

Line 1471: FROM hr_organization_units hou,

1467: AND hou.organization_id = hoi2.organization_id
1468: AND hoi2.org_information_context = 'Accounting Information' ;*/
1469: CURSOR c_inv_org_for_item (p_inv_id number) IS
1470: SELECT hou.organization_id inv_org_id
1471: FROM hr_organization_units hou,
1472: hr_organization_information hoi1,
1473: mtl_parameters mp,
1474: mtl_system_items_b msi
1475: WHERE