DBA Data[Home] [Help]

APPS.PA_PURGE_UNASGN_FI dependencies on FND_DATE

Line 43: AND item_date <= fnd_date.canonical_to_date(p_txn_to_date) /* Bug#2510609 */

39: CURSOR Cur_forecast_items IS
40: SELECT forecast_item_id ,project_id --Added for bug 5870223
41: FROM pa_forecast_items
42: WHERE forecast_item_type='U'
43: AND item_date <= fnd_date.canonical_to_date(p_txn_to_date) /* Bug#2510609 */
44: ORDER BY project_id; -- Added for bug 5870223
45:
46: Begin
47: arpr_log('p_txn_to_date: '||p_txn_to_date);