DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_PUB dependencies on WSH_LOOKUPS

Line 732: FROM wsh_lookups

728:
729: --RTV changes
730: CURSOR c_valid_source_code(c_source_code varchar2) IS
731: SELECT lookup_code
732: FROM wsh_lookups
733: WHERE lookup_code = c_source_code
734: AND lookup_type = 'SOURCE_SYSTEM'
735: AND lookup_code not in ('OKE','PO')
736: AND enabled_flag = 'Y';

Line 1054: FROM wsh_lookups

1050:
1051: --RTV changes
1052: CURSOR c_valid_source_code(c_source_code varchar2) IS
1053: SELECT lookup_code
1054: FROM wsh_lookups
1055: WHERE lookup_code = c_source_code
1056: AND lookup_type = 'SOURCE_SYSTEM'
1057: AND lookup_code not in ('OKE','PO')
1058: AND enabled_flag = 'Y';