DBA Data[Home] [Help]

APPS.IEX_UWQ_VIEW_PKG dependencies on IEX_SCORE_HISTORIES

Line 565: FROM iex_score_histories a

561: FUNCTION get_score(p_party_id NUMBER, p_cust_account_id NUMBER, p_site_use_id NUMBER) RETURN NUMBER
562: IS
563: CURSOR c_score(x_score_object_id NUMBER, x_score_object_code VARCHAR2) IS
564: SELECT a.score_value
565: FROM iex_score_histories a
566: WHERE a.creation_date =
567: (SELECT MAX(creation_date)
568: FROM iex_Score_histories
569: WHERE score_object_code = x_score_object_code

Line 568: FROM iex_Score_histories

564: SELECT a.score_value
565: FROM iex_score_histories a
566: WHERE a.creation_date =
567: (SELECT MAX(creation_date)
568: FROM iex_Score_histories
569: WHERE score_object_code = x_score_object_code
570: AND score_object_id = x_score_object_id)
571: AND a.score_object_code = x_score_object_code
572: AND a.score_object_id = x_score_object_id;