APPS.GL_JE_HEADER_SECURITY SQL Statements

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

Line: 21

      SELECT ldg.ledger_id,
             ldg.bal_seg_value_option_code,
             ldg.mgt_seg_value_option_code
      FROM   GL_LEDGERS ldg,
             GL_JE_HEADERS h
      WHERE  ldg.ledger_id = h.ledger_id
        AND  h.je_header_id = p_je_header_id;

Line: 34

      SELECT  'Invalid'
      FROM    GL_JE_SEGMENT_VALUES jsv
      WHERE   jsv.segment_type_code = p_segment_type_code
        AND   jsv.je_header_id = p_je_header_id
        AND   NOT EXISTS (SELECT 'Valid'
                          FROM   GL_LEDGER_SEGMENT_VALUES sv
                          WHERE  NVL(trunc(p_edate), NVL(sv.start_date,TO_DATE('1950/01/01','YYYY/MM/DD')))
                                 BETWEEN NVL(sv.start_date,TO_DATE('1950/01/01','YYYY/MM/DD'))
                                     AND NVL(sv.end_date,TO_DATE('9999/01/01','YYYY/MM/DD'))
                            AND  sv.segment_value = jsv.segment_value
                            AND  sv.segment_type_code = p_segment_type_code
                            AND  sv.ledger_id = p_ledger_id);

Line: 51

      SELECT  'Invalid'
      FROM    GL_JE_SEGMENT_VALUES jsv
      WHERE   jsv.je_header_id = p_je_header_id
        AND   NOT EXISTS (SELECT 'Valid'
                          FROM   GL_LEDGER_SEGMENT_VALUES sv
                          WHERE  NVL(trunc(p_edate), NVL(sv.start_date,TO_DATE('1950/01/01','YYYY/MM/DD')))
                                 BETWEEN NVL(sv.start_date,TO_DATE('1950/01/01','YYYY/MM/DD'))
                                     AND NVL(sv.end_date,TO_DATE('9999/01/01','YYYY/MM/DD'))
                            AND  sv.segment_value = jsv.segment_value
                            AND  sv.segment_type_code = jsv.segment_type_code
                            AND  sv.ledger_id = p_ledger_id);

Line: 172

    SELECT je_batch_id
    INTO x_je_batch_id
    FROM gl_je_headers
    WHERE je_header_id = x_je_header_id;