APPS.GL_GLRGNL_XMLP_PKG SQL Statements

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

Line: 20

                   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: 85

    			SELECT_REFERENCE := 'jel.reference_1';

Line: 87

    			SELECT_REFERENCE := 'jeh.external_reference';

Line: 89

    			SELECT_REFERENCE := 'jel.reference_4';

Line: 91

   			SELECT_REFERENCE := 'jel.reference_1';

Line: 109

  			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: 120

  			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: 133

  			select_dr := 'nvl(jel.accounted_dr, 0)';

Line: 135

  			select_cr := 'nvl(jel.accounted_cr, 0)';

Line: 466

     select object_type_code
     into   ledger_obj_type
     from   gl_ledgers
     where  ledger_id = tledger_id;

Line: 474

        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: 483

        select start_date, end_date
        into   tstart_date, tend_date
        from gl_period_statuses
        where period_name = tperiod_name
        and ledger_id = single_ledger_id
        and application_id = 101;

Line: 512

  select object_type_code
  into   ledger_obj_type
  from   gl_ledgers
  where  ledger_id = tledger_id;

Line: 520

    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: 529

  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: 694

 Function SELECT_ALL_p return varchar2 is
	Begin
	 return SELECT_ALL;

Line: 715

 Function SELECT_BAL_p return varchar2 is
	Begin
	 return SELECT_BAL;

Line: 735

 Function SELECT_REFERENCE_p return varchar2 is
	Begin
	 return SELECT_REFERENCE;

Line: 743

 Function SELECT_CR_p return varchar2 is
	Begin
	 return SELECT_CR;

Line: 747

 Function SELECT_DR_p return varchar2 is
	Begin
	 return SELECT_DR;