APPS.QLTVCREB dependencies on QA_PLANS

Line 343: v_from_table(2) := 'qa_plans qp';

339: column_count := fixed_columns; -- 14
340:
341: -- Then add the necessary where and froms
342: v_from_table(1) := 'qa_results qr';
343: v_from_table(2) := 'qa_plans qp';
344: v_from_table(3) := 'fnd_user_view fu';
345: v_from_table(4) := 'fnd_user_view fu2';
346: v_from_table(5) := 'hr_organization_units hou';
347: j := 6;

Line 717: INTO v_deref_view_name FROM qa_plans

713: -- 12. QWB Usability Improvements Project
714: -- Deriving the Deref view name
715: --
716: SELECT substr(import_view_name, 1, length(import_view_name)-2)||'DV'
717: INTO v_deref_view_name FROM qa_plans
718: WHERE plan_id = x_plan_id;
719:
720: --
721: -- When QLTPLMDF deletes a plan, it calls this proc with

Line 784: qa_plans qp,

780: fu.user_name created_by,
781: qr.last_update_login';
782:
783: v_from := ' FROM qa_results qr,
784: qa_plans qp,
785: fnd_user_view fu,
786: fnd_user_view fu2,
787: hr_organization_units hou';
788:

Line 967: -- Updating the deref view name in the qa_plans table

963:
964: --
965: -- bug 6350575
966: -- 12.1 QWB Usability Improvements
967: -- Updating the deref view name in the qa_plans table
968: --
969: UPDATE qa_plans set deref_view_name = v_deref_view_name
970: WHERE plan_id = x_plan_id;
971:

Line 969: UPDATE qa_plans set deref_view_name = v_deref_view_name

965: -- bug 6350575
966: -- 12.1 QWB Usability Improvements
967: -- Updating the deref view name in the qa_plans table
968: --
969: UPDATE qa_plans set deref_view_name = v_deref_view_name
970: WHERE plan_id = x_plan_id;
971:
972: --
973: -- bug 7409976