DBA Data[Home] [Help]

APPS.QA_AUDIT_PKG dependencies on QA_PC_PLAN_RELATIONSHIP

Line 296: FROM qa_results qr, qa_pc_plan_relationship qppr

292: CURSOR C(x_id NUMBER, x_org_id NUMBER, x_audit_num VARCHAR2) IS
293: SELECT qr.plan_id,
294: qr.collection_id,
295: qr.occurrence
296: FROM qa_results qr, qa_pc_plan_relationship qppr
297: WHERE qr.plan_id = qppr.parent_plan_id
298: AND qppr.child_plan_id = x_id
299: AND qr.organization_id = x_org_id
300: AND (qr.status = 2 OR qr.status IS NULL)