APPS.AMW_EXCEPTIONS_PKG dependencies on AMW_PROCESS

Line 181: from wf_activities_tl watl, wf_activities wa, amw_process ap

177: where party_id = p_person_party_id;
178:
179: select watl.display_name
180: into l_nsp_disp_name
181: from wf_activities_tl watl, wf_activities wa, amw_process ap
182: where ap.process_id = p_Old_pk1
183: and ap.name = wa.name
184: and wa.item_type = 'AUDITMGR'
185: and wa.end_date is null

Line 193: from wf_activities_tl watl, wf_activities wa, amw_process ap

189: and watl.language = userenv('LANG');
190:
191: select watl.display_name
192: into l_sp_disp_name
193: from wf_activities_tl watl, wf_activities wa, amw_process ap
194: where ap.process_id = p_New_pk1
195: and ap.name = wa.name
196: and wa.item_type = 'AUDITMGR'
197: and wa.end_date is null