DBA Data[Home] [Help]

APPS.WSH_DEL_OI_CORE dependencies on SO_LOOKUPS

Line 1111: -- validates a code in so_lookups.

1107:
1108: -- Name : Validate_SO_Code
1109: --
1110: -- Notes
1111: -- validates a code in so_lookups.
1112: -- If both code/meaning are supplied for validation,
1113: -- meaing is ignored and preference is given to internal code.
1114: --
1115: PROCEDURE Validate_so_code

Line 1125: FROM so_lookups

1121: BEGIN
1122: declare
1123: cursor so_code_lookup is
1124: SELECT lookup_code
1125: FROM so_lookups
1126: WHERE lookup_type = X_LOOKUP_TYPE
1127: AND lookup_code = nvl(X_code,lookup_code)
1128: AND meaning = decode(X_code,null,X_meaning,meaning)
1129: AND nvl(start_date_active,sysdate) <= sysdate