APPS.IEX_WRITEOFFOBJ_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 172: from ar_payment_schedules

168: and a.user_name = (select fu.user_name from fnd_user fu where fu.user_id = p_id);
169:
170: cursor c_get_ar_invoices(p_object_id IN VARCHAR2) is
171: select to_char(payment_schedule_id), invoice_currency_code, amount_due_remaining
172: from ar_payment_schedules
173: where customer_trx_id = p_object_id;
174: --where payment_schedule_id =p_object_id;
175:
176: cursor c_get_cont_invoices(p_object_id IN VARCHAR2,p_request_id IN NUMBER) is

Line 571: --bug 8258156 add ar_payment_schedules_all to get org id

567: from iex_writeoffs
568: where WRITEOFF_ID =p_WRITEOFF_ID;
569:
570:
571: --bug 8258156 add ar_payment_schedules_all to get org id
572: cursor c_get_writeoff_objects(p_WRITEOFF_ID IN NUMBER, p_request_id IN NUMBER) is
573: select writeoff_object_id, object_version_number, transaction_id,
574: adjustment_amount, contract_id, org_id
575: from iex_writeoff_objects io,ar_payment_schedules_all ap

Line 575: from iex_writeoff_objects io,ar_payment_schedules_all ap

571: --bug 8258156 add ar_payment_schedules_all to get org id
572: cursor c_get_writeoff_objects(p_WRITEOFF_ID IN NUMBER, p_request_id IN NUMBER) is
573: select writeoff_object_id, object_version_number, transaction_id,
574: adjustment_amount, contract_id, org_id
575: from iex_writeoff_objects io,ar_payment_schedules_all ap
576: where WRITEOFF_ID = p_WRITEOFF_ID
577: and writeoff_status ='W'
578: and transaction_id = payment_schedule_id(+)
579: and io.request_id = p_request_id;