APPS.IEX_TRX_VIEW_PKG dependencies on IEX_SCORE_HISTORIES

Line 98: FROM iex_score_histories a

94: FUNCTION get_score(p_payment_schedule_id NUMBER) RETURN NUMBER
95: IS
96: CURSOR c_score IS
97: SELECT a.score_value
98: FROM iex_score_histories a
99: WHERE a.creation_date =
100: (SELECT MAX(creation_date)
101: FROM iex_Score_histories
102: WHERE score_object_code = 'IEX_INVOICES'

Line 101: FROM iex_Score_histories

97: SELECT a.score_value
98: FROM iex_score_histories a
99: WHERE a.creation_date =
100: (SELECT MAX(creation_date)
101: FROM iex_Score_histories
102: WHERE score_object_code = 'IEX_INVOICES'
103: AND score_object_id = p_payment_schedule_id)
104: AND a.score_object_code = 'IEX_INVOICES'
105: AND a.score_object_id = p_payment_schedule_id;

Line 227: FROM iex_score_histories a

223: AND str.status_code IN ('OPEN', 'ONHOLD');
224:
225: CURSOR c_score(p_payment_schedule_id NUMBER) IS
226: SELECT a.score_value
227: FROM iex_score_histories a
228: WHERE a.creation_date =
229: (SELECT MAX(creation_date)
230: FROM iex_Score_histories
231: WHERE score_object_code = 'IEX_INVOICES'

Line 230: FROM iex_Score_histories

226: SELECT a.score_value
227: FROM iex_score_histories a
228: WHERE a.creation_date =
229: (SELECT MAX(creation_date)
230: FROM iex_Score_histories
231: WHERE score_object_code = 'IEX_INVOICES'
232: AND score_object_id = p_payment_schedule_id)
233: AND a.score_object_code = 'IEX_INVOICES'
234: AND a.score_object_id = p_payment_schedule_id;