269: LOOP
270: BEGIN
271: select pca.apply_rate_flag
272: into l_apply_rate_flag_oh
273: from igw_budget_personnel_cal_amts pca
274: , igw_budget_personnel_details pbd
275: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
276: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
277: and pca.rate_class_id = ( select pr.rate_class_id
285:
286: BEGIN
287: select pca.apply_rate_flag
288: into l_apply_rate_flag_eb
289: from igw_budget_personnel_cal_amts pca
290: , igw_budget_personnel_details pbd
291: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
292: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
293: and pca.rate_class_id = ( select pr.rate_class_id
409: , underrecovery_amount = nvl(l_oh_value_d - l_oh_value_ov,0)
410: where budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id;
411:
412:
413: delete from igw_budget_personnel_cal_amts
414: where budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id;
415:
416: if check_exp_assignment(rec_budget_details.expenditure_type
417: ,rec_budget_details.expenditure_category_flag
447: select sum(nvl(ppc.calculated_cost,0))
448: , sum(nvl(ppc.calculated_cost_sharing,0))
449: into l_calculated_cost_oh
450: , l_cost_sharing_oh
451: from igw_budget_personnel_cal_amts ppc
452: , igw_budget_personnel_details ppd
453: where ppd.line_item_id = rec_budget_details.line_item_id
454: and ppd.budget_personnel_detail_id = ppc.budget_personnel_detail_id
455: and ppc.rate_class_id = l_rate_class_id_oh
458: select sum(nvl(ppc.calculated_cost,0))
459: , sum(nvl(ppc.calculated_cost_sharing,0))
460: into l_calculated_cost_eb
461: , l_cost_sharing_eb
462: from igw_budget_personnel_cal_amts ppc
463: , igw_budget_personnel_details ppd
464: where ppd.line_item_id = rec_budget_details.line_item_id
465: and ppd.budget_personnel_detail_id = ppc.budget_personnel_detail_id
466: and ppc.rate_class_id = l_rate_class_id_eb
688: l_budget_personnel_detail_id NUMBER(15);
689:
690: cursor c_budget_personnel_amts is
691: select *
692: from igw_budget_personnel_cal_amts
693: where budget_personnel_detail_id = l_budget_personnel_detail_id;
694:
695: cursor c_budget_persons is
696: select *
1506: LOOP
1507: BEGIN
1508: select pca.apply_rate_flag , calculated_cost, calculated_cost_sharing
1509: into l_apply_rate_flag_oh, l_oh_value_ov_usr, l_calculated_cost_share_ov_usr
1510: from igw_budget_personnel_cal_amts pca
1511: , igw_budget_personnel_details pbd
1512: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
1513: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
1514: and pca.rate_class_id = ( select pr.rate_class_id
1522:
1523: BEGIN
1524: select pca.apply_rate_flag , calculated_cost, calculated_cost_sharing
1525: into l_apply_rate_flag_eb, l_eb_value_ov_usr, l_calculated_cost_share_eb_usr
1526: from igw_budget_personnel_cal_amts pca
1527: , igw_budget_personnel_details pbd
1528: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
1529: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
1530: and pca.rate_class_id = ( select pr.rate_class_id
1665: where budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id;
1666: end if;
1667:
1668:
1669: delete from igw_budget_personnel_cal_amts
1670: where budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id;
1671:
1672:
1673: if check_exp_assignment(rec_budget_details.expenditure_type
1725: select sum(nvl(ppc.calculated_cost,0))
1726: , sum(nvl(ppc.calculated_cost_sharing,0))
1727: into l_calculated_cost_oh
1728: , l_cost_sharing_oh
1729: from igw_budget_personnel_cal_amts ppc
1730: , igw_budget_personnel_details ppd
1731: where ppd.line_item_id = rec_budget_details.line_item_id
1732: and ppd.budget_personnel_detail_id = ppc.budget_personnel_detail_id
1733: and ppc.rate_class_id = l_rate_class_id_oh
1736: select sum(nvl(ppc.calculated_cost,0))
1737: , sum(nvl(ppc.calculated_cost_sharing,0))
1738: into l_calculated_cost_eb
1739: , l_cost_sharing_eb
1740: from igw_budget_personnel_cal_amts ppc
1741: , igw_budget_personnel_details ppd
1742: where ppd.line_item_id = rec_budget_details.line_item_id
1743: and ppd.budget_personnel_detail_id = ppc.budget_personnel_detail_id
1744: and ppc.rate_class_id = l_rate_class_id_eb