DBA Data[Home] [Help]

APPS.GML_ORUARPJ_XMLP_PKG dependencies on DUAL

Line 50: DUAL;

46: ,'4'
47: ,8)
48: INTO DECODESQL
49: FROM
50: DUAL;
51: P_SORT := 'ORDER BY ' || DECODESQL;
52: SELECT
53: DECODE(P_SORT_2
54: ,'5'

Line 66: DUAL;

62: ,'4'
63: ,8)
64: INTO DECODESQL
65: FROM
66: DUAL;
67: P_SORT := P_SORT || ',' || DECODESQL;
68: SELECT
69: DECODE(P_SORT_3
70: ,'5'

Line 82: DUAL;

78: ,'4'
79: ,8)
80: INTO DECODESQL
81: FROM
82: DUAL;
83: P_SORT := P_SORT || ',' || DECODESQL;
84: IF (P_SORT_4 IS NOT NULL) THEN
85: IF (P_SORT_4 = '5') THEN
86: P_SORT := P_SORT || ' ,DTL.FROM_WHSE ';