DBA Data[Home] [Help]

APPS.IEX_WRITEOFFOBJ_PUB dependencies on AR_PAYMENT_SCHEDULES_ALL

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;