APPS.ASO_QUOTE_HEADERS_PVT dependencies on DUAL

Line 334: FROM dual;

330: l_valid_org_id number; --New variable to store org_id Yogeshwar (MOAC)
331:
332: CURSOR C_Qte_Number IS
333: SELECT ASO_QUOTE_NUMBER_S.nextval
334: FROM dual;
335:
336: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
337: SELECT quote_version
338: FROM ASO_QUOTE_HEADERS_ALL

Line 11985: FROM sys.dual;

11981:
11982: /* -- original cpy_qte
11983: CURSOR C_Qte_Number IS
11984: SELECT ASO_QUOTE_NUMBER_S.nextval
11985: FROM sys.dual;
11986:
11987: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
11988: SELECT max(quote_version)
11989: FROM ASO_QUOTE_HEADERS_ALL

Line 12759: FROM DUAL;

12755: -- as item values
12756: /*
12757: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
12758: SELECT INSTR(p_rec_item, '%', 1, 1)
12759: FROM DUAL;
12760: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
12761: SELECT INSTR(p_rec_item, '_', 1, 1)
12762: FROM DUAL;
12763: */

Line 12762: FROM DUAL;

12758: SELECT INSTR(p_rec_item, '%', 1, 1)
12759: FROM DUAL;
12760: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
12761: SELECT INSTR(p_rec_item, '_', 1, 1)
12762: FROM DUAL;
12763: */
12764: -- return values from cursors
12765: str_csr1 NUMBER;
12766: str_csr2 NUMBER;