APPS.IGW_BUDGET_OPERATIONS dependencies on DUAL

Line 35: /* this procedure is obsoleted, duplicated procedure below to recalculate individually */

31: RETURN FALSE;
32: END check_exp_assignment;
33:
34: ------------------------------------------------------------------------------------
35: /* this procedure is obsoleted, duplicated procedure below to recalculate individually */
36:
37: /*
38: PROCEDURE recalculate_budget (p_proposal_id NUMBER
39: ,p_version_id NUMBER

Line 766: ,residual_funds

762: ,total_direct_cost
763: ,total_indirect_cost
764: ,cost_sharing_amount
765: ,underrecovery_amount
766: ,residual_funds
767: ,total_cost_limit
768: ,oh_rate_class_id
769: ,proposal_form_number
770: ,comments

Line 808: ,rec_budgets.residual_funds

804: ,rec_budgets.total_direct_cost
805: ,rec_budgets.total_indirect_cost
806: ,rec_budgets.cost_sharing_amount
807: ,rec_budgets.underrecovery_amount
808: ,rec_budgets.residual_funds
809: ,rec_budgets.total_cost_limit
810: ,rec_budgets.oh_rate_class_id
811: ,rec_budgets.proposal_form_number
812: ,rec_budgets.comments

Line 894: select igw_budget_details_s.currval into l_based_on_line_item from dual;

890: LOOP
891: if l_counter = 1 then
892: l_based_on_line_item := null;
893: elsif l_counter = 2 then
894: select igw_budget_details_s.currval into l_based_on_line_item from dual;
895: end if;
896:
897: IGW_GENERATE_PERIODS.create_budget_detail (
898: p_target_proposal_id

Line 971: select igw_budget_personnel_s.currval into l_dummy_personnel_id from dual;

967:
968: l_budget_personnel_detail_id := rec_budget_personnel.budget_personnel_detail_id;
969: for rec_budget_personnel_amts in c_budget_personnel_amts
970: LOOP
971: select igw_budget_personnel_s.currval into l_dummy_personnel_id from dual;
972: IGW_GENERATE_PERIODS.create_budget_personnel_amts (
973: l_dummy_personnel_id
974: ,rec_budget_personnel_amts.rate_class_id
975: ,rec_budget_personnel_amts.rate_type_id

Line 986: select igw_budget_details_s.currval into l_dummy_line_item_id from dual;

982: l_line_item_id := rec_budget_details.line_item_id;
983: for rec_budget_detail_amts in c_budget_detail_amts
984: LOOP
985:
986: select igw_budget_details_s.currval into l_dummy_line_item_id from dual;
987:
988: IGW_GENERATE_PERIODS.create_budget_detail_amts(p_target_proposal_id
989: ,l_target_version_id
990: ,rec_budget_details.budget_period_id