APPS.IGW_BUDGET_OPERATIONS dependencies on IGW_BUDGET_PERSONNEL_DETAILS

Line 87: from igw_budget_personnel_details

83: , percent_charged
84: , cost_sharing_percent
85: , person_id
86: , appointment_type_code
87: from igw_budget_personnel_details
88: where line_item_id = l_line_item_id;
89:
90: l_base_amount NUMBER;
91: l_rate_class_id_oh NUMBER(15);

Line 274: , igw_budget_personnel_details pbd

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
278: from igw_rate_classes pr

Line 290: , igw_budget_personnel_details pbd

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
294: from igw_rate_classes pr

Line 405: update igw_budget_personnel_details

401: if l_apply_rate_flag_eb = 'N' then
402: l_eb_value_ov := 0;
403: end if;
404:
405: update igw_budget_personnel_details
406: set salary_requested = l_inflated_salary_ov
407: , cost_sharing_amount = rec_budget_personnel.cost_sharing_percent/100 *
408: l_inflated_salary_ov
409: , underrecovery_amount = nvl(l_oh_value_d - l_oh_value_ov,0)

Line 452: , igw_budget_personnel_details ppd

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
456: and ppc.rate_type_id = l_rate_type_id_oh;

Line 463: , igw_budget_personnel_details ppd

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
467: and ppc.rate_type_id = l_rate_type_id_eb;

Line 507: from igw_budget_personnel_details ppd

503: , sum(nvl(ppd.underrecovery_amount,0))
504: into l_salary_requested_upd
505: , l_cost_sharing_amount_upd
506: , l_underrecovery_amount_upd
507: from igw_budget_personnel_details ppd
508: where ppd.line_item_id = rec_budget_details.line_item_id;
509:
510: update igw_budget_details pdb
511: set line_item_cost = nvl(l_salary_requested_upd,0)

Line 685: from igw_budget_personnel_details

681:
682:
683: cursor c_budget_personnel is
684: select *
685: from igw_budget_personnel_details
686: where line_item_id = l_line_item_id;
687:
688: l_budget_personnel_detail_id NUMBER(15);
689:

Line 920: insert into igw_budget_personnel_details (

916: l_line_item_id := rec_budget_details.line_item_id;
917: for rec_budget_personnel in c_budget_personnel
918: LOOP
919:
920: insert into igw_budget_personnel_details (
921: budget_personnel_detail_id
922: ,proposal_id
923: ,version_id
924: ,budget_period_id

Line 1261: from igw_budget_personnel_details

1257: , cost_sharing_percent
1258: , person_id
1259: , party_id
1260: , appointment_type_code
1261: from igw_budget_personnel_details
1262: where line_item_id = l_line_item_id
1263: and budget_personnel_detail_id = nvl(p_budget_personnel_detail_id, budget_personnel_detail_id);
1264:
1265: l_pers_cost_sharing_amt NUMBER; -- Bug 2702314

Line 1511: , igw_budget_personnel_details pbd

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
1515: from igw_rate_classes pr

Line 1527: , igw_budget_personnel_details pbd

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
1531: from igw_rate_classes pr

Line 1651: update igw_budget_personnel_details

1647: end if;
1648:
1649: if l_apply_oh_setup_rates = 'Y' then
1650: /* underrecovery is setup calculation amt minus actual calculation */
1651: update igw_budget_personnel_details
1652: set salary_requested = l_inflated_salary_ov
1653: ,cost_sharing_amount = l_pers_cost_sharing_amt -- Bug 2702314
1654: --, cost_sharing_amount = rec_budget_personnel.cost_sharing_percent/100 *
1655: -- l_inflated_salary_ov

Line 1659: update igw_budget_personnel_details

1655: -- l_inflated_salary_ov
1656: , underrecovery_amount = nvl(l_oh_value_d - l_oh_value_ov,0)
1657: where budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id;
1658: else
1659: update igw_budget_personnel_details
1660: set salary_requested = l_inflated_salary_ov
1661: ,cost_sharing_amount = l_pers_cost_sharing_amt -- Bug 2702314
1662: --, cost_sharing_amount = rec_budget_personnel.cost_sharing_percent/100 *
1663: -- l_inflated_salary_ov

Line 1730: , igw_budget_personnel_details ppd

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
1734: and ppc.rate_type_id = l_rate_type_id_oh;

Line 1741: , igw_budget_personnel_details ppd

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
1745: and ppc.rate_type_id = l_rate_type_id_eb;

Line 1785: from igw_budget_personnel_details ppd

1781: , sum(nvl(ppd.underrecovery_amount,0))
1782: into l_salary_requested_upd
1783: , l_cost_sharing_amount_upd
1784: , l_underrecovery_amount_upd
1785: from igw_budget_personnel_details ppd
1786: where ppd.line_item_id = rec_budget_details.line_item_id;
1787:
1788: update igw_budget_details pdb
1789: set line_item_cost = nvl(l_salary_requested_upd,0)