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.

[Home] [Help]

APPS.IGW_GENERATE_PERIODS dependencies on IGW_BUDGET_PERSONNEL_DETAILS

Line 221: from igw_budget_personnel_details

217: , percent_charged
218: , percent_effort
219: , cost_sharing_percent
220: , underrecovery_amount
221: from igw_budget_personnel_details
222: where line_item_id = l_line_item_id;
223:
224: l_dummy_personnel_id NUMBER;
225: l_salary_requested NUMBER;

Line 681: , igw_budget_personnel_details pbd

677: BEGIN
678: select pca.apply_rate_flag
679: into l_apply_rate_flag_oh
680: from igw_budget_personnel_cal_amts pca
681: , igw_budget_personnel_details pbd
682: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
683: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
684: and pca.rate_class_id = (select pr.rate_class_id
685: from igw_rate_classes pr

Line 696: , igw_budget_personnel_details pbd

692: BEGIN
693: select pca.apply_rate_flag
694: into l_apply_rate_flag_eb
695: from igw_budget_personnel_cal_amts pca
696: , igw_budget_personnel_details pbd
697: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
698: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
699: and pca.rate_class_id = (select pr.rate_class_id
700: from igw_rate_classes pr

Line 843: insert into igw_budget_personnel_details (

839: if l_apply_rate_flag_eb = 'N' then
840: l_eb_value_ov := 0;
841: end if;
842:
843: insert into igw_budget_personnel_details (
844: budget_personnel_detail_id
845: ,proposal_id
846: ,version_id
847: ,budget_period_id

Line 921: , igw_budget_personnel_details ppd

917: update igw_budget_details_cal_amts pdc
918: set pdc.calculated_cost =
919: (select nvl(sum(ppc.calculated_cost),0)
920: from igw_budget_personnel_cal_amts ppc
921: , igw_budget_personnel_details ppd
922: , igw_budget_details pd
923: where pd.line_item_id = ppd.line_item_id
924: and ppd.budget_personnel_detail_id =ppc.budget_personnel_detail_id
925: and pd.proposal_id = p_proposal_id

Line 934: , igw_budget_personnel_details ppd

930: and ppc.rate_type_id = pdc.rate_type_id)
931: , pdc.calculated_cost_sharing =
932: (select nvl(sum(ppc.calculated_cost_sharing),0)
933: from igw_budget_personnel_cal_amts ppc
934: , igw_budget_personnel_details ppd
935: , igw_budget_details pd
936: where pd.line_item_id = ppd.line_item_id
937: and ppd.budget_personnel_detail_id = ppc.budget_personnel_detail_id
938: and pd.proposal_id = p_proposal_id

Line 949: from igw_budget_personnel_details ppd

945:
946: update igw_budget_details pdb
947: set line_item_cost =
948: (select nvl(sum(salary_requested),0)
949: from igw_budget_personnel_details ppd
950: where ppd.line_item_id = l_line_item_seq)
951: , cost_sharing_amount =
952: (select nvl(sum(cost_sharing_amount),0)
953: from igw_budget_personnel_details ppd

Line 953: from igw_budget_personnel_details ppd

949: from igw_budget_personnel_details ppd
950: where ppd.line_item_id = l_line_item_seq)
951: , cost_sharing_amount =
952: (select nvl(sum(cost_sharing_amount),0)
953: from igw_budget_personnel_details ppd
954: where ppd.line_item_id = l_line_item_seq)
955: where pdb.line_item_id = l_line_item_seq;
956:
957:

Line 1136: from igw_budget_personnel_details

1132: , percent_charged
1133: , percent_effort
1134: , cost_sharing_percent
1135: , underrecovery_amount
1136: from igw_budget_personnel_details
1137: where line_item_id = l_line_item_id;
1138:
1139: l_dummy_personnel_id NUMBER;
1140: l_no_of_periods NUMBER(10);

Line 1451: , igw_budget_personnel_details ppd

1447:
1448: delete from igw_budget_personnel_cal_amts
1449: where budget_personnel_detail_id IN (select budget_personnel_detail_id
1450: from igw_budget_details pd
1451: , igw_budget_personnel_details ppd
1452: where pd.line_item_id = ppd.line_item_id
1453: and pd.based_on_line_item = l_dummy_based_on);
1454:
1455: delete from igw_budget_personnel_details

Line 1455: delete from igw_budget_personnel_details

1451: , igw_budget_personnel_details ppd
1452: where pd.line_item_id = ppd.line_item_id
1453: and pd.based_on_line_item = l_dummy_based_on);
1454:
1455: delete from igw_budget_personnel_details
1456: where line_item_id IN (select line_item_id
1457: from igw_budget_details pd
1458: where pd.based_on_line_item = l_dummy_based_on);
1459:

Line 1581: , igw_budget_personnel_details pbd

1577: BEGIN
1578: select pca.apply_rate_flag
1579: into l_apply_rate_flag_oh
1580: from igw_budget_personnel_cal_amts pca
1581: , igw_budget_personnel_details pbd
1582: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
1583: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
1584: and pca.rate_class_id = ( select pr.rate_class_id
1585: from igw_rate_classes pr

Line 1596: , igw_budget_personnel_details pbd

1592: BEGIN
1593: select pca.apply_rate_flag
1594: into l_apply_rate_flag_eb
1595: from igw_budget_personnel_cal_amts pca
1596: , igw_budget_personnel_details pbd
1597: where pbd.budget_personnel_detail_id = rec_budget_personnel.budget_personnel_detail_id
1598: and pca.budget_personnel_detail_id = pbd.budget_personnel_detail_id
1599: and pca.rate_class_id = ( select pr.rate_class_id
1600: from igw_rate_classes pr

Line 1693: insert into igw_budget_personnel_details (

1689: if l_return_status <> 'S' then
1690: raise FND_API.G_EXC_ERROR;
1691: end if;
1692:
1693: insert into igw_budget_personnel_details (
1694: budget_personnel_detail_id
1695: ,proposal_id
1696: ,version_id
1697: ,budget_period_id

Line 1772: , igw_budget_personnel_details ppd

1768: update igw_budget_details_cal_amts pdc
1769: set pdc.calculated_cost =
1770: (select nvl(sum(ppc.calculated_cost),0)
1771: from igw_budget_personnel_cal_amts ppc
1772: , igw_budget_personnel_details ppd
1773: , igw_budget_details pd
1774: where pd.line_item_id = ppd.line_item_id
1775: and ppd.budget_personnel_detail_id =ppc.budget_personnel_detail_id
1776: and pd.proposal_id = p_proposal_id

Line 1785: , igw_budget_personnel_details ppd

1781: and ppc.rate_type_id = pdc.rate_type_id)
1782: , pdc.calculated_cost_sharing =
1783: (select nvl(sum(ppc.calculated_cost_sharing),0)
1784: from igw_budget_personnel_cal_amts ppc
1785: , igw_budget_personnel_details ppd
1786: , igw_budget_details pd
1787: where pd.line_item_id = ppd.line_item_id
1788: and ppd.budget_personnel_detail_id = ppc.budget_personnel_detail_id
1789: and pd.proposal_id = p_proposal_id

Line 1801: from igw_budget_personnel_details ppd

1797:
1798: update igw_budget_details pdb
1799: set line_item_cost =
1800: (select nvl(sum(salary_requested),0)
1801: from igw_budget_personnel_details ppd
1802: where ppd.line_item_id = l_line_item_seq)
1803: , cost_sharing_amount =
1804: (select nvl(sum(cost_sharing_amount),0)
1805: from igw_budget_personnel_details ppd

Line 1805: from igw_budget_personnel_details ppd

1801: from igw_budget_personnel_details ppd
1802: where ppd.line_item_id = l_line_item_seq)
1803: , cost_sharing_amount =
1804: (select nvl(sum(cost_sharing_amount),0)
1805: from igw_budget_personnel_details ppd
1806: where ppd.line_item_id = l_line_item_seq)
1807: where pdb.line_item_id = l_line_item_seq;
1808:
1809: