APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_ACT_METRIC_FACTS_ALL

Line 867: OZF_ACT_METRIC_FACTS_ALL

863: previous_fact_id,
864: recommend_total_amount,
865: status_code
866: FROM
867: OZF_ACT_METRIC_FACTS_ALL
868: WHERE
869: activity_metric_fact_id = l_fact_id;
870:
871: l_fact_rec fact_csr%ROWTYPE;

Line 1576: OZF_ACT_METRIC_FACTS_ALL

1572: previous_fact_id,
1573: recommend_total_amount,
1574: status_code
1575: FROM
1576: OZF_ACT_METRIC_FACTS_ALL
1577: WHERE
1578: activity_metric_fact_id = l_fact_id;
1579:
1580: l_fact_rec fact_csr%ROWTYPE;

Line 3494: l_status_code OZF_ACT_METRIC_FACTS_ALL.status_code%TYPE;

3490: l_return_status VARCHAR2(1);
3491:
3492: l_fact_id NUMBER;
3493: l_fund_id NUMBER;
3494: l_status_code OZF_ACT_METRIC_FACTS_ALL.status_code%TYPE;
3495:
3496:
3497: CURSOR fact_csr
3498: (l_fact_id number) IS

Line 3511: OZF_ACT_METRIC_FACTS_ALL

3507: previous_fact_id,
3508: recommend_total_amount,
3509: status_code
3510: FROM
3511: OZF_ACT_METRIC_FACTS_ALL
3512: WHERE
3513: activity_metric_fact_id = l_fact_id;
3514:
3515: l_fact_rec fact_csr%ROWTYPE;

Line 3820: OZF_ACT_METRIC_FACTS_ALL

3816: previous_fact_id,
3817: recommend_total_amount,
3818: status_code
3819: FROM
3820: OZF_ACT_METRIC_FACTS_ALL
3821: WHERE
3822: activity_metric_id = l_allocation_id;
3823:
3824: CURSOR fund_product_spread_csr

Line 4061: OZF_ACT_METRIC_FACTS_ALL

4057: previous_fact_id,
4058: recommend_total_amount,
4059: status_code
4060: FROM
4061: OZF_ACT_METRIC_FACTS_ALL
4062: WHERE
4063: activity_metric_id = l_allocation_id;
4064:
4065:

Line 4497: OZF_ACT_METRIC_FACTS_ALL

4493: previous_fact_id,
4494: recommend_total_amount,
4495: status_code
4496: FROM
4497: OZF_ACT_METRIC_FACTS_ALL
4498: WHERE
4499: activity_metric_id = l_allocation_id;
4500:
4501:

Line 10758: from ozf_act_metric_facts_all a

10754: a.level_depth,
10755: a.node_id,
10756: a.previous_fact_id,
10757: a.activity_metric_fact_id
10758: from ozf_act_metric_facts_all a
10759: where a.arc_act_metric_used_by = 'FUND'
10760: and a.act_metric_used_by_id = l_fund_id
10761: order by a.activity_metric_id desc;
10762:

Line 10774: from ozf_act_metric_facts_all a, OZF_FUNDS_ALL_b FF

10770: a.act_metric_used_by_id,
10771: a.node_id,
10772: a.previous_fact_id,
10773: a.activity_metric_fact_id
10774: from ozf_act_metric_facts_all a, OZF_FUNDS_ALL_b FF
10775: where a.arc_act_metric_used_by = 'FUND'
10776: and a.activity_metric_id = l_allocation_id
10777: --and a.level_depth = l_level_depth
10778: and a.node_id = FF.NODE_ID