APPS.POA_CURRENCY_PKG SQL Statements

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

Line: 138

                               p_selected_operating_unit      IN varchar2,
                               p_global_cur_type              IN varchar2
                                                                    DEFAULT 'P'
                               ) return varchar2
 IS
 l_return_value varchar2(1) := '0';

Line: 152

            SELECT 	 CASE WHEN BitAnd(l_value , 7) = 7    THEN 'PS'
                          WHEN BitAnd(l_value , 5) = 5    THEN 'S'
                          WHEN BitAnd(l_value , 3) = 3    THEN 'P'
                     END     INTO  l_global_cur_type
            FROM DUAL;

Line: 188

     if(nvl(p_selected_operating_unit,'ALL') <> 'ALL') then

      if(p_selected_operating_unit <> g_operating_unit or g_operating_unit is null) then
        select currency_code
          into g_functional_currency_code
        from financials_system_params_all fsp,
             gl_sets_of_books gsob
        where fsp.org_id = p_selected_operating_unit
          and fsp.set_of_books_id = gsob.set_of_books_id;

Line: 197

        g_operating_unit := p_selected_operating_unit;

Line: 236

       select distinct currency_code
        into g_common_functional_currency
       from financials_system_params_all fsp,
           gl_sets_of_books gsob
       where fsp.set_of_books_id = gsob.set_of_books_id
       and fsp.org_id in (select organization_id from per_organization_list where security_profile_id = poa_dbi_util_pkg.get_sec_profile);

Line: 247

           SELECT DISTINCT currency_code
                  INTO g_common_functional_currency
           FROM financials_system_params_all fsp,
                gl_sets_of_books gsob
           WHERE fsp.set_of_books_id = gsob.set_of_books_id
           AND  EXISTS (SELECT 1
                              FROM per_organization_list  org_list
                WHERE org_list.security_profile_id = poa_dbi_util_pkg.get_sec_profile
                              AND   org_list.organization_id = fsp.org_id );

Line: 258

           SELECT DISTINCT currency_code
                  INTO g_common_functional_currency
           FROM financials_system_params_all fsp,
                gl_sets_of_books gsob
           WHERE fsp.set_of_books_id = gsob.set_of_books_id
           AND   fsp.org_id = poa_dbi_util_pkg.get_ou_org_id ;