APPS.GL_GLRJED_XMLP_PKG SQL Statements

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

Line: 149

  SELECT name, chart_of_accounts_id
  INTO   ACCESS_SET_NAME, STRUCT_NUM
  FROM   gl_access_sets
  WHERE  access_set_id = P_ACCESS_SET_ID;

Line: 239

  SELECT_REFERENCE := 'jel.reference_1';

Line: 241

  SELECT_REFERENCE := 'jeh.external_reference';

Line: 243

  SELECT_REFERENCE := 'jel.reference_4';

Line: 245

  SELECT_REFERENCE := 'jel.reference_1';

Line: 260

SELECT_BEGIN_DR := 'sum(nvl(bal.begin_balance_dr,0))';

Line: 261

SELECT_BEGIN_CR := 'sum(nvl(bal.begin_balance_cr,0))';

Line: 262

SELECT_END_DR := 'sum(nvl(bal.begin_balance_dr,0) + nvl(bal.period_net_dr,0))';

Line: 263

SELECT_END_CR := 'sum(nvl(bal.begin_balance_cr,0) + nvl(bal.period_net_cr,0))';

Line: 268

    SELECT_BEGIN_DR := 'sum(nvl(decode(bal.translated_flag, ''R'', bal.begin_balance_dr, bal.begin_balance_dr_beq),0))';

Line: 269

    SELECT_BEGIN_CR := 'sum(nvl(decode(bal.translated_flag, ''R'', bal.begin_balance_cr, bal.begin_balance_cr_beq),0))';

Line: 270

    SELECT_END_DR := 'sum(nvl(decode(bal.translated_flag, ''R'', bal.begin_balance_dr, bal.begin_balance_dr_beq),0)' ||
                      ' + nvl(decode(bal.translated_flag, ''R'', bal.period_net_dr, bal.period_net_dr_beq),0))';

Line: 272

    SELECT_END_CR := 'sum(nvl(decode(bal.translated_flag, ''R'', bal.begin_balance_cr, bal.begin_balance_cr_beq),0)' ||
                      ' + nvl(decode(bal.translated_flag, ''R'', bal.period_net_cr, bal.period_net_cr_beq),0))';

Line: 296

  SELECT_DR :=
    'decode(jeh.currency_code, ''STAT'',' ||
      'decode(nvl(jel.stat_amount,0),' ||
        '0, jel.accounted_dr,' ||
        'decode(sign(nvl(jel.stat_amount,0)),' ||
          '-1, jel.accounted_dr,' ||
          ' 1, (nvl(jel.accounted_dr,0) + ' ||
                   'jel.stat_amount),' ||
          'jel.accounted_dr)),' ||
      'decode(sign(nvl(jel.stat_amount,0)),' ||
        '1, nvl(jel.stat_amount,0), ' ||
        'NULL))';

Line: 309

  SELECT_CR :=
    'decode(jeh.currency_code, ''STAT'',' ||
      'decode(nvl(jel.stat_amount,0),' ||
        '0, jel.accounted_cr,' ||
        'decode(sign(nvl(jel.stat_amount,0)),' ||
          '-1, (nvl(jel.accounted_cr,0) - ' ||
                   'jel.stat_amount),' ||
          ' 1, jel.accounted_cr,' ||
           'jel.accounted_cr)),' ||
      'decode(sign(nvl(jel.stat_amount,0)),' ||
        '-1, (0 - nvl(jel.stat_amount,0)), ' ||
        'NULL))';

Line: 324

  SELECT_DR := 'jel.accounted_dr';

Line: 325

  SELECT_CR := 'jel.accounted_cr';

Line: 329

  SELECT_DR := 'jel.entered_dr';

Line: 330

  SELECT_CR := 'jel.entered_cr';

Line: 424

  select object_type_code
  into   ledger_obj_type
  from   gl_ledgers
  where  ledger_id = tledger_id;

Line: 432

    select l.ledger_id
    into   single_ledger_id
    from   gl_ledger_set_assignments ls, gl_ledgers l
    where  ls.ledger_set_id = tledger_id
    and    l.ledger_id = ls.ledger_id
    and    l.object_type_code = 'L'
    and    rownum = 1;

Line: 441

  select effective_period_num
  into   teffnum
  from   gl_period_statuses
  where  period_name = tperiod_name
  and    ledger_id = single_ledger_id
  and    application_id = 101;

Line: 504

 Function SELECT_ALL_p return varchar2 is
	Begin
	 return SELECT_ALL;

Line: 532

 Function SELECT_REFERENCE_p return varchar2 is
	Begin
	 return SELECT_REFERENCE;

Line: 536

 Function SELECT_CR_p return varchar2 is
	Begin
	 return SELECT_CR;

Line: 540

 Function SELECT_DR_p return varchar2 is
	Begin
	 return SELECT_DR;

Line: 576

 Function SELECT_BEGIN_DR_p return varchar2 is
	Begin
	 return SELECT_BEGIN_DR;

Line: 580

 Function SELECT_BEGIN_CR_p return varchar2 is
	Begin
	 return SELECT_BEGIN_CR;

Line: 584

 Function SELECT_END_DR_p return varchar2 is
	Begin
	 return SELECT_END_DR;

Line: 588

 Function SELECT_END_CR_p return varchar2 is
	Begin
	 return SELECT_END_CR;