APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_FUNDS_ALL_VL

Line 272: ozf_funds_all_vl fund

268: CURSOR territory_csr_1 (l_fund_id NUMBER) IS
269: SELECT
270: fund.node_id territory_id
271: FROM
272: ozf_funds_all_vl fund
273: WHERE
274: fund.fund_id = l_fund_id;
275:
276: CURSOR territory_csr (l_fund_id NUMBER) IS

Line 280: ozf_funds_all_vl fund, jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2

276: CURSOR territory_csr (l_fund_id NUMBER) IS
277: SELECT
278: j.terr_id territory_id
279: FROM
280: ozf_funds_all_vl fund, jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2
281: WHERE
282: fund.fund_id = l_fund_id
283: AND j.resource_id = fund.owner
284: -- AND j.primary_contact_flag = 'Y' ;

Line 927: ozf_funds_all_vl

923: transfered_out_amt,
924: node_id, -- (=territory id)
925: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
926: FROM
927: ozf_funds_all_vl
928: WHERE
929: fund_id = l_fund_id;
930:
931: l_fund_rec fund_csr%ROWTYPE;

Line 1638: ozf_funds_all_vl

1634: transfered_out_amt,
1635: node_id, -- (=territory id)
1636: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
1637: FROM
1638: ozf_funds_all_vl
1639: WHERE
1640: fund_id = l_fund_id;
1641:
1642: l_fund_rec fund_csr%ROWTYPE;

Line 2450: ozf_funds_all_vl

2446: transfered_out_amt,
2447: node_id, -- (=territory id)
2448: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
2449: FROM
2450: ozf_funds_all_vl
2451: WHERE
2452: fund_id = l_fund_id;
2453:
2454: l_fund_rec fund_csr%ROWTYPE;

Line 3788: l_status_code OZF_FUNDS_ALL_VL.status_code%TYPE;

3784:
3785: l_fund_id NUMBER;
3786: l_territory_id NUMBER;
3787: l_resource_id NUMBER;
3788: l_status_code OZF_FUNDS_ALL_VL.status_code%TYPE;
3789:
3790:
3791: CURSOR fund_csr(l_fund_id NUMBER) IS
3792: SELECT

Line 3805: ozf_funds_all_vl

3801: transfered_out_amt,
3802: node_id, -- (=territory id)
3803: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
3804: FROM
3805: ozf_funds_all_vl
3806: WHERE
3807: fund_id = l_fund_id;
3808:
3809: l_fund_rec fund_csr%ROWTYPE;

Line 4019: l_status_code OZF_FUNDS_ALL_VL.status_code%TYPE;

4015: l_item_id NUMBER;
4016: l_item_type VARCHAR2(30);
4017: l_fact_id NUMBER;
4018: l_territory_id NUMBER;
4019: l_status_code OZF_FUNDS_ALL_VL.status_code%TYPE;
4020: l_lysp_sales NUMBER;
4021: l_total_lysp_sales NUMBER;
4022: l_product_allocation_id NUMBER;
4023: l_time_allocation_id NUMBER;

Line 4046: ozf_funds_all_vl

4042: transfered_out_amt,
4043: node_id, -- (=territory id)
4044: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
4045: FROM
4046: ozf_funds_all_vl
4047: WHERE
4048: fund_id = l_fund_id;
4049:
4050: l_fund_rec fund_csr%ROWTYPE;

Line 4458: l_status_code OZF_FUNDS_ALL_VL.status_code%TYPE;

4454: l_item_id NUMBER;
4455: l_item_type VARCHAR2(30);
4456: l_fact_id NUMBER;
4457: l_territory_id NUMBER;
4458: l_status_code OZF_FUNDS_ALL_VL.status_code%TYPE;
4459: l_lysp_sales NUMBER;
4460: l_total_lysp_sales NUMBER;
4461: l_product_allocation_id NUMBER;
4462: l_time_allocation_id NUMBER;

Line 4484: ozf_funds_all_vl

4480: transfered_out_amt,
4481: node_id, -- (=territory id)
4482: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
4483: FROM
4484: ozf_funds_all_vl
4485: WHERE
4486: fund_id = l_fund_id;
4487:
4488: l_fund_rec fund_csr%ROWTYPE;

Line 5009: ozf_funds_all_vl

5005: transfered_out_amt,
5006: node_id, -- (=territory id)
5007: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
5008: FROM
5009: ozf_funds_all_vl
5010: WHERE
5011: fund_id = l_fund_id;
5012:
5013: l_fund_rec fund_csr%ROWTYPE;

Line 6120: ozf_funds_all_vl

6116: transfered_out_amt,
6117: node_id, -- (=territory id)
6118: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
6119: FROM
6120: ozf_funds_all_vl
6121: WHERE
6122: fund_id = l_fund_id;
6123:
6124: l_fund_rec fund_csr%ROWTYPE;

Line 7799: ozf_funds_all_vl

7795: transfered_out_amt,
7796: node_id, -- (=territory id)
7797: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
7798: FROM
7799: ozf_funds_all_vl
7800: WHERE
7801: fund_id = l_fund_id;
7802:
7803: l_fund_rec fund_csr%ROWTYPE;

Line 9401: ozf_funds_all_vl

9397: transfered_out_amt,
9398: node_id, -- (=territory id)
9399: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
9400: FROM
9401: ozf_funds_all_vl
9402: WHERE
9403: fund_id = p_fund_id;
9404:
9405: l_fund_rec fund_csr%ROWTYPE;