APPS.IGW_PARTY_MERGE_PUB SQL Statements

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

Line: 17

select *
from   igw_person_degrees
where  person_degree_id = l_person_degree_id;

Line: 24

select *
from  igw_person_degrees
where party_id = l_party_id
and degree_type_code = l_degree_type_code and
degree = l_degree and graduation_date = l_graduation_date;

Line: 65

      update igw_person_degrees
      set    party_id = p_to_fk_id
      where  person_degree_id = p_from_id;

Line: 109

select *
from   igw_person_biosketch
where  person_biosketch_id = l_person_biosketch_id;

Line: 116

select *
from  igw_person_biosketch
where party_id = l_party_id and
biosketch_type = l_biosketch_type and line_description = l_line_description;

Line: 156

      update igw_person_biosketch
      set    party_id = p_to_fk_id
      where  person_biosketch_id = p_from_id;

Line: 199

select *
from   igw_prop_locations
where  prop_location_id = l_prop_locations_id;

Line: 206

select *
from  igw_prop_locations
where proposal_id = l_proposal_id and
party_id = l_party_id;

Line: 246

      update igw_prop_locations
      set    party_id = p_to_fk_id
      where  prop_location_id = p_from_id;

Line: 289

select *
from   igw_prop_persons_tca_v
where  proposal_person_party_id = l_proposal_person_party_id ;

Line: 297

select *
from  igw_prop_persons_tca_v
where proposal_id = l_proposal_id
and person_party_id = l_party_id;

Line: 337

      update igw_prop_persons
      set    person_party_id = p_to_fk_id
      where  proposal_id||person_party_id = p_from_id;

Line: 342

      update igw_prop_person_questions
      set    party_id = p_to_fk_id
      where  proposal_id = from_party_rec.proposal_id
      and    party_id = from_party_rec.person_party_id;

Line: 356

      update igw_prop_person_support
      set    party_id = p_to_fk_id
      where  proposal_id = from_party_rec.proposal_id
      and    party_id = from_party_rec.person_party_id;

Line: 370

      update igw_budget_persons
      set    party_id = p_to_fk_id
      where  proposal_id = from_party_rec.proposal_id
      and    party_id = from_party_rec.person_party_id;

Line: 384

      update igw_budget_personnel_details
      set    party_id = p_to_fk_id
      where  proposal_id = from_party_rec.proposal_id
      and    party_id = from_party_rec.person_party_id;

Line: 433

select *
from   igw_prop_persons_tca_v
where  proposal_person_party_id = l_proposal_person_party_id;

Line: 442

select *
from  igw_prop_persons_tca_v
where org_party_id = l_party_id and
proposal_id = l_proposal_id;

Line: 484

      update igw_prop_persons
      set    org_party_id = p_to_fk_id
      where  proposal_id||person_party_id = p_from_id;

Line: 526

select *
from   igw_prop_person_support
where  prop_person_support_id = l_prop_person_support_id;

Line: 534

select *
from  igw_prop_persons_tca_v
where org_party_id = l_party_id and
proposal_id = l_proposal_id;

Line: 576

      update igw_prop_person_support
      set    location_party_id = p_to_fk_id
      where  prop_person_support_id = p_from_id
      and    location_party_id = p_from_fk_id;

Line: 618

select *
from   igw_prop_person_support
where  prop_person_support_id = l_prop_person_support_id;

Line: 626

select *
from  igw_prop_persons_tca_v
where org_party_id = l_party_id and
proposal_id = l_proposal_id;

Line: 668

      update igw_prop_person_support
      set    pi_party_id = p_to_fk_id
      where  prop_person_support_id = p_from_id
      and    pi_party_id = p_from_fk_id;