APPS.AMS_REFRESHMETRIC_PVT dependencies on AMS_OBJECT_ASSOCIATIONS

Line 361: -- Tables used: ams_object_associations,ams_metric_accruals,ams_act_metrics_all

357: -- dependent objects have any top level metrics, this procedure creates or
358: -- refreshes the association metric for the master object.
359: --
360: -- NOTES
361: -- Tables used: ams_object_associations,ams_metric_accruals,ams_act_metrics_all
362: -- This algorithm is driven on ams_metric_accruals table.
363: -- HISTORY
364: -- 10/04/2000 sveerave Created.
365: -- 08/16/2001 dmvincen Not all cursors were being closed.

Line 393: ams_object_associations objassoc

389: actmet.functional_currency_code,
390: objassoc.object_association_id
391: FROM ams_act_metrics_all actmet,
392: ams_metrics_all_b met,
393: ams_object_associations objassoc
394: WHERE actmet.metric_id = met.metric_id
395: AND objassoc.master_object_type = l_master_obj_type
396: AND objassoc.master_object_id = l_master_obj_id
397: AND actmet.act_metric_used_by_id = objassoc.using_object_id

Line 565: -- Tables used: ams_object_associations,ams_metric_accruals,ams_metrics_all_b,ams_act_metrics_all

561: -- dependent objects have any top level metrics, this procedure creates
562: -- or refreshes the association metric for the master object.
563: --
564: -- NOTES
565: -- Tables used: ams_object_associations,ams_metric_accruals,ams_metrics_all_b,ams_act_metrics_all
566: -- This procedure is called in Refresh_metrics for each distinct combination
567: -- of parent_object_id, parent_object_type
568: -- This method only creates act metric accruals and calls
569: -- refresh_assoc_metrics for creation/update of activity metrics.

Line 585: FROM ams_object_associations

581: l_master_object_id NUMBER) IS
582: SELECT object_association_id,
583: using_object_type child_object_type,
584: using_object_id child_object_id
585: FROM ams_object_associations
586: WHERE master_object_type = l_master_object_type
587: AND master_object_id = l_master_object_id;
588:
589: l_child_obj_rec c_get_child_objects%ROWTYPE;

Line 921: FROM ams_object_associations

917: using_object_id ,
918: TO_NUMBER(DECODE(usage_type,'CREATED',100,'USED_BY',
919: NVL(pct_of_cost_to_charge_used_by,0))) pct_of_cost_to_charge_used_by,
920: cost_frozen_flag
921: FROM ams_object_associations
922: WHERE object_association_id = p_obj_association_id ;
923: CURSOR c_amt_met IS
924: SELECT func_actual_value
925: FROM ams_act_metrics_all

Line 2763: FROM ams_object_associations

2759: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
2760: CURSOR c_obj_det IS
2761: SELECT master_object_type,
2762: master_object_id
2763: FROM ams_object_associations
2764: WHERE object_association_id = p_obj_association_id ;
2765: CURSOR c_act_met IS
2766: SELECT COUNT(1)
2767: FROM ams_act_metrics_all