APPS.GL_AUTOREVERSE_DATE_PKG SQL Statements

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

Line: 16

      SELECT effective_date_rule_code
      FROM   gl_je_sources
      WHERE  je_source_name = X_Je_Source;

Line: 21

      SELECT business_day_flag
      FROM   gl_transaction_dates
      WHERE  transaction_calendar_id = X_Trxn_Calendar_Id
      AND    transaction_date = X_Reversal_Date;

Line: 27

      SELECT max(transaction_date)
      FROM   gl_transaction_dates
      WHERE  transaction_calendar_id = X_Trxn_Calendar_Id
      AND    business_day_flag = 'Y'
      AND    transaction_date <= X_Reversal_Date;

Line: 34

      SELECT min(transaction_date)
      FROM   gl_transaction_dates
      WHERE  transaction_calendar_id = X_Trxn_Calendar_Id
      AND    business_day_flag = 'Y'
      AND    transaction_date >= X_Reversal_Date;

Line: 235

    SELECT enable_average_balances_flag,
           consolidation_ledger_flag,
           transaction_calendar_id,
           period_set_name,
           accounted_period_type,
	   criteria_set_id
    FROM   gl_ledgers
    WHERE  ledger_id = X_Ledger_Id;

Line: 245

    SELECT decode(method_code,'C','Y','N'),
           reversal_period_code,reversal_date_code
    FROM   gl_autoreverse_options
    WHERE  criteria_set_id = l_Criteria_Set_Id
    AND    je_category_name = X_Je_Category;

Line: 253

    SELECT period_name,closing_status,start_date,end_date,
           adjustment_period_flag
    FROM   gl_period_statuses p
    WHERE  p.application_id = 101
    AND    p.ledger_id = X_Ledger_Id
    AND    p.period_name = X_Je_Period_Name;

Line: 261

    SELECT period_name, closing_status, start_date, end_date,
           adjustment_period_flag
    FROM   gl_period_statuses p1
    WHERE  p1.application_id = 101
    AND    p1.ledger_id = X_Ledger_Id
    AND    p1.effective_period_num =
     ( SELECT min(effective_period_num)
       FROM   gl_period_statuses p1
       WHERE  p1.application_id = 101
       AND    p1.ledger_id = X_Ledger_Id
       AND    p1.effective_period_num >
          ( SELECT effective_period_num
            FROM gl_period_statuses p2
            WHERE p2.application_id = 101
            AND   p2.ledger_id = X_Ledger_Id
            AND   p2.period_name = X_Je_Period_Name));

Line: 279

    SELECT period_name, closing_status, start_date, end_date
    FROM   gl_period_statuses p
    WHERE  p.application_id = 101
    AND    p.ledger_id = X_Ledger_Id
    AND    p.effective_period_num =
     ( SELECT min(effective_period_num)
       FROM   gl_period_statuses p1
       WHERE  p1.application_id = 101
       AND    p1.ledger_id = X_Ledger_Id
       AND    adjustment_period_flag = 'N'
       AND    p1.effective_period_num >
          ( SELECT effective_period_num
            FROM gl_period_statuses p2
            WHERE p2.application_id = 101
            AND   p2.ledger_id = X_Ledger_Id
            AND   p2.period_name = X_Je_Period_Name));

Line: 301

        SELECT period_name, closing_status, start_date, end_date
        FROM   gl_period_statuses p
        WHERE  p.application_id = 101
        AND    p.ledger_id = X_Ledger_Id
        AND    p.effective_period_num =
          ( SELECT min(effective_period_num)
            FROM   gl_period_statuses p1
            WHERE  p1.application_id = 101
            AND    p1.ledger_id = X_Ledger_Id
            AND    reversal_date between p1.start_date and p1.end_date
            AND    p1.adjustment_period_flag = adj_period_flag);

Line: 602

	   SELECT DECODE(method_code,'C', 'Y', 'N'),
                  gll.enable_average_balances_flag,
           	  gll.consolidation_ledger_flag
	   INTO
		  X_Reversal_Method_code,
                  adb_flag, cons_flag
 	   FROM   GL_LEDGERS gll, GL_AUTOREVERSE_OPTIONS glao
	   WHERE  gll.ledger_id            = X_Ledger_Id
	   AND    glao.criteria_set_id(+)  = gll.Criteria_Set_Id
           AND    glao.je_category_name(+) = X_Category_Name;