DBA Data[Home] [Help]

APPS.IEX_NOTES_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 429: -- FROM ast_notes_bali_vl notes, ar_payment_schedules ps

425: RETURN VARCHAR2 IS
426: -- Begin fix bug #4930438-fix performance bug to remove MERGE JOIN CARTESIAN
427: -- CURSOR c_note_trx(x_jtf_note_id NUMBER) IS
428: -- SELECT ps.trx_number
429: -- FROM ast_notes_bali_vl notes, ar_payment_schedules ps
430: -- WHERE jtf_note_id = x_jtf_note_id
431: -- AND object_code = 'IEX_INVOICES'
432: -- AND ps.payment_schedule_id = object_id;
433: --

Line 444: FROM jtf_note_contexts notes, ar_payment_schedules ps

440: -- AND p.party_type = 'ORGANIZATION';
441:
442: CURSOR c_note_trx(x_jtf_note_id NUMBER) IS
443: SELECT ps.trx_number
444: FROM jtf_note_contexts notes, ar_payment_schedules ps
445: WHERE jtf_note_id = x_jtf_note_id
446: AND note_context_type = 'IEX_INVOICES'
447: AND ps.payment_schedule_id = note_context_type_id;
448: