APPS.BIS_PMV_SCHED_PARAMETERS_PVT SQL Statements

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

Line: 77

        select period_date
        from bis_user_attributes
        where schedule_id=pScheduleId and
        attribute_name = 'AS_OF_DATE';

Line: 531

 INSERT INTO BIS_USER_ATTRIBUTES (user_id, schedule_id, attribute_name, function_name,
                                      session_id, session_value, session_description,
                                      period_date, dimension, operator,
                                      creation_date, created_by,
                                      last_update_Date, last_updated_by)
                              VALUES (p_user_session_rec.user_id, p_user_session_rec.schedule_id,
                                      l_parameter_name,
                                      p_user_session_rec.function_name, p_user_session_rec.session_id,
                                      l_parameter_value, l_parameter_description,
                                      p_parameter_rec.period_date, l_dimension,
                                      p_parameter_rec.operator,
                                      sysdate, -1, sysdate, -1);