APPS.QA_QLTPLACR_XMLP_PKG dependencies on QA_PLANS

Line 15: QA_PLANS

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

Line 29: P_TABLE := 'QA_PLANS_VAL_V';

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;

Line 31: P_TABLE := 'QA_PLANS_V';

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