APPS.QA_SS_IMPORT_WF dependencies on QA_PLANS

Line 623: qa_plans qp

619: FUNCTION get_plan_name(p_id IN NUMBER) RETURN VARCHAR2 IS
620: p_name VARCHAR2(30);
621: cursor c IS
622: SELECT name FROM
623: qa_plans qp
624: WHERE
625: qp.plan_id = p_id;
626: BEGIN
627: open c;

Line 647: SELECT organization_id FROM qa_plans

643: FUNCTION get_org_id(p_id IN NUMBER) RETURN NUMBER IS
644: x_id NUMBER;
645: x_cursor_plan_id NUMBER;
646: cursor c(x_cursor_plan_id NUMBER) IS
647: SELECT organization_id FROM qa_plans
648: WHERE plan_id = x_cursor_plan_id;
649: BEGIN
650: open c(p_id);
651: fetch c INTO x_id;