APPS.GL_PERIOD_STATUS_SYNC_PUB SQL Statements

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

Line: 64

         SELECT *
           FROM gl_ledgers
          WHERE ledger_id IN (
                   SELECT gll2.ledger_id
                     FROM gl_ledgers gll1,
                          gl_ledgers gll2,
                          gl_ledger_relationships glrs
                    WHERE gll1.short_name = c_ledger_short_name
                      AND glrs.primary_ledger_id = gll1.ledger_id
                      AND gll2.object_type_code = c_object_type_code
                      AND glrs.target_ledger_id = gll2.ledger_id
                      AND glrs.application_id = c_application_id
                      AND glrs.relationship_enabled_flag =
                                                   c_relationship_enabled_flag);

Line: 88

         SELECT *
           FROM gl_period_statuses
          WHERE application_id = c_application_id                        --101
            AND closing_status <> c_closing_status                       --'O'
            AND ledger_id = c_ledger_id
            AND start_date >= c_start_date
            AND end_date <= c_end_date;

Line: 105

         SELECT *
           FROM gl_period_statuses
          WHERE application_id = c_application_id
            AND closing_status = c_closing_status
            AND ledger_id = c_ledger_id
            AND (start_date < c_start_date OR end_date > c_end_date);

Line: 119

         SELECT closing_status
           FROM gl_period_statuses
          WHERE ledger_id = c_ledger_id
            AND application_id = c_application_id
            AND period_name = c_period_name;

Line: 128

         SELECT 'Y'
           FROM DUAL
          WHERE EXISTS (SELECT short_name
                          FROM gl_ledgers
                         WHERE short_name = p_ledger_short_name);

Line: 141

         SELECT 'Y'
           FROM DUAL
          WHERE EXISTS (
                   SELECT 1
                     FROM gl_period_statuses gps, gl_ledgers gl
                    WHERE gl.ledger_id = gps.ledger_id
                      AND gps.application_id = c_application_id
                      AND gl.short_name = c_ledger_short_name
                      AND gps.start_date = c_start_date);

Line: 158

         SELECT 'Y'
           FROM DUAL
          WHERE EXISTS (
                   SELECT 1
                     FROM gl_period_statuses gps, gl_ledgers gl
                    WHERE gl.ledger_id = gps.ledger_id
                      AND gps.application_id = c_application_id
                      AND gl.short_name = c_ledger_short_name
                      AND gps.end_date = c_end_date);