APPS.ARP_PROCESS_ADJUSTMENT dependencies on AR_ACTIVITY_DETAILS

Line 1507: SELECT ar_activity_details_s.nextval

1503: --================== For LLCA adjustment, inserting into Activity Details Table =================
1504: IF p_app_level = 'LINE'
1505: THEN
1506:
1507: SELECT ar_activity_details_s.nextval
1508: INTO l_line_id
1509: FROM dual;
1510:
1511: SELECT

Line 1520: INSERT INTO AR_ACTIVITY_DETAILS (

1516: l_tax_adjusted
1517: FROM ar_adjustments
1518: WHERE adjustment_id = l_adjustment_id;
1519:
1520: INSERT INTO AR_ACTIVITY_DETAILS (
1521: LINE_ID,
1522: APPLY_TO,
1523: customer_trx_line_id,
1524: CASH_RECEIPT_ID,

Line 2041: UPDATE AR_ACTIVITY_DETAILS

2037: l_tax_adjusted
2038: FROM ar_adjustments
2039: WHERE adjustment_id = p_adjustment_id;
2040:
2041: UPDATE AR_ACTIVITY_DETAILS
2042: SET AMOUNT = l_line_adjusted,
2043: TAX = l_tax_adjusted
2044: WHERE SOURCE_TABLE = 'ADJ'
2045: AND SOURCE_ID = p_adjustment_id