APPS.ARP_PAY_SCHED SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

				p_last_updated_by	       NUMBER,
				p_last_update_date	       DATE,
				p_last_update_login	       NUMBER) IS
BEGIN

    UPDATE AR_PAYMENT_SCHEDULES
    SET AMOUNT_DUE_REMAINING = p_amount_due_remaining,
        ACCTD_AMOUNT_DUE_REMAINING = p_acctd_amount_due_remaining,
        EXCHANGE_RATE = p_exchange_rate,
        EXCHANGE_DATE = p_exchange_date,
        EXCHANGE_RATE_TYPE = p_exchange_rate_type,
	LAST_UPDATED_BY = p_last_updated_by,
	LAST_UPDATE_DATE = p_last_update_date,
	LAST_UPDATE_LOGIN = p_last_update_login
    WHERE PAYMENT_SCHEDULE_ID = p_pay_id;

Line: 28

    /* need to call ar_mrc_engine to update AR_MC_PAYMENT_SCHEDULES */
--{BUG4301323
--    ar_mrc_engine.maintain_mrc_data(
--                p_event_mode       => 'UPDATE',
--                p_table_name       => 'AR_PAYMENT_SCHEDULES',
--                p_mode             => 'SINGLE',
--                p_key_value        => p_pay_id);

Line: 42

				p_last_updated_by	       NUMBER,
				p_last_update_date	       DATE,
				p_last_update_login	       NUMBER) IS
BEGIN

    UPDATE AR_PAYMENT_SCHEDULES
    SET AMOUNT_DUE_REMAINING = amt_due_remaining,
        ACCTD_AMOUNT_DUE_REMAINING = acctd_amt_due_remaining,
	LAST_UPDATED_BY = p_last_updated_by,
	LAST_UPDATE_DATE = p_last_update_date,
	LAST_UPDATE_LOGIN = p_last_update_login
    WHERE PAYMENT_SCHEDULE_ID = pay_id;

Line: 55

    /* need to call ar_mrc_engine to update AR_MC_PAYMENT_SCHEDULES */
--{BUG4301323
--    ar_mrc_engine.maintain_mrc_data(
--                p_event_mode       => 'UPDATE',
--                p_table_name       => 'AR_PAYMENT_SCHEDULES',
--                p_mode             => 'SINGLE',
--                p_key_value        => pay_id);