APPS.PA_PRODUCT_INSTALL_UTILS SQL Statements

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

Line: 16

    Select 'Y'
    from PA_PRODUCT_FUNCTIONS PF,
         pa_product_installation_v pi
    where PF.object_type = p_object_type
    and PF.object_code = p_object_code
    and PF.product_code=pi.product_short_code
    and pi.installed_flag='Y';

Line: 25

    Select 'N'
    from PA_PRODUCT_FUNCTIONS PF,
         pa_product_installation_v pi
    where PF.object_type = p_object_type
    and PF.object_code = p_object_code
    and PF.product_code=pi.product_short_code
    and pi.installed_flag='N';

Line: 35

     Select SUM(DECODE(nvl(pi.installed_flag,'Y'),'Y',1,0)) YCnt,
            SUM(DECODE(nvl(pi.installed_flag,'N'),'N',1,0)) NCnt
     from PA_PRODUCT_FUNCTIONS PF,
          pa_product_installation_v pi
     where PF.object_type = p_object_type
     and PF.object_code = p_object_code
     and PF.product_code=pi.product_short_code;

Line: 107

    select 'X' from fnd_form_functions
    where function_name=p_object_code;

Line: 111

    select 'X' from pa_product_functions
    where object_type = 'FND_FUNCTION'
    and   object_code = p_object_code;

Line: 116

    select 'X' from ak_regions
    where region_code=p_object_code
    and region_application_id=275;

Line: 121

    select 'X' from pa_product_functions
    where object_type = 'AK_REGION'
    and   object_code = p_object_code;