APPS.OE_UPGRADE_WF2 dependencies on WF_ACTIVITY_ATTR_VALUES

Line 3167: wf_activity_attr_values attr_value1, wf_activity_attr_values attr_value2

3163:
3164: Cursor c1 is
3165: SELECT a.instance_id, a.instance_label, attr_value1.text_value
3166: FROM wf_process_activities a, wf_process_activities b,
3167: wf_activity_attr_values attr_value1, wf_activity_attr_values attr_value2
3168: WHERE a.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id)
3169: AND a.process_name = b.process_name
3170: AND a.activity_name like 'UPG_AN_OEOL_%WAIT_FOR_H'
3171: AND b.activity_name like 'UPG_AN_OEOL_%WAIT_FOR_H'

Line 3196: FROM wf_process_activities a, wf_activity_attr_values attr_value

3192: for c2 in c1 loop
3193: -- dbms_output.put_line('In wait_flow_adjusting: ' || c2.text_value);
3194: SELECT attr_value.text_value
3195: INTO v_continue_line_flow_label
3196: FROM wf_process_activities a, wf_activity_attr_values attr_value
3197: WHERE a.instance_label = c2.text_value
3198: AND a.process_name = 'UPG_PN_OEOH_REG_'||to_char(p_cycle_id)
3199: AND attr_value.process_activity_id = a.instance_id
3200: AND attr_value.name = 'WAITING_ACTIVITY';