APPS.ARP_REVERSE_RECEIPT dependencies on AR_ACTIVITY_DETAILS

Line 285: from ar_activity_details

281: -- Bug 7241111 to retain the old application record under activity details
282:
283: begin
284: select 'Y' into l_llca_exist
285: from ar_activity_details
286: where cash_receipt_id = p_cr_id
287: and nvl(CURRENT_ACTIVITY_FLAG,'Y') = 'Y';
288:
289: exception

Line 302: INSERT INTO AR_ACTIVITY_DETAILS(

298:
299:
300: IF NVL(l_llca_exist,'N') = 'Y' THEN
301:
302: INSERT INTO AR_ACTIVITY_DETAILS(
303: CASH_RECEIPT_ID,
304: CUSTOMER_TRX_LINE_ID,
305: ALLOCATED_RECEIPT_AMOUNT,
306: AMOUNT,

Line 396: ar_Activity_details_s.nextval,

392: LLD.OBJECT_VERSION_NUMBER,
393: LLD.CREATED_BY_MODULE,
394: LLD.SOURCE_ID,
395: LLD.SOURCE_TABLE,
396: ar_Activity_details_s.nextval,
397: 'R'
398: FROM ar_Activity_details LLD
399: where LLD.cash_receipt_id = p_cr_id
400: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';

Line 398: FROM ar_Activity_details LLD

394: LLD.SOURCE_ID,
395: LLD.SOURCE_TABLE,
396: ar_Activity_details_s.nextval,
397: 'R'
398: FROM ar_Activity_details LLD
399: where LLD.cash_receipt_id = p_cr_id
400: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
401:
402: UPDATE ar_Activity_details dtl

Line 402: UPDATE ar_Activity_details dtl

398: FROM ar_Activity_details LLD
399: where LLD.cash_receipt_id = p_cr_id
400: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
401:
402: UPDATE ar_Activity_details dtl
403: set CURRENT_ACTIVITY_FLAG = 'N'
404: where dtl.cash_receipt_id = p_cr_id
405: and nvl(dtl.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
406: