APPS.GL_FC_XLATE_PKG SQL Statements

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

Line: 10

       SELECT 1
       FROM DUAL
       WHERE EXISTS
          (SELECT primary_ledger_id
           FROM gl_ledger_relationships
           WHERE target_ledger_name = target_lname);

Line: 24

       SELECT decode(sign(26-lengthb(to_char(ldg_id))-lengthb(tcurr_code)),
                1,substrb(ldg_name,1,
                                   (26-lengthb(ldg_id)-lengthb(tcurr_code)))||
                  ' ','')||to_char(ldg_id)||' ('||
                  decode(sign(27-lengthb(to_char(ldg_id))-lengthb(tcurr_code)),
                         -1,substrb(tcurr_code,1,
                                               (27-lengthb(to_char(ldg_id))))||
                  ')',tcurr_code||')')
       INTO target_lname
       FROM DUAL;

Line: 47

       SELECT 1
       FROM DUAL
       WHERE EXISTS
          (SELECT primary_ledger_id
           FROM gl_ledger_relationships
           WHERE target_ledger_short_name = target_lshort_name);

Line: 61

       SELECT decode(sign(16-lengthb(to_char(ldg_id))-lengthb(tcurr_code)),
                1,substrb(ldg_short_name,1,
                          (16-lengthb(ldg_id)-lengthb(tcurr_code)))||' ','')||
                  to_char(ldg_id)||' ('||
                  decode(sign(17-lengthb(to_char(ldg_id))-lengthb(tcurr_code)),
                    -1,substrb(tcurr_code,1,(17-lengthb(to_char(ldg_id))))||
                  ')',tcurr_code||')')
       INTO target_lshort_name
       FROM DUAL;

Line: 83

    SELECT	target_ledger_name
    FROM	gl_ledger_relationships
    WHERE	target_ledger_id = ldg_id
    AND		target_currency_code = tcurr_code
    AND		application_id = 101
    AND		org_id = -99
    AND		relationship_enabled_flag = 'Y';

Line: 115

    SELECT	target_ledger_short_name
    FROM	gl_ledger_relationships
    WHERE	target_ledger_id = ldg_id
    AND		target_currency_code = tcurr_code
    AND		application_id = 101
    AND		org_id = -99
    AND		relationship_enabled_flag = 'Y';

Line: 146

      select l.ledger_id
      from gl_ledgers l, gl_ledger_set_assignments lsa
      where lsa.ledger_set_id = ldg_id
      and l.ledger_id = lsa.ledger_id
      and l.object_type_code = 'L'
      and l.ledger_category_code in ('PRIMARY','SECONDARY')
      and not exists
         (select 1
          from gl_ledger_relationships lr
          where lr.source_ledger_id = l.ledger_id
          and lr.target_ledger_id = l.ledger_id
          and lr.target_ledger_category_code = 'ALC'
          and lr.relationship_type_code = 'BALANCE'
          and lr.target_currency_code = tcurr_code
          and lr.application_id = 101
          and lr.org_id = -99);

Line: 183

      select l.ledger_id
      from gl_ledgers l, gl_ledger_set_assignments lsa
      where lsa.ledger_set_id = ldg_id
      and l.ledger_id = lsa.ledger_id
      and l.object_type_code = 'L'
      and not exists
         (select 1
          from gl_translation_tracking tt
          where tt.ledger_id = l.ledger_id
          and tt.target_currency = tcurr_code
          and tt.bal_seg_value = bal_seg_val);

Line: 196

      select l.ledger_id
      from gl_ledgers l, gl_ledger_set_assignments lsa
      where lsa.ledger_set_id = ldg_id
      and l.ledger_id = lsa.ledger_id
      and l.object_type_code = 'L'
      and not exists
         (select 1
          from gl_translation_tracking tt
          where tt.ledger_id = l.ledger_id
          and tt.target_currency = tcurr_code);

Line: 240

                      SELECT 1
                      FROM   gl_period_statuses gps
                      WHERE  gps.application_id = 101
                      AND    gps.ledger_id = l_ledger_id
                      AND    EXISTS
                            (SELECT (gp1.period_year*10000+ gp1.period_num)
                      FROM GL_PERIODS gp1
                      WHERE gp1.period_name =  x_period
                      AND   gp1.period_set_name = l_period_set_name
                      AND   gps.effective_period_num <
                            (gp1.period_year*10000+ gp1.period_num))
                      AND ROWNUM = 1;

Line: 259

     SELECT gll.period_set_name,
            gll.accounted_period_type,
            gll.object_type_code
     INTO   l_period_set_name,
            l_period_type,
            l_object_type_code
     FROM gl_ledgers gll
     WHERE ledger_id = x_ledger_id;

Line: 270

        SELECT glsa.ledger_id
        INTO   l_ledger_id
        FROM GL_LEDGER_SET_ASSIGNMENTS glsa,
             GL_LEDGERS l
        WHERE glsa.ledger_set_id = x_ledger_id
        AND   glsa.ledger_id  = l.ledger_id
        AND   l.object_type_Code = 'L'
        AND   ROWNUM = 1;