APPS.PA_FORECAST_REVENUE SQL Statements

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

Line: 108

  /* Selecting all the necessary inputs for this api */

   SELECT  org_id
   INTO    l_org_id
   FROM    pa_projects_all
   WHERE   project_id = p_project_id;

Line: 115

   SELECT  default_assign_exp_type
   INTO    l_exp_type
   FROM    pa_forecasting_options_all
   WHERE   org_id = l_org_id; /*Bug 5368295*/

Line: 121

     SELECT NVL(resource_org_id,-99),resource_organization_id
     INTO   l_exp_res_org_id,l_exp_orgz_res_id
     FROM pa_resources_denorm
     WHERE person_id    = p_person_id
     AND  ( p_item_date BETWEEN TRUNC(resource_effective_start_date) AND
               NVL(TRUNC(resource_effective_end_date),p_item_date));