APPS.IEX_NOTES_PVT dependencies on HZ_PARTIES

Line 436: -- FROM ast_notes_bali_vl notes, hz_parties p

432: -- AND ps.payment_schedule_id = object_id;
433: --
434: -- CURSOR c_note_party(x_jtf_note_id NUMBER) IS
435: -- SELECT p.party_name
436: -- FROM ast_notes_bali_vl notes, hz_parties p
437: -- WHERE jtf_note_id = x_jtf_note_id
438: -- AND object_code = 'PARTY'
439: -- AND object_id = p.party_id
440: -- AND p.party_type = 'ORGANIZATION';

Line 451: FROM jtf_note_contexts notes, hz_parties p

447: AND ps.payment_schedule_id = note_context_type_id;
448:
449: CURSOR c_note_party(x_jtf_note_id NUMBER) IS
450: SELECT p.party_name
451: FROM jtf_note_contexts notes, hz_parties p
452: WHERE jtf_note_id = x_jtf_note_id
453: AND note_context_type = 'PARTY'
454: AND note_context_type_id = p.party_id
455: AND p.party_type = 'ORGANIZATION';