APPS.GMDFMVAL_PUB dependencies on GEM_LOOKUPS

Line 536: FROM gem_lookups

532: /* Cursor Definitions. */
533: /* =================== */
534: CURSOR form_type_val IS
535: SELECT unique(lookup_code)
536: FROM gem_lookups
537: WHERE lookup_type = ptype_name
538: --Begin Bug#3090630 P.Raghu
539: --Removed TO_CHAR function for pvalue parameter.
540: AND lookup_code = pvalue;

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

1473: iret NUMBER;
1474: check_type_exception EXCEPTION;
1475: BEGIN
1476: /* Use the function type_val to validate the */
1477: /* field type. Checks if it exists in GEM_LOOKUPS */
1478: iret := GMDFMVAL_PUB.type_val( 'REWORK_TYPE',pType_value);
1479:
1480: If (iret <> 0) THEN
1481: xReturn := 'E';