eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGW_BUDGET_OPERATIONS dependencies on IGW_BUDGET_DETAILS_CAL_AMTS

Line 182: from igw_budget_details_cal_amts

178: end if;
179: BEGIN
180: select apply_rate_flag
181: into l_apply_rate_flag_oh
182: from igw_budget_details_cal_amts
183: where line_item_id = rec_budget_details.line_item_id;
184: EXCEPTION
185: when no_data_found then
186: l_apply_rate_flag_oh := 'Y';

Line 239: delete from igw_budget_details_cal_amts

235: set line_item_cost = l_base_amount
236: , underrecovery_amount = nvl(l_oh_value - l_oh_value_ov,0)
237: where line_item_id = rec_budget_details.line_item_id;
238:
239: delete from igw_budget_details_cal_amts
240: where line_item_id = rec_budget_details.line_item_id;
241:
242: if check_exp_assignment(rec_budget_details.expenditure_type
243: ,rec_budget_details.expenditure_category_flag

Line 444: delete from igw_budget_details_cal_amts

440:
441: END LOOP; --rec_budget_personnel
442:
443:
444: delete from igw_budget_details_cal_amts
445: where line_item_id = rec_budget_details.line_item_id;
446:
447: select sum(nvl(ppc.calculated_cost,0))
448: , sum(nvl(ppc.calculated_cost_sharing,0))

Line 535: from igw_budget_details_cal_amts pc

531: select nvl(sum(calculated_cost_sharing),0)
532: , nvl(sum(calculated_cost),0)
533: into l_cost_share2
534: , l_indirect_cost
535: from igw_budget_details_cal_amts pc
536: where proposal_id = p_proposal_id
537: and version_id = p_version_id
538: and budget_period_id = rec_budget_periods.budget_period_id
539: and pc.rate_class_id = ( select pr.rate_class_id

Line 547: from igw_budget_details_cal_amts pc

543: select nvl(sum(calculated_cost_sharing),0)
544: , nvl(sum(calculated_cost),0)
545: into l_cost_share3
546: , l_direct_cost2
547: from igw_budget_details_cal_amts pc
548: where proposal_id = p_proposal_id
549: and version_id = p_version_id
550: and budget_period_id = rec_budget_periods.budget_period_id
551: and pc.rate_class_id = ( select pr.rate_class_id

Line 679: from igw_budget_details_cal_amts

675:
676:
677: cursor c_budget_detail_amts is
678: select *
679: from igw_budget_details_cal_amts
680: where line_item_id = l_line_item_id;
681:
682:
683: cursor c_budget_personnel is

Line 1086: from igw_budget_details_cal_amts pc

1082: select nvl(sum(calculated_cost_sharing),0)
1083: , nvl(sum(calculated_cost),0)
1084: into l_cost_share2
1085: , l_indirect_cost
1086: from igw_budget_details_cal_amts pc
1087: where proposal_id = p_target_proposal_id
1088: and version_id = l_target_version_id
1089: and budget_period_id = 1
1090: and pc.rate_class_id = ( select pr.rate_class_id

Line 1098: from igw_budget_details_cal_amts pc

1094: select nvl(sum(calculated_cost_sharing),0)
1095: , nvl(sum(calculated_cost),0)
1096: into l_cost_share3
1097: , l_direct_cost2
1098: from igw_budget_details_cal_amts pc
1099: where proposal_id = p_target_proposal_id
1100: and version_id = l_target_version_id
1101: and budget_period_id = 1
1102: and pc.rate_class_id = ( select pr.rate_class_id

Line 1396: from igw_budget_details_cal_amts

1392: end if;
1393: BEGIN
1394: select apply_rate_flag, calculated_cost, calculated_cost_sharing
1395: into l_apply_rate_flag_oh, l_oh_value_ov_usr, l_calculated_cost_share_ov_usr
1396: from igw_budget_details_cal_amts
1397: where line_item_id = rec_budget_details.line_item_id;
1398: EXCEPTION
1399: when no_data_found then
1400: l_apply_rate_flag_oh := 'Y';

Line 1465: delete from igw_budget_details_cal_amts

1461: , underrecovery_amount = nvl(l_oh_value - l_oh_value_ov_usr,0)
1462: where line_item_id = rec_budget_details.line_item_id;
1463: end if;
1464:
1465: delete from igw_budget_details_cal_amts
1466: where line_item_id = rec_budget_details.line_item_id;
1467:
1468: if check_exp_assignment(rec_budget_details.expenditure_type
1469: ,rec_budget_details.expenditure_category_flag

Line 1722: delete from igw_budget_details_cal_amts

1718:
1719: END LOOP; --rec_budget_personnel
1720:
1721:
1722: delete from igw_budget_details_cal_amts
1723: where line_item_id = rec_budget_details.line_item_id;
1724:
1725: select sum(nvl(ppc.calculated_cost,0))
1726: , sum(nvl(ppc.calculated_cost_sharing,0))

Line 1813: from igw_budget_details_cal_amts pc

1809: select nvl(sum(calculated_cost_sharing),0)
1810: , nvl(sum(calculated_cost),0)
1811: into l_cost_share2
1812: , l_indirect_cost
1813: from igw_budget_details_cal_amts pc
1814: where proposal_id = p_proposal_id
1815: and version_id = p_version_id
1816: and budget_period_id = rec_budget_periods.budget_period_id
1817: and pc.rate_class_id = ( select pr.rate_class_id

Line 1825: from igw_budget_details_cal_amts pc

1821: select nvl(sum(calculated_cost_sharing),0)
1822: , nvl(sum(calculated_cost),0)
1823: into l_cost_share3
1824: , l_direct_cost2
1825: from igw_budget_details_cal_amts pc
1826: where proposal_id = p_proposal_id
1827: and version_id = p_version_id
1828: and budget_period_id = rec_budget_periods.budget_period_id
1829: and pc.rate_class_id = ( select pr.rate_class_id