DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_OPP_PVT dependencies on JTF_NOTE_CONTEXTS

Line 3499: JTF_NOTE_CONTEXTS context

3495: NOT EXISTS (
3496: SELECT
3497: context.jtf_note_id
3498: FROM
3499: JTF_NOTE_CONTEXTS context
3500: WHERE
3501: notes.jtf_note_id = context.jtf_note_id AND
3502: context.note_context_type = 'OPPORTUNITY' AND
3503: context.note_context_type_id = p_opportunity_id

Line 3520: INSERT INTO JTF_NOTE_CONTEXTS (

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
3522: , JTF_NOTE_ID
3523: , NOTE_CONTEXT_TYPE
3524: , NOTE_CONTEXT_TYPE_ID