APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_ACT_METRIC_FACTS_ALL

Line 886: OZF_ACT_METRIC_FACTS_ALL

882: previous_fact_id,
883: recommend_total_amount,
884: status_code
885: FROM
886: OZF_ACT_METRIC_FACTS_ALL
887: WHERE
888: activity_metric_fact_id = l_fact_id;
889:
890: l_fact_rec fact_csr%ROWTYPE;

Line 1597: OZF_ACT_METRIC_FACTS_ALL

1593: previous_fact_id,
1594: recommend_total_amount,
1595: status_code
1596: FROM
1597: OZF_ACT_METRIC_FACTS_ALL
1598: WHERE
1599: activity_metric_fact_id = l_fact_id;
1600:
1601: l_fact_rec fact_csr%ROWTYPE;

Line 3519: l_status_code OZF_ACT_METRIC_FACTS_ALL.status_code%TYPE;

3515: l_return_status VARCHAR2(1);
3516:
3517: l_fact_id NUMBER;
3518: l_fund_id NUMBER;
3519: l_status_code OZF_ACT_METRIC_FACTS_ALL.status_code%TYPE;
3520:
3521:
3522: CURSOR fact_csr
3523: (l_fact_id number) IS

Line 3536: OZF_ACT_METRIC_FACTS_ALL

3532: previous_fact_id,
3533: recommend_total_amount,
3534: status_code
3535: FROM
3536: OZF_ACT_METRIC_FACTS_ALL
3537: WHERE
3538: activity_metric_fact_id = l_fact_id;
3539:
3540: l_fact_rec fact_csr%ROWTYPE;

Line 3845: OZF_ACT_METRIC_FACTS_ALL

3841: previous_fact_id,
3842: recommend_total_amount,
3843: status_code
3844: FROM
3845: OZF_ACT_METRIC_FACTS_ALL
3846: WHERE
3847: activity_metric_id = l_allocation_id;
3848:
3849: CURSOR fund_product_spread_csr

Line 4086: OZF_ACT_METRIC_FACTS_ALL

4082: previous_fact_id,
4083: recommend_total_amount,
4084: status_code
4085: FROM
4086: OZF_ACT_METRIC_FACTS_ALL
4087: WHERE
4088: activity_metric_id = l_allocation_id;
4089:
4090:

Line 4524: OZF_ACT_METRIC_FACTS_ALL

4520: previous_fact_id,
4521: recommend_total_amount,
4522: status_code
4523: FROM
4524: OZF_ACT_METRIC_FACTS_ALL
4525: WHERE
4526: activity_metric_id = l_allocation_id;
4527:
4528:

Line 10793: from ozf_act_metric_facts_all a

10789: a.level_depth,
10790: a.node_id,
10791: a.previous_fact_id,
10792: a.activity_metric_fact_id
10793: from ozf_act_metric_facts_all a
10794: where a.arc_act_metric_used_by = 'FUND'
10795: and a.act_metric_used_by_id = l_fund_id
10796: order by a.activity_metric_id desc;
10797:

Line 10809: from ozf_act_metric_facts_all a, OZF_FUNDS_ALL_b FF

10805: a.act_metric_used_by_id,
10806: a.node_id,
10807: a.previous_fact_id,
10808: a.activity_metric_fact_id
10809: from ozf_act_metric_facts_all a, OZF_FUNDS_ALL_b FF
10810: where a.arc_act_metric_used_by = 'FUND'
10811: and a.activity_metric_id = l_allocation_id
10812: --and a.level_depth = l_level_depth
10813: and a.node_id = FF.NODE_ID