DBA Data[Home] [Help]

APPS.CS_COST_DETAILS_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 520: hr_organization_information hoi1,

516:
517: CURSOR c_oper_unit_for_inv_org (p_txn_inv_org number) IS
518: SELECT To_number(hoi2.org_information3) OPERATING_UNIT
519: FROM hr_organization_units hou,
520: hr_organization_information hoi1,
521: hr_organization_information hoi2,
522: mtl_parameters mp
523: WHERE mp.organization_id = p_txn_inv_org
524: AND mp.organization_id = hou.organization_id

Line 521: hr_organization_information hoi2,

517: CURSOR c_oper_unit_for_inv_org (p_txn_inv_org number) IS
518: SELECT To_number(hoi2.org_information3) OPERATING_UNIT
519: FROM hr_organization_units hou,
520: hr_organization_information hoi1,
521: hr_organization_information hoi2,
522: mtl_parameters mp
523: WHERE mp.organization_id = p_txn_inv_org
524: AND mp.organization_id = hou.organization_id
525: AND hou.organization_id = hoi1.organization_id