DBA Data[Home] [Help]

APPS.RCI_COMPL_ENV_CHG_SUMM_PKG dependencies on AMW_PROCESS_ORGANIZATION

Line 253: from amw_process_organization a

249: if (cur_rec.organization_id is not null and cur_rec.process_id is not null) then
250: l_significant_process := NULL;
251: select revision_number, significant_process_flag
252: into l_curr_rev_num, l_significant_process
253: from amw_process_organization a
254: where a.approval_date is not null
255: and a.approval_end_date is null
256: and process_id = cur_rec.process_id
257: and organization_id = cur_rec.organization_id;

Line 497: from amw_process_organization a

493: if (cur_rec.organization_id is not null and cur_rec.process_id is not null) then
494: l_significant_process := NULL;
495: select revision_number, significant_process_flag
496: into l_curr_rev_num, l_significant_process
497: from amw_process_organization a
498: where a.approval_date is not null
499: and a.approval_end_date is null
500: and process_id = cur_rec.process_id
501: and organization_id = cur_rec.organization_id;