DBA Data[Home] [Help]

APPS.ARP_PROCESS_LOCKBOX dependencies on AR_ACTIVITY_DETAILS_S

Line 3487: Select ar_activity_details_s.nextval

3483: FOR det_line IN interface_det_lines(inv_number,p_trans_req_id,p_cash_receipt_id) LOOP
3484: if det_line.status = 'AR_PLB_LINE_OK' then
3485: if det_line.apply_to not in ('FREIGHT','CHARGES') then
3486:
3487: Select ar_activity_details_s.nextval
3488: INTO l_line_id
3489: from dual;
3490:
3491: insert into AR_INTERIM_CASH_LINE_DETAILS(

Line 3622: Select ar_activity_details_s.nextval

3618: (line.amount_due_remaining/tot_frgt_chrg_amt),
3619: l_currency_code);
3620: END IF;
3621:
3622: Select ar_activity_details_s.nextval
3623: INTO l_line_id
3624: from dual;
3625:
3626: insert into AR_INTERIM_CASH_LINE_DETAILS(