DBA Data[Home] [Help]

APPS.AMS_GEN_APPROVAL_PVT dependencies on AMS_ACT_BUDGETS

Line 621: FROM ams_act_budgets

617:
618: CURSOR c_fund_priority IS
619: SELECT ARC_ACT_BUDGET_USED_BY,
620: ACT_BUDGET_USED_BY_ID
621: FROM ams_act_budgets
622: WHERE ACTIVITY_BUDGET_ID = p_act_budget_id;
623: */
624: l_seeded_flag varchar2(1);
625: BEGIN

Line 2992: FROM ams_act_budgets act1

2988: , '' -- desc
2989: , act1.requester_id -- owner
2990: , act1.request_currency -- curr code
2991: , '' --priority desc
2992: FROM ams_act_budgets act1
2993: ,ozf_funds_all_vl fund
2994: WHERE activity_budget_id = p_activity_id
2995: AND act1.act_budget_used_by_id = fund.fund_id;
2996: -- Add Offer Adjustments