DBA Data[Home] [Help]

APPS.OE_UPGRADE_WF2 dependencies on SO_ACTION_RESULTS

Line 349: so_action_results SAR,

345: max(20) custom_level,
346: max(SR.Description) description
347: FROM
348: so_actions SA,
349: so_action_results SAR,
350: so_results SR,
351: oe_upgrade_wf_act_map U
352: WHERE decode(SA.result_table,'SO_HEADERS','OEOH',
353: 'SO_LINES','OEOL','ERROR') = p_item_type

Line 489: select 'N' into v_fyi_flag from so_action_results

485: v_error_level := 2031;
486:
487: v_fyi_flag := 'N';
488: begin
489: select 'N' into v_fyi_flag from so_action_results
490: where action_id = c2.action_id
491: and rownum = 1;
492: exception
493: when no_data_found then

Line 3973: select 'N' into v_fyi_Flag from so_action_results

3969: v_action_id := NULL;
3970: end;
3971:
3972: begin
3973: select 'N' into v_fyi_Flag from so_action_results
3974: where action_id = v_action_id
3975: and rownum = 1;
3976: exception
3977: when no_data_found then