APPS.OE_UPGRADE_WF dependencies on WF_ACTIVITY_ATTR_VALUES

Line 3152: wf_activity_attr_values attr_value1, wf_activity_attr_values attr_value2

3148:
3149: Cursor c1 is
3150: SELECT a.instance_id, a.instance_label, attr_value1.text_value
3151: FROM wf_process_activities a, wf_process_activities b,
3152: wf_activity_attr_values attr_value1, wf_activity_attr_values attr_value2
3153: WHERE a.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id)
3154: AND a.process_name = b.process_name
3155: AND a.activity_name like 'UPG_AN_OEOL_%WAIT_FOR_H'
3156: AND b.activity_name like 'UPG_AN_OEOL_%WAIT_FOR_H'

Line 3181: FROM wf_process_activities a, wf_activity_attr_values attr_value

3177: for c2 in c1 loop
3178: -- dbms_output.put_line('In wait_flow_adjusting: ' || c2.text_value);
3179: SELECT attr_value.text_value
3180: INTO v_continue_line_flow_label
3181: FROM wf_process_activities a, wf_activity_attr_values attr_value
3182: WHERE a.instance_label = c2.text_value
3183: AND a.process_name = 'UPG_PN_OEOH_REG_'||to_char(p_cycle_id)
3184: AND attr_value.process_activity_id = a.instance_id
3185: AND attr_value.name = 'WAITING_ACTIVITY';