DBA Data[Home] [Help]

APPS.ARP_PROCESS_LOCKBOX dependencies on AR_ACTIVITY_DETAILS_S

Line 3468: Select ar_activity_details_s.nextval

3464: FOR det_line IN interface_det_lines(inv_number,p_trans_req_id,p_cash_receipt_id) LOOP
3465: if det_line.status = 'AR_PLB_LINE_OK' then
3466: if det_line.apply_to not in ('FREIGHT','CHARGES') then
3467:
3468: Select ar_activity_details_s.nextval
3469: INTO l_line_id
3470: from dual;
3471:
3472: insert into AR_INTERIM_CASH_LINE_DETAILS(

Line 3603: Select ar_activity_details_s.nextval

3599: (line.amount_due_remaining/tot_frgt_chrg_amt),
3600: l_currency_code);
3601: END IF;
3602:
3603: Select ar_activity_details_s.nextval
3604: INTO l_line_id
3605: from dual;
3606:
3607: insert into AR_INTERIM_CASH_LINE_DETAILS(