DBA Data[Home] [Help]

APPS.QLTSSMPB dependencies on QA_PLANS

Line 17: FROM qa_plans

13: ARGUMENT2 IN NUMBER) IS
14:
15: CURSOR c (p_plan_name VARCHAR2) IS
16: SELECT plan_id
17: FROM qa_plans
18: WHERE name = p_plan_name;
19:
20: CURSOR c2 (p_org_id NUMBER) IS
21: SELECT plan_id

Line 22: FROM qa_plans

18: WHERE name = p_plan_name;
19:
20: CURSOR c2 (p_org_id NUMBER) IS
21: SELECT plan_id
22: FROM qa_plans
23: WHERE organization_id = p_org_id;
24:
25: l_plan_id NUMBER;
26: