APPS.IEX_CUST_OVERVIEW_PVT dependencies on IEX_SCORE_HISTORIES

Line 44: FROM iex_score_histories a

40:
41: -- Collections score
42: CURSOR c_collections_score IS
43: SELECT a.score_value
44: FROM iex_score_histories a
45: WHERE a.creation_date =
46: (SELECT MAX(creation_date)
47: FROM iex_Score_histories
48: WHERE score_object_code = 'PARTY'

Line 47: FROM iex_Score_histories

43: SELECT a.score_value
44: FROM iex_score_histories a
45: WHERE a.creation_date =
46: (SELECT MAX(creation_date)
47: FROM iex_Score_histories
48: WHERE score_object_code = 'PARTY'
49: AND score_object_id = p_party_id)
50: AND a.score_object_code = 'PARTY'
51: AND a.score_object_id = p_party_id;

Line 1905: FROM iex_score_histories a

1901:
1902: -- Collections score
1903: CURSOR c_collections_score IS
1904: SELECT a.score_value
1905: FROM iex_score_histories a
1906: WHERE a.creation_date =
1907: (SELECT MAX(creation_date)
1908: FROM iex_Score_histories
1909: WHERE score_object_code = 'PARTY'

Line 1908: FROM iex_Score_histories

1904: SELECT a.score_value
1905: FROM iex_score_histories a
1906: WHERE a.creation_date =
1907: (SELECT MAX(creation_date)
1908: FROM iex_Score_histories
1909: WHERE score_object_code = 'PARTY'
1910: AND score_object_id = p_party_id)
1911: AND a.score_object_code = 'PARTY'
1912: AND a.score_object_id = p_party_id;