APPS.OZF_OFFER_PVT dependencies on OZF_ACT_BUDGETS

Line 504: FROM ozf_act_budgets

500: p_count NUMBER := 0;
501:
502: CURSOR cur_budget_source_count(list_header_id NUMBER) IS
503: SELECT count(1)
504: FROM ozf_act_budgets
505: where act_budget_used_by_id = list_header_id
506: and arc_act_budget_used_by = 'OFFR'
507: AND transfer_type = 'REQUEST';
508:

Line 529: FROM ozf_act_budgets

525: p_count NUMBER := 0;
526:
527: CURSOR cur_active_budget_source_count(list_header_id NUMBER) IS
528: SELECT count(1)
529: FROM ozf_act_budgets
530: where act_budget_used_by_id = list_header_id
531: and arc_act_budget_used_by = 'OFFR'
532: AND transfer_type = 'REQUEST'
533: AND status_code NOT IN ('CLOSED', 'REJECTED');

Line 1949: FROM ozf_act_budgets

1945: l_act_budgets_rec OZF_Actbudgets_Pvt.act_budgets_rec_type;
1946:
1947: CURSOR cur_get_offer_budget IS
1948: SELECT activity_budget_id,object_version_number
1949: FROM ozf_act_budgets
1950: WHERE act_budget_used_by_id = p_modifier_list_rec.qp_list_header_id
1951: AND arc_act_budget_used_by = 'OFFR';
1952:
1953: l_activity_budget_id NUMBER;

Line 3347: FROM ozf_act_budgets

3343: IS
3344:
3345: CURSOR c_approved_amount(l_id NUMBER) IS
3346: SELECT nvl(sum(approved_amount),0)
3347: FROM ozf_act_budgets
3348: WHERE arc_act_budget_used_by = 'OFFR'
3349: AND act_budget_used_by_id = l_id;
3350:
3351: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Offer';

Line 3489: FROM ozf_act_budgets

3485: ,p_qp_list_header_id IN NUMBER)
3486: IS
3487: CURSOR c_request_amount IS
3488: SELECT NVL(SUM(request_amount), 0)
3489: FROM ozf_act_budgets
3490: WHERE arc_act_budget_used_by = 'OFFR'
3491: AND act_budget_used_by_id = p_qp_list_header_id;
3492:
3493: CURSOR c_committed_amount IS

Line 6789: FROM ozf_act_budgets

6785: WHERE qp_list_header_id = p_qp_list_header_id;
6786:
6787: CURSOR c_approved_amount(l_id NUMBER) IS
6788: SELECT nvl(sum(approved_amount),0)
6789: FROM ozf_act_budgets
6790: WHERE arc_act_budget_used_by = 'OFFR'
6791: AND act_budget_used_by_id = l_id;
6792:
6793: l_status_code varchar2(30);

Line 8880: FROM ozf_act_budgets

8876: SELECT 1
8877: FROM DUAL
8878: WHERE EXISTS(
8879: SELECT 1
8880: FROM ozf_act_budgets
8881: WHERE arc_act_budget_used_by = 'OFFR'
8882: AND act_budget_used_by_id = p_modifier_list_rec.qp_list_header_id);
8883: l_budget_exist NUMBER;
8884:

Line 9302: FROM ozf_act_budgets

9298:
9299: -- bug 3412451 need to update budget line upon offer activation if no approval nor validation invoked
9300: CURSOR c_budget_request(p_qp_list_header_id NUMBER) IS
9301: SELECT activity_budget_id
9302: FROM ozf_act_budgets
9303: WHERE act_budget_used_by_id = p_qp_list_header_id
9304: AND arc_act_budget_used_by = 'OFFR';
9305: -- end comment
9306:

Line 9329: FROM ozf_act_budgets

9325:
9326:
9327: CURSOR c_budget_req_count(p_list_header_id NUMBER) IS
9328: SELECT COUNT(*)
9329: FROM ozf_act_budgets
9330: WHERE arc_act_budget_used_by = 'OFFR'
9331: AND status_code = 'NEW'
9332: AND transfer_type = 'REQUEST'
9333: AND act_budget_used_by_id = p_list_header_id;