DBA Data[Home] [Help]

APPS.OKE_HOLD_UTILS dependencies on FND_LOOKUP_VALUES_VL

Line 46: FROM fnd_lookup_values_vl

42: WHERE hold_status_code = P_Old_Status_Code;
43:
44: CURSOR hold_reason IS
45: SELECT meaning
46: FROM fnd_lookup_values_vl
47: WHERE lookup_type = 'APPLY_HOLD_REASON'
48: AND lookup_code = P_Hold_reason_Code;
49:
50: CURSOR remove_reason IS

Line 52: FROM fnd_lookup_values_vl

48: AND lookup_code = P_Hold_reason_Code;
49:
50: CURSOR remove_reason IS
51: SELECT meaning
52: FROM fnd_lookup_values_vl
53: WHERE lookup_type = 'REMOVE_HOLD_REASON'
54: AND lookup_code = P_Remove_reason_Code;
55:
56: CURSOR hold_type IS

Line 58: FROM fnd_lookup_values_vl

54: AND lookup_code = P_Remove_reason_Code;
55:
56: CURSOR hold_type IS
57: SELECT meaning
58: FROM fnd_lookup_values_vl
59: WHERE lookup_type = 'HOLD_TYPE'
60: AND lookup_code = P_Hold_type_Code;
61:
62: CURSOR o IS