DBA Data[Home] [Help]

APPS.IEX_WRITEOFFOBJ_PUB dependencies on AR_PAYMENT_SCHEDULES_ALL

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;