APPS.QA_PLANS_PUB dependencies on QA_PLAN_CHAR_VALUE_LOOKUPS

Line 1589: INSERT INTO qa_plan_char_value_lookups(

1585:
1586: --
1587: -- Explain plan shows NOT IN performance is OK.
1588: --
1589: INSERT INTO qa_plan_char_value_lookups(
1590: plan_id,
1591: char_id,
1592: short_code,
1593: description,

Line 1611: FROM qa_plan_char_value_lookups

1607: p_user_id,
1608: sysdate,
1609: created_by,
1610: short_code_id
1611: FROM qa_plan_char_value_lookups
1612: WHERE plan_id = p_copy_from_plan_id AND char_id NOT IN
1613: (SELECT char_id
1614: FROM qa_plan_chars
1615: WHERE plan_id = p_copy_to_plan_id);

Line 2275: DELETE FROM qa_plan_char_value_lookups

2271:
2272: PROCEDURE delete_plan_element_values(p_plan_id IN NUMBER,
2273: p_element_id IN NUMBER) IS
2274: BEGIN
2275: DELETE FROM qa_plan_char_value_lookups
2276: WHERE plan_id = p_plan_id AND char_id = p_element_id;
2277: END delete_plan_element_values;
2278:
2279:

Line 2330: DELETE FROM qa_plan_char_value_lookups

2326:
2327:
2328: PROCEDURE delete_plan_values(p_plan_id IN NUMBER) IS
2329: BEGIN
2330: DELETE FROM qa_plan_char_value_lookups
2331: WHERE plan_id = p_plan_id;
2332: END delete_plan_values;
2333:
2334: