DBA Data[Home] [Help]

APPS.QA_QLTPLACR_XMLP_PKG dependencies on MFG_LOOKUPS

Line 25: MFG_LOOKUPS

21: SELECT
22: MEANING
23: INTO P_PLAN_ENABLED_MEANING
24: FROM
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';

Line 49: MFG_LOOKUPS

45: SELECT
46: MEANING
47: INTO P_ELEMENT_ENABLED_MEANING
48: FROM
49: MFG_LOOKUPS
50: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
51: AND LOOKUP_CODE = P_ELEMENT_ENABLED;
52: END IF;
53: IF (P_ORGANIZATION_ID IS NOT NULL) THEN

Line 64: MFG_LOOKUPS

60: CURSOR C1(ENABLED_MEANNING IN VARCHAR2) IS
61: SELECT
62: LOOKUP_CODE
63: FROM
64: MFG_LOOKUPS
65: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
66: AND MEANING = ENABLED_MEANNING;
67: TRANSLATED NUMBER;
68: BEGIN