DBA Data[Home] [Help]

APPS.IEX_UWQ_VIEW_PKG dependencies on IEX_SCORE_HISTORIES

Line 536: FROM iex_score_histories a

532: FUNCTION get_score(p_party_id NUMBER, p_cust_account_id NUMBER, p_site_use_id NUMBER) RETURN NUMBER
533: IS
534: CURSOR c_score(x_score_object_id NUMBER, x_score_object_code VARCHAR2) IS
535: SELECT a.score_value
536: FROM iex_score_histories a
537: WHERE a.creation_date =
538: (SELECT MAX(creation_date)
539: FROM iex_Score_histories
540: WHERE score_object_code = x_score_object_code

Line 539: FROM iex_Score_histories

535: SELECT a.score_value
536: FROM iex_score_histories a
537: WHERE a.creation_date =
538: (SELECT MAX(creation_date)
539: FROM iex_Score_histories
540: WHERE score_object_code = x_score_object_code
541: AND score_object_id = x_score_object_id)
542: AND a.score_object_code = x_score_object_code
543: AND a.score_object_id = x_score_object_id;