DBA Data[Home] [Help]

APPS.CST_UNINVOICEDRECEIPTS_PVT dependencies on GL_PERIOD_STATUSES

Line 155: FROM gl_period_statuses gps

151: l_stmt_num := 30;
152: SELECT INV_LE_TIMEZONE_PUB.GET_SERVER_DAY_TIME_FOR_LE (gps.end_date,
153: l_legal_entity)
154: INTO l_end_date
155: FROM gl_period_statuses gps
156: WHERE gps.application_id = l_application_id
157: AND gps.set_of_books_id = l_sob_id
158: AND gps.period_name = NVL(p_period_name,
159: (SELECT gp.period_name