APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_FUNDS_ALL_VL

Line 253: ozf_funds_all_vl fund

249: CURSOR territory_csr_1 (l_fund_id NUMBER) IS
250: SELECT
251: fund.node_id territory_id
252: FROM
253: ozf_funds_all_vl fund
254: WHERE
255: fund.fund_id = l_fund_id;
256:
257: CURSOR territory_csr (l_fund_id NUMBER) IS

Line 261: ozf_funds_all_vl fund, jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2

257: CURSOR territory_csr (l_fund_id NUMBER) IS
258: SELECT
259: j.terr_id territory_id
260: FROM
261: ozf_funds_all_vl fund, jtf_terr_rsc_all j, jtf_terr_rsc_access_all j2
262: WHERE
263: fund.fund_id = l_fund_id
264: AND j.resource_id = fund.owner
265: -- AND j.primary_contact_flag = 'Y' ;

Line 908: ozf_funds_all_vl

904: transfered_out_amt,
905: node_id, -- (=territory id)
906: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
907: FROM
908: ozf_funds_all_vl
909: WHERE
910: fund_id = l_fund_id;
911:
912: l_fund_rec fund_csr%ROWTYPE;

Line 1617: ozf_funds_all_vl

1613: transfered_out_amt,
1614: node_id, -- (=territory id)
1615: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
1616: FROM
1617: ozf_funds_all_vl
1618: WHERE
1619: fund_id = l_fund_id;
1620:
1621: l_fund_rec fund_csr%ROWTYPE;

Line 2427: ozf_funds_all_vl

2423: transfered_out_amt,
2424: node_id, -- (=territory id)
2425: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
2426: FROM
2427: ozf_funds_all_vl
2428: WHERE
2429: fund_id = l_fund_id;
2430:
2431: l_fund_rec fund_csr%ROWTYPE;

Line 3763: l_status_code OZF_FUNDS_ALL_VL.status_code%TYPE;

3759:
3760: l_fund_id NUMBER;
3761: l_territory_id NUMBER;
3762: l_resource_id NUMBER;
3763: l_status_code OZF_FUNDS_ALL_VL.status_code%TYPE;
3764:
3765:
3766: CURSOR fund_csr(l_fund_id NUMBER) IS
3767: SELECT

Line 3780: ozf_funds_all_vl

3776: transfered_out_amt,
3777: node_id, -- (=territory id)
3778: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
3779: FROM
3780: ozf_funds_all_vl
3781: WHERE
3782: fund_id = l_fund_id;
3783:
3784: l_fund_rec fund_csr%ROWTYPE;

Line 3994: l_status_code OZF_FUNDS_ALL_VL.status_code%TYPE;

3990: l_item_id NUMBER;
3991: l_item_type VARCHAR2(30);
3992: l_fact_id NUMBER;
3993: l_territory_id NUMBER;
3994: l_status_code OZF_FUNDS_ALL_VL.status_code%TYPE;
3995: l_lysp_sales NUMBER;
3996: l_total_lysp_sales NUMBER;
3997: l_product_allocation_id NUMBER;
3998: l_time_allocation_id NUMBER;

Line 4021: ozf_funds_all_vl

4017: transfered_out_amt,
4018: node_id, -- (=territory id)
4019: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
4020: FROM
4021: ozf_funds_all_vl
4022: WHERE
4023: fund_id = l_fund_id;
4024:
4025: l_fund_rec fund_csr%ROWTYPE;

Line 4431: l_status_code OZF_FUNDS_ALL_VL.status_code%TYPE;

4427: l_item_id NUMBER;
4428: l_item_type VARCHAR2(30);
4429: l_fact_id NUMBER;
4430: l_territory_id NUMBER;
4431: l_status_code OZF_FUNDS_ALL_VL.status_code%TYPE;
4432: l_lysp_sales NUMBER;
4433: l_total_lysp_sales NUMBER;
4434: l_product_allocation_id NUMBER;
4435: l_time_allocation_id NUMBER;

Line 4457: ozf_funds_all_vl

4453: transfered_out_amt,
4454: node_id, -- (=territory id)
4455: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
4456: FROM
4457: ozf_funds_all_vl
4458: WHERE
4459: fund_id = l_fund_id;
4460:
4461: l_fund_rec fund_csr%ROWTYPE;

Line 4982: ozf_funds_all_vl

4978: transfered_out_amt,
4979: node_id, -- (=territory id)
4980: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
4981: FROM
4982: ozf_funds_all_vl
4983: WHERE
4984: fund_id = l_fund_id;
4985:
4986: l_fund_rec fund_csr%ROWTYPE;

Line 6091: ozf_funds_all_vl

6087: transfered_out_amt,
6088: node_id, -- (=territory id)
6089: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
6090: FROM
6091: ozf_funds_all_vl
6092: WHERE
6093: fund_id = l_fund_id;
6094:
6095: l_fund_rec fund_csr%ROWTYPE;

Line 7768: ozf_funds_all_vl

7764: transfered_out_amt,
7765: node_id, -- (=territory id)
7766: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
7767: FROM
7768: ozf_funds_all_vl
7769: WHERE
7770: fund_id = l_fund_id;
7771:
7772: l_fund_rec fund_csr%ROWTYPE;

Line 9368: ozf_funds_all_vl

9364: transfered_out_amt,
9365: node_id, -- (=territory id)
9366: product_spread_time_id period_type_id -- (= minor_scale_id i.e. qtrly or monthly)
9367: FROM
9368: ozf_funds_all_vl
9369: WHERE
9370: fund_id = p_fund_id;
9371:
9372: l_fund_rec fund_csr%ROWTYPE;