APPS.QLTVCREB dependencies on QA_PLANS

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

345: column_count := fixed_columns; -- 14
346:
347: -- Then add the necessary where and froms
348: v_from_table(1) := 'qa_results qr';
349: v_from_table(2) := 'qa_plans qp';
350: v_from_table(3) := 'fnd_user_view fu';
351: v_from_table(4) := 'fnd_user_view fu2';
352: v_from_table(5) := 'hr_organization_units hou';
353: j := 6;

Line 744: qa_plans qp,

740: fu.user_name created_by,
741: qr.last_update_login';
742:
743: v_from := ' FROM qa_results qr,
744: qa_plans qp,
745: fnd_user_view fu,
746: fnd_user_view fu2,
747: hr_organization_units hou';
748:

Line 976: INTO v_deref_view_name FROM qa_plans

972: -- 12. QWB Usability Improvements Project
973: -- Deriving the Deref view name
974: --
975: SELECT substr(import_view_name, 1, length(import_view_name)-2)||'DV'
976: INTO v_deref_view_name FROM qa_plans
977: WHERE plan_id = x_plan_id;
978:
979: --
980: -- When QLTPLMDF deletes a plan, it calls this proc with

Line 1029: -- qa_plans to qa_results

1025:
1026: --
1027: -- bug 9919908 fp to 9592090
1028: -- Added the hint to ensure that the drive happens from
1029: -- qa_plans to qa_results
1030: -- hmakam
1031: --
1032: --
1033: -- bug 12765034

Line 1062: qa_plans qp,

1058: fu.user_name created_by,
1059: qr.last_update_login';
1060:
1061: v_from := ' FROM qa_results qr,
1062: qa_plans qp,
1063: fnd_user_view fu,
1064: fnd_user_view fu2,
1065: hr_organization_units hou';
1066:

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

1248:
1249: --
1250: -- bug 6350575
1251: -- 12.1 QWB Usability Improvements
1252: -- Updating the deref view name in the qa_plans table
1253: --
1254: UPDATE qa_plans set deref_view_name = v_deref_view_name
1255: WHERE plan_id = x_plan_id;
1256:

Line 1254: UPDATE qa_plans set deref_view_name = v_deref_view_name

1250: -- bug 6350575
1251: -- 12.1 QWB Usability Improvements
1252: -- Updating the deref view name in the qa_plans table
1253: --
1254: UPDATE qa_plans set deref_view_name = v_deref_view_name
1255: WHERE plan_id = x_plan_id;
1256:
1257: --
1258: -- bug 7409976