APPS.QA_SS_IMPORT_WF dependencies on QA_PLANS

Line 593: qa_plans qp

589: FUNCTION get_plan_name(p_id IN NUMBER) RETURN VARCHAR2 IS
590: p_name VARCHAR2(30);
591: cursor c IS
592: SELECT name FROM
593: qa_plans qp
594: WHERE
595: qp.plan_id = p_id;
596: BEGIN
597: open c;

Line 617: SELECT organization_id FROM qa_plans

613: FUNCTION get_org_id(p_id IN NUMBER) RETURN NUMBER IS
614: x_id NUMBER;
615: x_cursor_plan_id NUMBER;
616: cursor c(x_cursor_plan_id NUMBER) IS
617: SELECT organization_id FROM qa_plans
618: WHERE plan_id = x_cursor_plan_id;
619: BEGIN
620: open c(p_id);
621: fetch c INTO x_id;