DBA Data[Home] [Help]

APPS.AMW_ORG_HIERARCHY_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 3011: from hr_all_organization_units o,

3007:
3008: -- update the org count..
3009: update amw_process AP
3010: set AP.org_count = (select count(o.organization_id)
3011: from hr_all_organization_units o,
3012: hr_organization_information o2
3013: WHERE o.organization_id = o2.organization_id
3014: and o2.org_information_context = 'CLASS'
3015: and o2.org_information1 = 'AMW_AUDIT_UNIT'

Line 8500: from hr_all_organization_units o,

8496:
8497: -- update the org count..
8498: update amw_process AP
8499: set AP.org_count = (select COUNT(o.organization_id)
8500: from hr_all_organization_units o,
8501: hr_organization_information o2,
8502: amw_process_organization APO
8503: WHERE o.organization_id = o2.organization_id
8504: AND APO.organization_id = o.ORGANIZATION_ID