APPS.GMD_QCRCOA03_XMLP_PKG dependencies on GEM_LOOKUPS

Line 10: GEM_LOOKUPS

6: SELECT
7: MEANING
8: INTO COA_REPORT_TITLE
9: FROM
10: GEM_LOOKUPS
11: WHERE LOOKUP_TYPE = 'GMD_COA_REPORT_TITLE'
12: AND LOOKUP_CODE = REPORT_TITLE;
13: RETURN (COA_REPORT_TITLE);
14: END CF_REPORT_NAMEFORMULA;

Line 39: GEM_LOOKUPS L,

35: SELECT
36: C.REPORT_TITLE,
37: MEANING
38: FROM
39: GEM_LOOKUPS L,
40: GMD_COA_HEADERS C
41: WHERE L.LOOKUP_TYPE = 'GMD_COA_REPORT_TITLE'
42: AND L.LOOKUP_CODE = C.REPORT_TITLE;
43: CURSOR GET_REPORT_TITLE_BLANK IS

Line 47: GEM_LOOKUPS L

43: CURSOR GET_REPORT_TITLE_BLANK IS
44: SELECT
45: MEANING
46: FROM
47: GEM_LOOKUPS L
48: WHERE L.LOOKUP_TYPE = 'GMD_COA_REPORT_TITLE'
49: AND L.LOOKUP_CODE = 'BLK';
50: PARAM_REC GMD_COA_DATA_OM_NEW.T_COA_PARAMETERS;
51: X_STATUS BOOLEAN;