APPS.PA_PRC_PROJECT_PUB SQL Statements

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

Line: 28

      select 1
      from sys.dual
      where exists (select prc_assignment_id
      from pa_mc_exp_items_all
         where prc_assignment_id = x_assignment_id);

Line: 37

      select 1
      from sys.dual
      where exists (select prc_assignment_id
      from pa_mc_cost_dist_lines_all
         where prc_assignment_id = x_assignment_id);

Line: 46

      select 1
      from sys.dual
      where exists (select prc_assignment_id
      from pa_mc_cust_rdl_all
         where prc_assignment_id = x_assignment_id);

Line: 55

      select 1
      from sys.dual
      where exists (select prc_assignment_id
      from pa_mc_cust_event_rdl_all
         where prc_assignment_id = x_assignment_id);

Line: 64

      select 1
      from sys.dual
      where exists (select prc_assignment_id
      from pa_mc_events
         where prc_assignment_id = x_assignment_id);

Line: 73

      select 1
      from sys.dual
      where exists (select prc_assignment_id
      from pa_mc_budget_lines
         where prc_assignment_id = x_assignment_id);

Line: 82

      select 1
      from sys.dual
      where exists (select prc_assignment_id
      from pa_mc_commitment_txns
         where prc_assignment_id = x_assignment_id);