APPS.GMI_RILOC_XMLP_PKG dependencies on DUAL

Line 85: DUAL;

81: ,' Range From: ' || FROM_WHSE || ' - All '
82: ,' Range From: ' || FROM_WHSE || ' - ' || TO_WHSE))
83: INTO RANGEV
84: FROM
85: DUAL;
86: ELSIF SORT_BY = 'Location' THEN
87: SELECT
88: DECODE(FROM_LOCATION
89: ,NULL

Line 100: DUAL;

96: ,' Range From: ' || FROM_LOCATION || ' - All '
97: ,' Range From: ' || FROM_LOCATION || ' - ' || TO_LOCATION))
98: INTO RANGEV
99: FROM
100: DUAL;
101: END IF;
102: RETURN (RANGEV);
103: END RANGE1CFFORMULA;
104:

Line 112: DUAL;

108: SELECT
109: 'All'
110: INTO FROM_LOCATIONCP
111: FROM
112: DUAL;
113: ELSE
114: FROM_LOCATIONCP := FROM_LOCATION;
115: END IF;
116: RETURN (FROM_LOCATIONCP);

Line 126: DUAL;

122: SELECT
123: 'All'
124: INTO TO_LOCATIONCP
125: FROM
126: DUAL;
127: ELSE
128: TO_LOCATIONCP := TO_LOCATION;
129: END IF;
130: RETURN (TO_LOCATIONCP);

Line 140: DUAL;

136: SELECT
137: 'All'
138: INTO FROM_WHSECP
139: FROM
140: DUAL;
141: ELSE
142: FROM_WHSECP := FROM_WHSE;
143: END IF;
144: RETURN (FROM_WHSECP);

Line 154: DUAL;

150: SELECT
151: 'All'
152: INTO TO_WHSECP
153: FROM
154: DUAL;
155: ELSE
156: TO_WHSECP := TO_WHSE;
157: END IF;
158: RETURN (TO_WHSECP);