DBA Data[Home] [Help]

APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on FV_AR_CONTROLS

Line 1496: FROM fv_ar_controls a

1492: END IF;
1493: BEGIN
1494: SELECT a.last_accrual_date
1495: INTO p_last_accrual_date
1496: FROM fv_ar_controls a
1497: WHERE a.payment_schedule_id = p_payment_schedule_id
1498: AND a.created_from = p_charge_type;
1499: EXCEPTION
1500: WHEN NO_DATA_FOUND THEN

Line 1539: UPDATE fv_ar_controls a

1535: debug(l_module_name,'p_charge_type '||p_charge_type);
1536: debug(l_module_name,'p_last_accrual_date '||p_last_accrual_date);
1537: END IF;
1538:
1539: UPDATE fv_ar_controls a
1540: SET last_accrual_date = p_last_accrual_date
1541: WHERE a.payment_schedule_id = p_payment_schedule_id
1542: AND a.created_from = p_charge_type;
1543:

Line 1545: INSERT INTO fv_ar_controls

1541: WHERE a.payment_schedule_id = p_payment_schedule_id
1542: AND a.created_from = p_charge_type;
1543:
1544: IF (SQL%ROWCOUNT = 0) THEN
1545: INSERT INTO fv_ar_controls
1546: (
1547: payment_schedule_id,
1548: created_from,
1549: last_accrual_date,