APPS.IGI_ITR_UTILS_PKG SQL Statements

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

Line: 16

    EXECUTE immediate 'SELECT '|| X_segment_number ||' FROM igi_itr_charge_orig WHERE originator_id = :x_orig_id and  sysdate>start_date and nvl(end_date,sysdate) >= sysdate and charge_center_id = :x_charge_center'
    INTO l_segment_value
    USING IN  X_originator_id, X_charge_center;	--Bug 3977858

Line: 41

    'SELECT '|| X_segment_number ||' FROM  gl_code_combinations_kfv WHERE code_combination_id = :x_code_combination_id '||
    ' AND   chart_of_accounts_id = :x_chart_of_accounts_id '
    INTO    l_segment_value
    USING   IN X_code_combination_id, IN X_chart_of_accounts_id;