APPS.LNS_WORK_FLOW dependencies on JTF_NOTES_TL

Line 605: FROM jtf_notes_tl notes

601: AND lh.loan_id = p_loan_id;
602:
603: CURSOR get_last_entered_note IS
604: SELECT notes.notes
605: FROM jtf_notes_tl notes
606: WHERE notes.jtf_note_id = (SELECT max(note.jtf_note_id)
607: FROM jtf_notes_b note
608: WHERE note.source_object_code ='LNS_LOAN'
609: AND note.source_object_id = p_loan_id

Line 976: l_loan_approval_agent_note JTF_NOTES_TL.NOTES%TYPE;

972: l_event_action_id LNS_EVENT_ACTIONS.EVENT_ACTION_ID%TYPE;
973: l_org_id NUMBER;
974: l_user_id NUMBER;
975: l_product_name LNS_LOAN_PRODUCTS_ALL.LOAN_PRODUCT_NAME%TYPE;
976: l_loan_approval_agent_note JTF_NOTES_TL.NOTES%TYPE;
977:
978:
979: /*-----------------------------------------------------------------------+
980: | Cursor Declarations |

Line 1091: FROM jtf_notes_tl notes

1087: /* The below query will not work in case of multiple req for info and situations where user might
1088: not enter the note at all during submit for approval
1089: CURSOR get_agent_approval_comment IS
1090: SELECT notes.notes
1091: FROM jtf_notes_tl notes
1092: WHERE notes.jtf_note_id = (SELECT max(note.jtf_note_id)
1093: FROM jtf_notes_b note
1094: WHERE note.source_object_code ='LNS_LOAN'
1095: AND note.source_object_id = p_loan_id

Line 1102: FROM jtf_notes_tl notes

1098: */
1099:
1100: CURSOR get_agent_approval_comment IS
1101: SELECT notes.notes
1102: FROM jtf_notes_tl notes
1103: WHERE notes.jtf_note_id = (select jtf_note_id
1104: from jtf_note_contexts
1105: where note_context_type_id = (select max(action_id)
1106: from LNS_APPROVAL_ACTIONS