DBA Data[Home] [Help]

APPS.AMW_ORG_HIERARCHY_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 3012: hr_organization_information o2

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'
3016: and o2.org_information2 = 'Y'

Line 8501: hr_organization_information o2,

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
8505: and o2.org_information_context = 'CLASS'