APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_ACT_BUDGETS

Line 2041: FROM ozf_act_budgets

2037: request_currency,
2038: ARC_ACT_BUDGET_USED_BY,
2039: ACT_BUDGET_USED_BY_ID,
2040: APPROVED_IN_CURRENCY
2041: FROM ozf_act_budgets
2042: WHERE transfer_type = 'REQUEST'
2043: AND act_budget_used_by_id = cv_offer_id
2044: AND budget_source_id = cv_fund_id;
2045:

Line 8273: FROM ozf_act_budgets a

8269: WHERE utilization_id = cv_utilization_id;
8270:
8271: CURSOR csr_source_fund_tot ( cv_offer_id NUMBER ) IS
8272: SELECT SUM(approved_original_amount)
8273: FROM ozf_act_budgets a
8274: WHERE transfer_type = 'REQUEST'
8275: AND status_code = 'APPROVED' --ninarasi : fix for bug # 12611938
8276: AND act_budget_used_by_id = cv_offer_id
8277: AND EXISTS ( SELECT 1

Line 8287: FROM ozf_act_budgets a

8283: CURSOR csr_source_fund(cv_offer_id NUMBER) IS
8284: SELECT budget_source_id
8285: , approved_original_amount
8286: , count(*) over () total_funds
8287: FROM ozf_act_budgets a
8288: WHERE transfer_type = 'REQUEST'
8289: AND status_code = 'APPROVED' --ninarasi : fix for bug # 12611938
8290: AND act_budget_used_by_id = cv_offer_id
8291: AND EXISTS ( SELECT 1

Line 11984: , ozf_act_budgets fund

11980: , amount --7169388
11981: , fund.approved_in_currency --7231613 --//SD MC
11982: FROM ozf_claim_lines_all lines
11983: , ozf_offers offr
11984: , ozf_act_budgets fund
11985: , ozf_sd_request_headers_all_b req
11986: WHERE claim_id = cv_claim_id
11987: AND lines.activity_id = req.request_header_id
11988: AND req.offer_id = offr.qp_list_header_id