APPS.AMS_APPROVAL_PVT dependencies on OZF_ACT_BUDGETS

Line 952: FROM ozf_act_budgets

948: IS
949:
950: CURSOR c_line_amount IS
951: SELECT request_amount
952: FROM ozf_act_budgets
953: WHERE activity_budget_id = p_act_budget_id ;
954:
955:
956: /* New Cursor Definition */

Line 964: FROM ozf_act_budgets a1

960: DECODE(a1.status_code ,'NEW',a1.request_amount,'APPROVED', a1.approved_amount,0),
961: 'TRANSFER' ,
962: DECODE(a1.status_code ,'NEW',a1.src_curr_request_amt,'APPROVED', -a1.approved_original_amount))
963: ,0)) approved_amount
964: FROM ozf_act_budgets a1
965: WHERE DECODE(a1.transfer_type , 'REQUEST', a1.act_budget_used_by_id, 'TRANSFER' , a1.budget_source_id ) = p_activity_id
966: AND DECODE(a1.transfer_type , 'REQUEST', a1.arc_act_budget_used_by, 'TRANSFER' , a1.budget_source_type) = p_activity_type
967: AND a1.transfer_type <> 'UTILIZED'
968: AND status_code = 'APPROVED';

Line 1355: FROM ozf_act_budgets

1351:
1352: CURSOR c_fund_priority IS
1353: SELECT ARC_ACT_BUDGET_USED_BY,
1354: ACT_BUDGET_USED_BY_ID
1355: FROM ozf_act_budgets
1356: WHERE ACTIVITY_BUDGET_ID = p_act_budget_id;
1357: BEGIN
1358: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1359:

Line 2220: FROM ozf_act_budgets

2216: l_error_msg VARCHAR2(4000);
2217:
2218: CURSOR c_check_lines IS
2219: SELECT status_code
2220: FROM ozf_act_budgets
2221: WHERE arc_act_budget_used_by = l_activity_type
2222: AND act_budget_used_by_id = l_activity_id
2223: AND status_code NOT IN ('APPROVED','REJECTED','CANCELLED','PENDING')
2224: AND ROWNUM < 2;

Line 3797: FROM ozf_act_budgets

3793: , request_amount
3794: , request_currency
3795: , object_version_number
3796: , src_curr_request_amt -- Added Bug 3729490
3797: FROM ozf_act_budgets
3798: WHERE activity_budget_id = p_act_budget_id;
3799:
3800: CURSOR justification_text_csr(id_in IN NUMBER) IS
3801: SELECT notes

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

4131: END IF;
4132:
4133: l_budget_currency := get_object_currency(l_budget_type, l_budget_id);
4134:
4135: /* Bug 3729490 Fix -- Don't recompute always. Get from ozf_act_budgets
4136: SRC_CURR_REQUEST_AMT. If that is null for some
4137: reason then convert
4138: */
4139:

Line 4516: from ozf_act_budgets

4512: l_budget_rec Ozf_Actbudgets_Pvt.Act_Budgets_Rec_Type;
4513: /* New cursor Definition */
4514: CURSOR planned_lines_csr(p_id in NUMBER, p_type in VARCHAR2) IS
4515: select activity_budget_id, object_version_number
4516: from ozf_act_budgets
4517: where act_budget_used_by_id = p_id
4518: and arc_act_budget_used_by = p_type
4519: and status_code = 'NEW'
4520: AND transfer_type = 'REQUEST' ;

Line 6325: FROM ozf_act_budgets

6321: l_continue_flag VARCHAR2(30);
6322:
6323: CURSOR lines_due_csr(p_id IN NUMBER, p_type IN VARCHAR2) IS
6324: SELECT activity_budget_id
6325: FROM ozf_act_budgets
6326: WHERE act_budget_used_by_id = p_id
6327: AND arc_act_budget_used_by = p_type
6328: AND status_code = 'PENDING';
6329:

Line 6459: FROM ozf_act_budgets

6455:
6456: CURSOR pending_lines_csr(p_id IN NUMBER, p_type IN VARCHAR2) IS
6457: SELECT activity_budget_id
6458: , object_version_NUMBER
6459: FROM ozf_act_budgets
6460: WHERE act_budget_used_by_id = p_id
6461: AND arc_act_budget_used_by = p_type
6462: AND status_code = 'PENDING';
6463: