APPS.AMS_APPROVAL_PVT dependencies on OZF_ACT_BUDGETS

Line 988: FROM ozf_act_budgets

984: IS
985:
986: CURSOR c_line_amount IS
987: SELECT request_amount
988: FROM ozf_act_budgets
989: WHERE activity_budget_id = p_act_budget_id ;
990:
991:
992: /* New Cursor Definition */

Line 1000: FROM ozf_act_budgets a1

996: DECODE(a1.status_code ,'NEW',a1.request_amount,'APPROVED', a1.approved_amount,0),
997: 'TRANSFER' ,
998: DECODE(a1.status_code ,'NEW',a1.src_curr_request_amt,'APPROVED', -a1.approved_original_amount))
999: ,0)) approved_amount
1000: FROM ozf_act_budgets a1
1001: WHERE DECODE(a1.transfer_type , 'REQUEST', a1.act_budget_used_by_id, 'TRANSFER' , a1.budget_source_id ) = p_activity_id
1002: AND DECODE(a1.transfer_type , 'REQUEST', a1.arc_act_budget_used_by, 'TRANSFER' , a1.budget_source_type) = p_activity_type
1003: AND a1.transfer_type <> 'UTILIZED'
1004: AND status_code = 'APPROVED';

Line 1391: FROM ozf_act_budgets

1387:
1388: CURSOR c_fund_priority IS
1389: SELECT ARC_ACT_BUDGET_USED_BY,
1390: ACT_BUDGET_USED_BY_ID
1391: FROM ozf_act_budgets
1392: WHERE ACTIVITY_BUDGET_ID = p_act_budget_id;
1393: BEGIN
1394: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1395:

Line 2256: FROM ozf_act_budgets

2252: l_error_msg VARCHAR2(4000);
2253:
2254: CURSOR c_check_lines IS
2255: SELECT status_code
2256: FROM ozf_act_budgets
2257: WHERE arc_act_budget_used_by = l_activity_type
2258: AND act_budget_used_by_id = l_activity_id
2259: AND status_code NOT IN ('APPROVED','REJECTED','CANCELLED','PENDING')
2260: AND ROWNUM < 2;

Line 3884: FROM ozf_act_budgets

3880: , request_amount
3881: , request_currency
3882: , object_version_number
3883: , src_curr_request_amt -- Added Bug 3729490
3884: FROM ozf_act_budgets
3885: WHERE activity_budget_id = p_act_budget_id;
3886:
3887: CURSOR justification_text_csr(id_in IN NUMBER) IS
3888: SELECT notes

Line 4226: /* Bug 3729490 Fix -- Don't recompute always. Get from ozf_act_budgets

4222: END IF;
4223:
4224: l_budget_currency := get_object_currency(l_budget_type, l_budget_id);
4225:
4226: /* Bug 3729490 Fix -- Don't recompute always. Get from ozf_act_budgets
4227: SRC_CURR_REQUEST_AMT. If that is null for some
4228: reason then convert
4229: */
4230:

Line 4607: from ozf_act_budgets

4603: l_budget_rec Ozf_Actbudgets_Pvt.Act_Budgets_Rec_Type;
4604: /* New cursor Definition */
4605: CURSOR planned_lines_csr(p_id in NUMBER, p_type in VARCHAR2) IS
4606: select activity_budget_id, object_version_number
4607: from ozf_act_budgets
4608: where act_budget_used_by_id = p_id
4609: and arc_act_budget_used_by = p_type
4610: and status_code = 'NEW'
4611: AND transfer_type = 'REQUEST' ;

Line 6416: FROM ozf_act_budgets

6412: l_continue_flag VARCHAR2(30);
6413:
6414: CURSOR lines_due_csr(p_id IN NUMBER, p_type IN VARCHAR2) IS
6415: SELECT activity_budget_id
6416: FROM ozf_act_budgets
6417: WHERE act_budget_used_by_id = p_id
6418: AND arc_act_budget_used_by = p_type
6419: AND status_code = 'PENDING';
6420:

Line 6550: FROM ozf_act_budgets

6546:
6547: CURSOR pending_lines_csr(p_id IN NUMBER, p_type IN VARCHAR2) IS
6548: SELECT activity_budget_id
6549: , object_version_NUMBER
6550: FROM ozf_act_budgets
6551: WHERE act_budget_used_by_id = p_id
6552: AND arc_act_budget_used_by = p_type
6553: AND status_code = 'PENDING';
6554: