APPS.FEM_DIS_UTL_PKG SQL Statements

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

Line: 18

    SELECT FUNCTION_ID
    INTO v_func_id
    FROM FND_FORM_FUNCTIONS
    WHERE FUNCTION_NAME = Visual_Trace_URL.p_function_name;

Line: 78

            SELECT A.date_assign_value
        INTO   l_end_date
            FROM   fem_cal_periods_attr A,
                   fem_dim_attributes_b B,
               fem_dim_attr_versions_b C
        WHERE  A.cal_period_id = p_cal_period
        AND    A.attribute_id = B.attribute_id
        AND    B.attribute_varchar_label = 'CAL_PERIOD_END_DATE'
        AND    C.attribute_id = A.attribute_id
            AND    C.version_id = A.version_id
        AND    C.default_version_flag = 'Y';

Line: 91

        SELECT A.date_assign_value
        INTO   l_start_date
            FROM   fem_cal_periods_attr A,
                   fem_dim_attributes_b B,
               fem_dim_attr_versions_b C
        WHERE  A.cal_period_id = p_cal_period
        AND    A.attribute_id = B.attribute_id
        AND    B.attribute_varchar_label = 'CAL_PERIOD_START_DATE'
        AND    C.attribute_id = A.attribute_id
            AND    C.version_id = A.version_id
        AND    C.default_version_flag = 'Y';

Line: 256

   SELECT cal_period_name INTO l_prev_cal_period_name
   FROM   fem_cal_periods_vl
   WHERE  cal_period_id =p_period_id;