APPS.AS_SALES_LEAD_OPP_PVT dependencies on DUAL

Line 3485: -- SELECT JTF_NOTES_S.NEXTVAL INTO l_jtf_notes_context_id FROM DUAL;

3481: IS
3482: l_jtf_notes_context_id NUMBER;
3483:
3484: -- Selecting the JTF_NOTES_CONTEXT_ID.
3485: -- SELECT JTF_NOTES_S.NEXTVAL INTO l_jtf_notes_context_id FROM DUAL;
3486:
3487: CURSOR c_get_notes (x_sales_lead_id NUMBER, x_opportunity_id NUMBER) IS
3488: SELECT
3489: notes.jtf_note_id

Line 3517: SELECT JTF_NOTES_S.NEXTVAL INTO l_jtf_notes_context_id FROM DUAL;

3513: x_return_status := fnd_api.g_ret_sts_success;
3514:
3515: For notes_rec In c_get_notes (p_sales_lead_id, p_opportunity_id)
3516: Loop
3517: SELECT JTF_NOTES_S.NEXTVAL INTO l_jtf_notes_context_id FROM DUAL;
3518:
3519: -- Inserting into JTF_NOTES_CONTEXTS table
3520: INSERT INTO JTF_NOTE_CONTEXTS (
3521: NOTE_CONTEXT_ID