DBA Data[Home] [Help]

APPS.GML_ORAUDTR_XMLP_PKG dependencies on DUAL

Line 99: DUAL;

95: ,'4'
96: ,'OP_CUST_MST.CUST_NO')
97: INTO MSORT3
98: FROM
99: DUAL;
100: SELECT
101: DECODE(P_SORT4
102: ,'1'
103: ,'OD.LAST_UPDATE_DATE'

Line 112: DUAL;

108: ,'4'
109: ,'OP_CUST_MST.CUST_NO')
110: INTO MSORT4
111: FROM
112: DUAL;
113: IF (P_SORT3 IS NOT NULL) THEN
114: P_SORTM := P_SORTM || ' , ' || MSORT3;
115: END IF;
116: IF (P_SORT4 IS NOT NULL) THEN

Line 131: DUAL;

127: ,'4'
128: ,'OP_CUST_MST.CUST_NO')
129: INTO DSORT3
130: FROM
131: DUAL;
132: SELECT
133: DECODE(P_SORT4
134: ,'1'
135: ,'AD.LAST_UPDATE_DATE'

Line 144: DUAL;

140: ,'4'
141: ,'OP_CUST_MST.CUST_NO')
142: INTO DSORT4
143: FROM
144: DUAL;
145: IF (P_SORT3 IS NOT NULL) THEN
146: P_SORTD := P_SORTD || ' , ' || DSORT3;
147: END IF;
148: IF (P_SORT4 IS NOT NULL) THEN