APPS.GMDFMVAL_PUB dependencies on GEM_LOOKUPS

Line 528: FROM gem_lookups

524: /* Cursor Definitions. */
525: /* =================== */
526: CURSOR form_type_val IS
527: SELECT unique(lookup_code)
528: FROM gem_lookups
529: WHERE lookup_type = ptype_name
530: --Begin Bug#3090630 P.Raghu
531: --Removed TO_CHAR function for pvalue parameter.
532: AND lookup_code = pvalue;

Line 1629: /* field type. Checks if it exists in GEM_LOOKUPS */

1625: iret NUMBER;
1626: check_type_exception EXCEPTION;
1627: BEGIN
1628: /* Use the function type_val to validate the */
1629: /* field type. Checks if it exists in GEM_LOOKUPS */
1630: iret := GMDFMVAL_PUB.type_val('REWORK_TYPE', pType_value);
1631:
1632: If (iret <> 0) THEN
1633: xReturn := 'E';