APPS.FV_AP_CASH_POS_DTL_PKG dependencies on GL_PERIOD_STATUSES

Line 350: FROM gl_period_statuses gps ,gl_ledgers_public_v glpv

346: CURSOR period_detail_cur(p_checkrun_date DATE,
347: p_apps_id NUMBER,
348: p_set_of_books_id NUMBER) IS
349: SELECT gps.period_num,gps.period_year,glpv.currency_CODE
350: FROM gl_period_statuses gps ,gl_ledgers_public_v glpv
351: WHERE Start_date <= p_checkrun_date
352: AND end_date >= p_checkrun_date
353: AND gps.application_id = p_apps_id
354: AND gps.set_of_books_id =p_set_of_books_id