APPS.GLR03300_PKG SQL Statements

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

Line: 103

        SELECT  je_header_id,je_source,je_category,encumbrance_type_id,
        budget_version_id,currency_conversion_type , je_batch_id
        FROM gl_je_headers
        WHERE je_header_id=lv_header_id ;

Line: 109

        SELECT  user_je_source_name
        FROM gl_je_sources
        WHERE je_source_name= lv_gl_je_source ;

Line: 114

        SELECT  user_je_category_name
        FROM gl_je_categories
        WHERE je_category_name= lv_gl_je_category ;

Line: 119

        SELECT  encumbrance_type
        FROM gl_encumbrance_types
        WHERE encumbrance_type_id= lv_encumb_type_id ;

Line: 124

        SELECT  budget_name
        FROM gl_budget_versions
        WHERE budget_version_id= lv_bud_ver_id ;

Line: 129

        SELECT  user_conversion_type
        FROM gl_daily_conversion_types
        WHERE conversion_type = lv_curr_conv_type ;

Line: 135

        SELECT  description
        FROM gl_lookups
        WHERE lookup_type=decode ( lv_je_header_id,NULL,NULL,'MJE_BATCH_STATUS')
        AND lookup_code=substr( lv_status , 1 , 1);

Line: 143

        SELECT  meaning
        FROM gl_lookups
        WHERE lookup_type=decode ( lv_je_header_id,NULL,NULL,'JE_BATCH_BC_STATUS')
        AND lookup_code= lv_status ;

Line: 149

        select status,budgetary_control_status from  gl_je_batches where
        je_batch_id=lv_je_batch_id ;