DBA Data[Home] [Help]

APPS.JA_JAINST3_XMLP_PKG dependencies on JA_LOOKUPS

Line 1111: DESCRIPTION JA_LOOKUPS.DESCRIPTION%TYPE;

1107: BEGIN
1108: RETURN CS_1 + 2;
1109: END CF_1FORMULA0012;
1110: FUNCTION CF_SERVICE_TYPE_DESCFORMULA(SERVICE_TYPE_CODE IN VARCHAR2) RETURN CHAR IS
1111: DESCRIPTION JA_LOOKUPS.DESCRIPTION%TYPE;
1112: BEGIN
1113: SELECT
1114: DESCRIPTION
1115: INTO DESCRIPTION

Line 1117: JA_LOOKUPS

1113: SELECT
1114: DESCRIPTION
1115: INTO DESCRIPTION
1116: FROM
1117: JA_LOOKUPS
1118: WHERE LOOKUP_TYPE = 'JAI_SERVICE_TYPE'
1119: AND LOOKUP_CODE = SERVICE_TYPE_CODE;
1120: RETURN DESCRIPTION;
1121: END CF_SERVICE_TYPE_DESCFORMULA;