DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on DUAL

Line 52: FROM sys.DUAL;

48: WHERE quote_header_id = x_qte_header_id;
49:
50: CURSOR C_Qte_Number IS
51: SELECT ASO_QUOTE_NUMBER_S.NEXTVAL
52: FROM sys.DUAL;
53:
54: CURSOR C_Qte_Status_Id (
55: c_status_code VARCHAR2
56: ) IS

Line 6984: SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;

6980: where a.instr_assignment_id = b.instr_assignment_id
6981: and b.trxn_extension_id = p_trxn_extension_id;
6982:
6983: Cursor c_get_payment_id is
6984: SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;
6985:
6986: begin
6987: SAVEPOINT COPY_PAYMENT_ROW_PVT;
6988: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');