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_CAL_AMTS

Line 75: insert into igw_budget_personnel_cal_amts (

71: ,l_apply_rate_flag VARCHAR2
72: ,l_calculated_cost NUMBER
73: ,l_calculated_cost_sharing NUMBER) IS
74: BEGIN
75: insert into igw_budget_personnel_cal_amts (
76: budget_personnel_detail_id
77: ,rate_class_id
78: ,rate_type_id
79: ,apply_rate_flag

Line 680: from igw_budget_personnel_cal_amts pca

676: LOOP
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

Line 695: from igw_budget_personnel_cal_amts pca

691:
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

Line 920: from igw_budget_personnel_cal_amts ppc

916:
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

Line 933: from igw_budget_personnel_cal_amts ppc

929: and ppc.rate_class_id = pdc.rate_class_id
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

Line 1448: delete from igw_budget_personnel_cal_amts

1444: End;
1445:
1446: if l_dummy_based_on is not null then
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

Line 1580: from igw_budget_personnel_cal_amts pca

1576:
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

Line 1595: from igw_budget_personnel_cal_amts pca

1591:
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

Line 1771: from igw_budget_personnel_cal_amts ppc

1767:
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

Line 1784: from igw_budget_personnel_cal_amts ppc

1780: and ppc.rate_class_id = pdc.rate_class_id
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