DBA Data[Home] [Help]

APPS.AMW_RL_HIERARCHY_PKG dependencies on AMW_PROCESS_ORGANIZATION

Line 3254: from amw_process_organization

3250: forall ctr in x.first .. x.last
3251: update amw_process
3252: set org_count = (select count(*) from
3253: (select distinct organization_id
3254: from amw_process_organization
3255: where process_id = x(ctr)
3256: and end_date is null
3257: and (deletion_date is null or (deletion_date is not null and approval_date is null)))),
3258: object_version_number = object_version_number + 1

Line 3279: from amw_process_organization

3275: begin
3276: update amw_process
3277: set org_count = (select count(*) from
3278: (select distinct organization_id
3279: from amw_process_organization
3280: where process_id = p_process_id
3281: and end_date is null
3282: and (deletion_date is null or (deletion_date is not null and approval_date is null)))),
3283: object_version_number = object_version_number + 1