APPS.IEX_WRITEOFFOBJ_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 166: from ar_payment_schedules

162: and orig_system_id = '23366';
163:
164: cursor c_get_ar_invoices(p_object_id IN VARCHAR2) is
165: select to_char(payment_schedule_id), invoice_currency_code, amount_due_remaining
166: from ar_payment_schedules
167: where customer_trx_id = p_object_id;
168: --where payment_schedule_id =p_object_id;
169:
170: cursor c_get_cont_invoices(p_object_id IN VARCHAR2,p_request_id IN NUMBER) is

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

546: from iex_writeoffs
547: where WRITEOFF_ID =p_WRITEOFF_ID;
548:
549:
550: --bug 8258156 add ar_payment_schedules_all to get org id
551: cursor c_get_writeoff_objects(p_WRITEOFF_ID IN NUMBER, p_request_id IN NUMBER) is
552: select writeoff_object_id, object_version_number, transaction_id,
553: adjustment_amount, contract_id, org_id
554: from iex_writeoff_objects io,ar_payment_schedules_all ap

Line 554: from iex_writeoff_objects io,ar_payment_schedules_all ap

550: --bug 8258156 add ar_payment_schedules_all to get org id
551: cursor c_get_writeoff_objects(p_WRITEOFF_ID IN NUMBER, p_request_id IN NUMBER) is
552: select writeoff_object_id, object_version_number, transaction_id,
553: adjustment_amount, contract_id, org_id
554: from iex_writeoff_objects io,ar_payment_schedules_all ap
555: where WRITEOFF_ID = p_WRITEOFF_ID
556: and writeoff_status ='W'
557: and transaction_id = payment_schedule_id(+)
558: and io.request_id = p_request_id;