DBA Data[Home] [Help]

APPS.GL_RECURRING_VALID_PERIODS_PKG SQL Statements

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

Line: 14

    SELECT vp1.period_name
    FROM   gl_recurring_valid_periods_v vp1,
           gl_recurring_valid_periods_v vp2
    WHERE  vp1.ledger_id = x_ledger_id
    AND    vp2.ledger_id = x_ledger_id
    AND    vp1.recurring_batch_id = x_recurring_batch_id
    AND    vp2.recurring_batch_id = x_recurring_batch_id
    AND    vp2.period_name = x_period
    AND    ( vp1.start_date =
               ( SELECT MIN( vp3.start_date )
                 FROM   gl_recurring_valid_periods_v vp3
                 WHERE  vp3.ledger_id = x_ledger_id
		 AND    vp3.recurring_batch_id = x_recurring_batch_id
                 AND    vp3.start_date > vp2.start_date ) );