APPS.GL_GLXRBCR_XMLP_PKG SQL Statements

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

Line: 49

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

Line: 72

    SELECT name
    INTO   LEDGER_NAME
    FROM   gl_ledgers
    WHERE  ledger_id = P_LEDGER_ID;

Line: 109

    SELECT_MASTER_BUDGET :=
      'nvl(bm.period_net_dr, 0) - nvl(bm.period_net_cr, 0)';

Line: 111

    SELECT_DETAIL_BUDGET :=
      'nvl(bd.period_net_dr, 0) - nvl(bd.period_net_cr, 0)';

Line: 115

    SELECT_MASTER_BUDGET :=
      'nvl(bm.begin_balance_dr, 0) + nvl(bm.period_net_dr, 0) -
       nvl(bm.begin_balance_cr, 0) - nvl(bm.period_net_cr, 0)';

Line: 118

    SELECT_DETAIL_BUDGET :=
      'nvl(bd.begin_balance_dr, 0) + nvl(bd.period_net_dr, 0) -
       nvl(bd.begin_balance_cr, 0) - nvl(bd.period_net_cr, 0)';

Line: 123

    SELECT_MASTER_BUDGET :=
      'nvl(bm.quarter_to_date_dr, 0) + nvl(bm.period_net_dr, 0) -
       nvl(bm.quarter_to_date_cr, 0) - nvl(bm.period_net_cr, 0)';

Line: 126

    SELECT_DETAIL_BUDGET :=
      'nvl(bd.quarter_to_date_dr, 0) + nvl(bd.period_net_dr, 0) -
       nvl(bd.quarter_to_date_cr, 0) - nvl(bd.period_net_cr, 0)';

Line: 131

    SELECT_MASTER_BUDGET :=
      'nvl(bm.project_to_date_dr, 0) + nvl(bm.period_net_dr, 0) -
       nvl(bm.project_to_date_cr, 0) - nvl(bm.period_net_cr, 0)';

Line: 134

    SELECT_DETAIL_BUDGET :=
      'nvl(bd.project_to_date_dr, 0) + nvl(bd.period_net_dr, 0) -
       nvl(bd.project_to_date_cr, 0) - nvl(bd.period_net_cr, 0)';

Line: 171

 Function SELECT_FLEX_p return varchar2 is
	Begin
	 return SELECT_FLEX;

Line: 179

 Function SELECT_MASTER_BUDGET_p return varchar2 is
	Begin
	 return SELECT_MASTER_BUDGET;

Line: 183

 Function SELECT_DETAIL_BUDGET_p return varchar2 is
	Begin
	 return SELECT_DETAIL_BUDGET;