DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_API_PKG dependencies on ENG_ECN_APPROVAL_LISTS

Line 322: FROM wf_roles r, eng_engineering_changes eec, eng_ecn_approval_lists al

318: /*
319: OLD CODE, removed for performance bug 3666795
320: SELECT r.name
321: INTO X_approval_list_name
322: FROM wf_roles r, eng_engineering_changes eec, eng_ecn_approval_lists al
323: WHERE eec.approval_list_id = al.approval_list_id
324: AND eec.organization_id = X_org_id
325: AND eec.change_notice = X_change_notice
326: AND al.approval_list_name = r.display_name ;

Line 336: FROM eng_ecn_approval_lists al, eng_engineering_changes eec

332: select r.name
333: INTO X_approval_list_name
334: from wf_local_roles r
335: where r.display_name in (SELECT al.approval_list_name
336: FROM eng_ecn_approval_lists al, eng_engineering_changes eec
337: WHERE eec.approval_list_id = al.approval_list_id
338: AND eec.organization_id = X_org_id
339: AND eec.change_notice = X_change_notice) ;
340: Exception