APPS.CST_PERIODSUMMARY_PVT SQL Statements

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

Line: 78

      SELECT schedule_close_date
      INTO   l_sched_close_date
      FROM   org_acct_periods
      WHERE  acct_period_id = p_period_id;

Line: 84

      SELECT legal_entity
      INTO   l_legal_entity
      FROM   cst_organization_definitions
      WHERE  organization_id = p_org_id;

Line: 99

      SELECT  COUNT(*)
      INTO    l_count
      FROM    mtl_material_transactions_temp
      WHERE   organization_id = p_org_id
      AND     transaction_date < l_sched_close_date
      AND     NVL(transaction_status,0) <> 2; -- 2 indicates a save-only status

Line: 111

      SELECT  COUNT(*)
      INTO    l_count
      FROM    mtl_material_transactions
      WHERE   organization_id = p_org_id
      AND     transaction_date < l_sched_close_date
      AND     costed_flag is not null;

Line: 123

      SELECT  COUNT(*)
      INTO    l_count
      FROM    wip_cost_txn_interface
      WHERE   organization_id = p_org_id
      AND     transaction_date < l_sched_close_date;

Line: 134

      SELECT  COUNT(*)
      INTO    l_count
      FROM    wsm_split_merge_transactions
      WHERE   organization_id = p_org_id
      AND     costed <> wip_constants.completed
      AND     transaction_date < l_sched_close_date;

Line: 146

      SELECT  COUNT(*)
      INTO    l_count
      FROM    wsm_split_merge_txn_interface
      WHERE   organization_id = p_org_id
      AND     process_status <> wip_constants.completed
      AND     transaction_date < l_sched_close_date;

Line: 160

      SELECT COUNT(*)
      INTO   l_count
      FROM   mtl_transaction_accounts
      WHERE  gl_batch_id = -1
      AND    organization_id = p_org_id
      AND    transaction_date < l_sched_close_date;

Line: 172

      SELECT COUNT(*)
      INTO   l_count
      FROM   wip_transaction_accounts
      WHERE  gl_batch_id = -1
      AND    organization_id = p_org_id
      AND    transaction_date < l_sched_close_date;

Line: 184

      UPDATE org_acct_periods
      SET    summarized_flag = 'N',
             open_flag = 'N'
      WHERE  organization_id = p_org_id
      AND    acct_period_id = p_period_id;

Line: 194

        SELECT ML.lookup_code
        INTO   l_rep_type
        FROM   mfg_lookups ML,
               mtl_parameters MP
        WHERE  MP.organization_id = p_org_id
        AND    ML.lookup_type = 'CST_PER_CLOSE_REP_TYPE'
        AND    ML.lookup_code =
               DECODE(MP.primary_cost_method,
                 1,DECODE(
                     MP.wms_enabled_flag,
                     'Y',1,
                     DECODE(
                       MP.cost_group_accounting,
                       1,DECODE(
                           MP.project_reference_enabled,
                           1,1,
                           2
                         ),
                       2
                     )
                   ),
                 1
               );

Line: 219

        SELECT currency_code
        INTO   l_currency_code
        FROM   gl_sets_of_books SOB,
               org_organization_definitions OOD
        WHERE  OOD.organization_id = p_org_id
        AND    OOD.set_of_books_id = SOB.set_of_books_id;

Line: 257

      UPDATE org_acct_periods
      SET    open_flag = 'Y'
      WHERE  organization_id = p_org_id
      AND    acct_period_id = p_period_id;

Line: 274

      UPDATE org_acct_periods
      SET    open_flag = 'Y'
      WHERE  organization_id = p_org_id
      AND    acct_period_id = p_period_id;

Line: 283

      UPDATE org_acct_periods
      SET    open_flag = 'Y'
      WHERE  organization_id = p_org_id
      AND    acct_period_id = p_period_id;