APPS.OE_UPGRADE_WF dependencies on WF_LOOKUPS

Line 376: FROM wf_lookups

372: v_lookup_code := c2.lookup_code;
373:
374: BEGIN
375: SELECT 'x' INTO v_dummy
376: FROM wf_lookups
377: WHERE ( lookup_type = c2.lookup_type AND
378: lookup_code = c2.lookup_code)
379: OR ( lookup_type = c2.lookup_type AND
380: meaning = c2.meaning);

Line 387: /* Insert data into WF_LOOKUPS_TL */

383: WHEN NO_DATA_FOUND THEN
384:
385: v_error_level := 2021;
386:
387: /* Insert data into WF_LOOKUPS_TL */
388: wf_load.upload_lookup
389: (
390: x_lookup_type => c2.lookup_type,
391: x_lookup_code => c2.lookup_code,

Line 2225: FROM wf_lookups

2221: IF (c6.act_result = c2.result_code) AND
2222: (c6.act_result <> '*') THEN
2223: BEGIN
2224: SELECT 'x' INTO v_dummy
2225: FROM wf_lookups
2226: WHERE lookup_type = 'UPG_RT_'||to_char(c6.action_id_c5)
2227: AND lookup_code = c6.act_result;
2228: EXCEPTION
2229: WHEN NO_DATA_FOUND THEN

Line 2322: FROM wf_lookups

2318:
2319: IF (c6.act_result = c2.result_code) AND (c6.act_result <> '*') THEN
2320: BEGIN
2321: SELECT 'x' INTO v_dummy
2322: FROM wf_lookups
2323: WHERE lookup_type = 'UPG_RT_'||to_char(c6.action_id_c5)
2324: AND lookup_code = c6.act_result;
2325: EXCEPTION
2326: WHEN NO_DATA_FOUND THEN

Line 2976: FROM wf_lookups

2972: );
2973: ELSE
2974: SELECT count(*)
2975: INTO v_lookup_count
2976: FROM wf_lookups
2977: WHERE lookup_type = (SELECT result_type
2978: FROM wf_activities
2979: WHERE name = c2.activity_name
2980: AND item_type = p_item_type