DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 1457: hr_organization_information hoi1,

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
1461: mp.organization_id = p_txn_inv_org

Line 1458: hr_organization_information hoi2,

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
1461: mp.organization_id = p_txn_inv_org
1462: AND mp.organization_id = hou.organization_id

Line 1472: hr_organization_information hoi1,

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
1476: hou.organization_id = msi.organization_id