APPS.ASO_QUOTE_HEADERS_PVT dependencies on DUAL

Line 333: FROM dual;

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

Line 10914: FROM sys.dual;

10910:
10911: /* -- original cpy_qte
10912: CURSOR C_Qte_Number IS
10913: SELECT ASO_QUOTE_NUMBER_S.nextval
10914: FROM sys.dual;
10915:
10916: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
10917: SELECT max(quote_version)
10918: FROM ASO_QUOTE_HEADERS_ALL

Line 11688: FROM DUAL;

11684: -- as item values
11685: /*
11686: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
11687: SELECT INSTR(p_rec_item, '%', 1, 1)
11688: FROM DUAL;
11689: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
11690: SELECT INSTR(p_rec_item, '_', 1, 1)
11691: FROM DUAL;
11692: */

Line 11691: FROM DUAL;

11687: SELECT INSTR(p_rec_item, '%', 1, 1)
11688: FROM DUAL;
11689: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
11690: SELECT INSTR(p_rec_item, '_', 1, 1)
11691: FROM DUAL;
11692: */
11693: -- return values from cursors
11694: str_csr1 NUMBER;
11695: str_csr2 NUMBER;