305: , appointment_type_code
306: into l_calculation_base
307: , l_effective_date
308: , l_appointment_type_code
309: from igw_budget_persons
310: where proposal_id = p_proposal_id
311: and version_id = p_version_id
312: and person_id = rec_budget_personnel.person_id
313: and appointment_type_code = rec_budget_personnel.appointment_type_code;
693: where budget_personnel_detail_id = l_budget_personnel_detail_id;
694:
695: cursor c_budget_persons is
696: select *
697: from igw_budget_persons
698: where proposal_id = p_proposal_id
699: and version_id = l_version_id;
700:
701: cursor c_prop_rates is
1001: l_loop_counter := l_loop_counter + 1;
1002: END LOOP; -- budget periods
1003: for rec_budget_persons in c_budget_persons
1004: LOOP
1005: insert into igw_budget_persons( proposal_id
1006: ,version_id
1007: ,person_id
1008: ,party_id
1009: ,appointment_type_code
1542: , appointment_type_code
1543: into l_calculation_base
1544: , l_effective_date
1545: , l_appointment_type_code
1546: from igw_budget_persons
1547: where proposal_id = p_proposal_id
1548: and version_id = p_version_id
1549: --and person_id = rec_budget_personnel.person_id
1550: and party_id = rec_budget_personnel.party_id