11: SELECT
12: NAME
13: INTO P_PLAN_NAME
14: FROM
15: QA_PLANS
16: WHERE PLAN_ID = P_PLAN_NAME;
17: P_PLAN_LIMITER := 'and qp1.name = ''' || P_PLAN_NAME || '''';
18: END IF;
19: IF (P_PLAN_ENABLED IS NOT NULL) THEN
25: MFG_LOOKUPS
26: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
27: AND LOOKUP_CODE = P_PLAN_ENABLED;
28: IF P_ENABLED_FLAG = 1 THEN
29: P_TABLE := 'QA_PLANS_VAL_V';
30: ELSE
31: P_TABLE := 'QA_PLANS_V';
32: END IF;
33: END IF;
27: AND LOOKUP_CODE = P_PLAN_ENABLED;
28: IF P_ENABLED_FLAG = 1 THEN
29: P_TABLE := 'QA_PLANS_VAL_V';
30: ELSE
31: P_TABLE := 'QA_PLANS_V';
32: END IF;
33: END IF;
34: IF (P_ELEMENT IS NOT NULL) THEN
35: SELECT