APPS.QA_PLANS_PUB dependencies on QA_PLAN_CHAR_VALUE_LOOKUPS

Line 1719: INSERT INTO qa_plan_char_value_lookups(

1715:
1716: --
1717: -- Explain plan shows NOT IN performance is OK.
1718: --
1719: INSERT INTO qa_plan_char_value_lookups(
1720: plan_id,
1721: char_id,
1722: short_code,
1723: description,

Line 1741: FROM qa_plan_char_value_lookups

1737: p_user_id,
1738: sysdate,
1739: created_by,
1740: short_code_id
1741: FROM qa_plan_char_value_lookups
1742: WHERE plan_id = p_copy_from_plan_id AND char_id NOT IN
1743: (SELECT char_id
1744: FROM qa_plan_chars
1745: WHERE plan_id = p_copy_to_plan_id);

Line 2405: DELETE FROM qa_plan_char_value_lookups

2401:
2402: PROCEDURE delete_plan_element_values(p_plan_id IN NUMBER,
2403: p_element_id IN NUMBER) IS
2404: BEGIN
2405: DELETE FROM qa_plan_char_value_lookups
2406: WHERE plan_id = p_plan_id AND char_id = p_element_id;
2407: END delete_plan_element_values;
2408:
2409:

Line 2460: DELETE FROM qa_plan_char_value_lookups

2456:
2457:
2458: PROCEDURE delete_plan_values(p_plan_id IN NUMBER) IS
2459: BEGIN
2460: DELETE FROM qa_plan_char_value_lookups
2461: WHERE plan_id = p_plan_id;
2462: END delete_plan_values;
2463:
2464: