APPS.OZF_OFFER_PVT dependencies on OZF_ACT_BUDGETS

Line 440: FROM ozf_act_budgets

436: p_count NUMBER := 0;
437:
438: CURSOR cur_budget_source_count(list_header_id NUMBER) IS
439: SELECT count(1)
440: FROM ozf_act_budgets
441: where act_budget_used_by_id = list_header_id
442: and arc_act_budget_used_by = 'OFFR'
443: AND transfer_type = 'REQUEST';
444:

Line 1839: FROM ozf_act_budgets

1835: l_act_budgets_rec OZF_Actbudgets_Pvt.act_budgets_rec_type;
1836:
1837: CURSOR cur_get_offer_budget IS
1838: SELECT activity_budget_id,object_version_number
1839: FROM ozf_act_budgets
1840: WHERE act_budget_used_by_id = p_modifier_list_rec.qp_list_header_id
1841: AND arc_act_budget_used_by = 'OFFR';
1842:
1843: l_activity_budget_id NUMBER;

Line 3182: FROM ozf_act_budgets

3178: IS
3179:
3180: CURSOR c_approved_amount(l_id NUMBER) IS
3181: SELECT nvl(sum(approved_amount),0)
3182: FROM ozf_act_budgets
3183: WHERE arc_act_budget_used_by = 'OFFR'
3184: AND act_budget_used_by_id = l_id;
3185:
3186: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Offer';

Line 3324: FROM ozf_act_budgets

3320: ,p_qp_list_header_id IN NUMBER)
3321: IS
3322: CURSOR c_request_amount IS
3323: SELECT NVL(SUM(request_amount), 0)
3324: FROM ozf_act_budgets
3325: WHERE arc_act_budget_used_by = 'OFFR'
3326: AND act_budget_used_by_id = p_qp_list_header_id;
3327:
3328: CURSOR c_committed_amount IS

Line 6259: FROM ozf_act_budgets

6255: WHERE qp_list_header_id = p_qp_list_header_id;
6256:
6257: CURSOR c_approved_amount(l_id NUMBER) IS
6258: SELECT nvl(sum(approved_amount),0)
6259: FROM ozf_act_budgets
6260: WHERE arc_act_budget_used_by = 'OFFR'
6261: AND act_budget_used_by_id = l_id;
6262:
6263: l_status_code varchar2(30);

Line 8346: FROM ozf_act_budgets

8342: SELECT 1
8343: FROM DUAL
8344: WHERE EXISTS(
8345: SELECT 1
8346: FROM ozf_act_budgets
8347: WHERE arc_act_budget_used_by = 'OFFR'
8348: AND act_budget_used_by_id = p_modifier_list_rec.qp_list_header_id);
8349: l_budget_exist NUMBER;
8350:

Line 8763: FROM ozf_act_budgets

8759:
8760: -- bug 3412451 need to update budget line upon offer activation if no approval nor validation invoked
8761: CURSOR c_budget_request(p_qp_list_header_id NUMBER) IS
8762: SELECT activity_budget_id
8763: FROM ozf_act_budgets
8764: WHERE act_budget_used_by_id = p_qp_list_header_id
8765: AND arc_act_budget_used_by = 'OFFR';
8766: -- end comment
8767:

Line 8790: FROM ozf_act_budgets

8786:
8787:
8788: CURSOR c_budget_req_count(p_list_header_id NUMBER) IS
8789: SELECT COUNT(*)
8790: FROM ozf_act_budgets
8791: WHERE arc_act_budget_used_by = 'OFFR'
8792: AND status_code = 'NEW'
8793: AND transfer_type = 'REQUEST'
8794: AND act_budget_used_by_id = p_list_header_id;