APPS.PA_CLIENT_EXTN_GEN_ASSET_LINES SQL Statements

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

Line: 35

   select project_asset_id
   from   pa_project_asset_assignments ppaa
   where ppaa.task_id = p_task_id
   and   ppaa.project_id = p_project_id
   and   nvl(ppaa.attribute8,'~!@#')  = nvl(p_attribute8,'~!@#')
   and   nvl(ppaa.attribute9,'~!@#')  = nvl(p_attribute9,'~!@#')
   and   nvl(ppaa.attribute10,'~!@#')  = nvl(p_attribute10,'~!@#')
   /* Start Bug fix:2956569 : attribute6,7 Should be used only when the nl_installed flag = Y
   AND  ( (NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'Y'
           AND   nvl(ppaa.attribute6,'~!@#') = nvl(p_attribute6, '~!@#') --crl_inventory
           AND   nvl(ppaa.attribute7,'~!@#') = nvl(p_attribute7, '~!@#') --serial_number
          )
         OR
          NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'N'
        );

Line: 53

select project_asset_id
   from   pa_project_asset_assignments ppaa
   where ppaa.task_id = p_task_id
   and   ppaa.project_id = p_project_id
   AND   nvl(ppaa.attribute6,'~!@#') = nvl(p_attribute6, '~!@#') --crl_inventory
   AND   nvl(ppaa.attribute7,'~!@#') = nvl(p_attribute7, '~!@#') --serial_number
   and   nvl(ppaa.attribute8,'~!@#')  = nvl(p_attribute8,'~!@#')
   and   nvl(ppaa.attribute9,'~!@#')  = nvl(p_attribute9,'~!@#')
   and   nvl(ppaa.attribute10,'~!@#')  = nvl(p_attribute10,'~!@#')
   ;

Line: 65

select project_asset_id
   from   pa_project_asset_assignments ppaa
   where ppaa.task_id = p_task_id
   and   ppaa.project_id = p_project_id
   and   nvl(ppaa.attribute8,'~!@#')  = nvl(p_attribute8,'~!@#')
   and   nvl(ppaa.attribute9,'~!@#')  = nvl(p_attribute9,'~!@#')
   and   nvl(ppaa.attribute10,'~!@#')  = nvl(p_attribute10,'~!@#')
   ;

Line: 80

       SELECT asset_name_id
       FROM ipa_asset_naming_conventions ;

Line: 102

            Select 1 into dummy
            from pa_project_types ppt,
                 pa_tasks pt,
                 pa_tasks pt2,
                 pa_projects_all ppr -- Changed to _ALL as part of MOAC changes
            where p_task_id = pt.task_id and
            p_project_id = pt.project_id and
            pt.project_id = ppr.project_id and
            ppr.template_flag <> 'Y' and
            ppr.project_status_code <> 'CLOSED' and
            ppr.project_type = ppt.project_type and
            ppt.cip_grouping_method_code = 'CIPGCE' and
	    --nvl(ppt.attribute10,'N') = 'Y' and
            ppt.project_type_class_code = 'CAPITAL' and
            pt2.task_id = pt.top_task_id and
            nvl(ppr.attribute10,'Y') ='Y' and
            nvl(pt2.attribute9,'Y') ='Y' and
            ppt.interface_asset_cost_code = 'F';