DBA Data[Home] [Help]

APPS.POA_CM_EVAL_SCORES_ICX dependencies on HR_OPERATING_UNITS

Line 541: FROM HR_OPERATING_UNITS

537: if (l_oper_unit_id is null) and (l_operating_unit is not null) then
538:
539: SELECT min(organization_id)
540: INTO l_oper_unit_id
541: FROM HR_OPERATING_UNITS
542: WHERE name = l_operating_unit AND EXISTS (
543: SELECT '1' FROM PO_VENDOR_SITES_ALL WHERE
544: vendor_site_id = nvl(l_supplier_site_id, vendor_site_id));
545:

Line 1419: hr_operating_units hr,

1415: fu.user_name,
1416: pce.creation_date,
1417: pce.last_update_date
1418: FROM poa_cm_evaluation pce,
1419: hr_operating_units hr,
1420: fnd_user fu,
1421: mtl_categories_kfv cat,
1422: mtl_system_items_kfv item,
1423: po_vendor_sites pvs

Line 1447: hr_operating_units hr,

1443: fu.user_name,
1444: pce.creation_date,
1445: pce.last_update_date
1446: FROM poa_cm_evaluation pce,
1447: hr_operating_units hr,
1448: fnd_user fu,
1449: mtl_categories_kfv cat,
1450: mtl_system_items_kfv item,
1451: po_vendor_sites pvs

Line 1475: hr_operating_units hr,

1471: fu.user_name,
1472: pce.creation_date,
1473: pce.last_update_date
1474: FROM poa_cm_evaluation pce,
1475: hr_operating_units hr,
1476: fnd_user fu,
1477: mtl_categories_kfv cat,
1478: mtl_system_items_kfv item,
1479: po_vendor_sites pvs

Line 1504: hr_operating_units hr,

1500: fu.user_name,
1501: pce.creation_date,
1502: pce.last_update_date
1503: FROM poa_cm_evaluation pce,
1504: hr_operating_units hr,
1505: fnd_user fu,
1506: mtl_categories_kfv cat,
1507: mtl_system_items_kfv item,
1508: po_vendor_sites pvs