APPS.OE_UPGRADE_WF2 dependencies on WF_LOOKUPS

Line 381: FROM wf_lookups

377: v_lookup_code := c2.lookup_code;
378:
379: BEGIN
380: SELECT 'x' INTO v_dummy
381: FROM wf_lookups
382: WHERE ( lookup_type = c2.lookup_type AND
383: lookup_code = c2.lookup_code)
384: OR ( lookup_type = c2.lookup_type AND
385: meaning = c2.meaning);

Line 392: /* Insert data into WF_LOOKUPS_TL */

388: WHEN NO_DATA_FOUND THEN
389:
390: v_error_level := 2021;
391:
392: /* Insert data into WF_LOOKUPS_TL */
393: wf_load.upload_lookup
394: (
395: x_lookup_type => c2.lookup_type,
396: x_lookup_code => c2.lookup_code,

Line 2240: FROM wf_lookups

2236: IF (c6.act_result = c2.result_code) AND
2237: (c6.act_result <> '*') THEN
2238: BEGIN
2239: SELECT 'x' INTO v_dummy
2240: FROM wf_lookups
2241: WHERE lookup_type = 'UPG_RT_'||to_char(c6.action_id_c5)
2242: AND lookup_code = c6.act_result;
2243: EXCEPTION
2244: WHEN NO_DATA_FOUND THEN

Line 2337: FROM wf_lookups

2333:
2334: IF (c6.act_result = c2.result_code) AND (c6.act_result <> '*') THEN
2335: BEGIN
2336: SELECT 'x' INTO v_dummy
2337: FROM wf_lookups
2338: WHERE lookup_type = 'UPG_RT_'||to_char(c6.action_id_c5)
2339: AND lookup_code = c6.act_result;
2340: EXCEPTION
2341: WHEN NO_DATA_FOUND THEN

Line 2991: FROM wf_lookups

2987: );
2988: ELSE
2989: SELECT count(*)
2990: INTO v_lookup_count
2991: FROM wf_lookups
2992: WHERE lookup_type = (SELECT result_type
2993: FROM wf_activities
2994: WHERE name = c2.activity_name
2995: AND item_type = p_item_type