APPS.GL_WF_JE_APPROVAL_PKG SQL Statements

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

Line: 32

    SELECT led.ledger_id,
           max(abs(nvl(jel.accounted_dr, 0) -
                   nvl(jel.accounted_cr, 0))) LARGEST_NET_AMOUNT
    FROM   GL_JE_HEADERS jeh, GL_JE_LINES jel, GL_LEDGERS led
    WHERE  jeh.je_batch_id = p_batch_id
    AND    jeh.currency_code <> 'STAT'
    AND    jel.je_header_id = jeh.je_header_id
    AND    led.ledger_id = jeh.ledger_id
    AND    led.enable_je_approval_flag = 'Y'
    GROUP BY led.ledger_id;

Line: 46

    SELECT nvl(min(authorization_limit), -1)
    INTO   l_limit
    FROM   GL_AUTHORIZATION_LIMITS
    WHERE  employee_id = p_employee_id
    AND    ledger_id = ledger_rec.ledger_id;

Line: 79

  SELECT A.supervisor_id
  INTO   manager_id
  FROM   PER_ALL_PEOPLE_F P, PER_ALL_ASSIGNMENTS_F A
  WHERE  P.business_group_id + 0 = A.business_group_id
  AND    P.employee_number IS NOT NULL
  AND    TRUNC(sysdate) BETWEEN P.effective_start_date AND P.effective_end_date
  AND    A.primary_flag = 'Y'
  AND    A.assignment_type = 'E'
  AND    A.person_id = P.person_id
  AND    TRUNC(sysdate) BETWEEN A.effective_start_date AND A.effective_end_date
  AND    P.person_id = employee_id;

Line: 292

  UPDATE gl_je_batches
  SET approval_status_code = 'I'
  WHERE je_batch_id = p_je_batch_id;

Line: 297

  SELECT GL_JE_APPROVAL_S.nextval
  INTO   l_approval_run_id
  FROM   DUAL;

Line: 302

  SELECT user_name, nvl(employee_id, -1)
  INTO   l_fnd_user_name, l_preparer_id
  FROM   fnd_user
  WHERE  user_id = p_preparer_fnd_user_id;

Line: 378

  SELECT min(business_group_id)
  INTO   l_business_group_id
  FROM   per_all_people_f
  WHERE  person_id = l_preparer_id
  AND    trunc(sysdate) BETWEEN effective_start_date AND effective_end_date;

Line: 385

  SELECT max(name)
  INTO   l_reassign_role
  FROM   WF_LOCAL_ROLES
  WHERE  name IN ('GL_JE_APPROVAL_REASSIGN_ROLE' || ' ' || l_business_group_id,
                  'GL_JE_APPROVAL_REASSIGN_ROLE')
  AND    nvl(expiration_date, sysdate + 1) > sysdate;

Line: 499

    SELECT led.ledger_id
    FROM   GL_LEDGERS led
    WHERE  led.ledger_id IN (SELECT jeh.ledger_id
                             FROM   GL_JE_HEADERS jeh
                             WHERE  jeh.je_batch_id = v_batch_id)
    AND    led.ledger_id > v_curr_ledger_id
    ORDER BY led.ledger_id;

Line: 538

    GL_LEDGERS_PKG.select_row(recinfo);

Line: 592

    SELECT max(abs(nvl(jel.accounted_dr, 0) - nvl(jel.accounted_cr, 0)))
    INTO   l_ledger_approval_amount
    FROM   GL_JE_HEADERS jeh, GL_JE_LINES jel
    WHERE  jeh.je_batch_id = l_je_batch_id
    AND    jeh.ledger_id = l_ledger_id
    AND    jeh.currency_code <> 'STAT'
    AND    jel.je_header_id = jeh.je_header_id;

Line: 651

    SELECT
           name,
           actual_flag,
           default_period_name,
           control_total,
           running_total_dr,
           running_total_cr,
           budgetary_control_status
    INTO   l_je_batch_name,
           l_balance_type,
	   l_period_name,
           l_control_total,
           l_running_total_dr,
           l_running_total_cr,
           l_budgetary_status
    FROM   GL_JE_BATCHES
    WHERE  je_batch_id = l_je_batch_id;

Line: 766

    SELECT 'untaxed journals'
    FROM DUAL
    WHERE EXISTS
          (SELECT 'UNTAXED'
           FROM   GL_JE_HEADERS JEH, GL_LEDGERS LED
           WHERE  JEH.je_batch_id = l_je_batch_id
           AND    JEH.tax_status_code = 'R'
           AND    JEH.currency_code <> 'STAT'
           AND    JEH.je_source = 'Manual'
           AND    LED.ledger_id = JEH.ledger_id
           AND    enable_automatic_tax_flag = 'Y');

Line: 839

    SELECT nvl(max(led.enable_budgetary_control_flag), 'N')
    INTO   l_budgetary_control_flag
    FROM   GL_JE_HEADERS jeh, GL_LEDGERS led
    WHERE  jeh.je_batch_id = l_je_batch_id
    AND    led.ledger_id = jeh.ledger_id
    AND    led.enable_budgetary_control_flag = 'Y';

Line: 913

    UPDATE GL_JE_BATCHES
    SET    approval_status_code = 'V'
    WHERE  je_batch_id = l_je_batch_id;

Line: 942

    SELECT 'non stat journal exists'
    FROM   DUAL
    WHERE  EXISTS
           (SELECT 'X'
            FROM   GL_JE_HEADERS
            WHERE  je_batch_id = l_je_batch_id
            AND    currency_code <> 'STAT');

Line: 999

    UPDATE GL_JE_BATCHES
    SET    approval_status_code = 'A'
    WHERE  je_batch_id = l_je_batch_id;

Line: 1139

    UPDATE GL_JE_BATCHES
    SET    approver_employee_id = l_approver_id
    WHERE  je_batch_id = l_je_batch_id;

Line: 1173

    UPDATE GL_JE_BATCHES
    SET    approval_status_code = 'A'
    WHERE  je_batch_id = l_je_batch_id;

Line: 1215

    UPDATE GL_JE_BATCHES
    SET    approval_status_code = 'J'
    WHERE  je_batch_id = l_je_batch_id;

Line: 1457

    SELECT orig_system_id
    FROM   wf_roles
    WHERE  orig_system = 'PER'
    AND    name = l_role;

Line: 1468

    SELECT original_recipient
    INTO   l_role
    FROM   wf_notifications
    WHERE  notification_id = l_notification_id;

Line: 1760

    UPDATE GL_JE_BATCHES
    SET    approval_status_code = 'R'
    WHERE  je_batch_id = l_je_batch_id;