APPS.MSC_REPPERIODS_PUB SQL Statements

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

Line: 35

    SELECT  *
    INTO    param
    FROM    msc_parameters
    WHERE   organization_id = arg_org_id
      AND   sr_instance_id = arg_instance_id;

Line: 42

    msc_calendar.select_calendar_defaults(
        arg_org_id,
        arg_instance_id,
        var_calendar_code,
        var_exception_set_id);

Line: 49

    SELECT  MAX(calendar_date)
    INTO    var_max_date
    FROM    msc_calendar_dates
    WHERE   calendar_code = var_calendar_code
      AND   exception_set_id = var_exception_set_id
      AND   seq_num IS NOT NULL;

Line: 56

    DELETE FROM msc_repetitive_periods
    WHERE  organization_id = arg_org_id
      AND  sr_instance_id = arg_instance_id;

Line: 115

        SELECT  next_date
        INTO    var_curr_workday
        FROM    msc_calendar_dates
        WHERE   calendar_code = var_calendar_code
        AND     exception_set_id = var_exception_set_id
        AND     calendar_date = var_curr_date
		AND 	sr_instance_id = arg_instance_id;

Line: 124

            INSERT INTO msc_repetitive_periods
            (
                period_start_date,
                organization_id,
                sr_instance_id,
                last_update_date,
                last_updated_by,
                creation_date,
                created_by,
                last_update_login
            )
            VALUES
            (
                var_curr_workday,
                arg_org_id,
                arg_instance_id,
                SYSDATE,
                arg_user_id,
                SYSDATE,
                arg_user_id,
                -1
            );

Line: 211

    UPDATE msc_repetitive_periods s
    SET     period_start_date =
            (SELECT next_date
            FROM    msc_calendar_dates
            WHERE   calendar_code = var_calendar_code
              AND   exception_set_id = var_exception_set_id
              AND   calendar_date = s.period_start_date)
    WHERE   EXISTS
            (SELECT NULL
            FROM    msc_calendar_dates  d
            WHERE   NOT EXISTS
                    (SELECT NULL
                    FROM    msc_repetitive_periods
                    WHERE   organization_id = s.organization_id
                      AND   sr_instance_id = s.sr_instance_id
                      AND   period_start_date = d.next_date)
              AND   seq_num IS NULL
              AND   calendar_code = var_calendar_code
              AND   exception_set_id = var_exception_set_id
              AND   calendar_date = s.period_start_date)
      AND   sr_instance_id = arg_instance_id
      AND   organization_id = arg_org_id;

Line: 234

    DELETE FROM msc_repetitive_periods   s
    WHERE   organization_id = arg_org_id
      AND   sr_instance_id = arg_instance_id
      AND   EXISTS
            (SELECT NULL
            FROM    msc_calendar_dates  d
            WHERE   seq_num IS NULL
              AND   calendar_code = var_calendar_code
              AND   exception_set_id = var_exception_set_id
              AND   calendar_date = s.period_start_date);