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 1790: FROM iex_score_histories a

1786:
1787: -- Collections score
1788: CURSOR c_collections_score IS
1789: SELECT a.score_value
1790: FROM iex_score_histories a
1791: WHERE a.creation_date =
1792: (SELECT MAX(creation_date)
1793: FROM iex_Score_histories
1794: WHERE score_object_code = 'PARTY'

Line 1793: FROM iex_Score_histories

1789: SELECT a.score_value
1790: FROM iex_score_histories a
1791: WHERE a.creation_date =
1792: (SELECT MAX(creation_date)
1793: FROM iex_Score_histories
1794: WHERE score_object_code = 'PARTY'
1795: AND score_object_id = p_party_id)
1796: AND a.score_object_code = 'PARTY'
1797: AND a.score_object_id = p_party_id;