[Home] [Help]
3207: SELECT GPS.period_name,
3208: P_Awt_Date
3209: INTO gl_period_name,
3210: gl_awt_date
3211: FROM gl_period_statuses GPS,
3212: ap_system_parameters_all ASP
3213: WHERE GPS.application_id = 200
3214: AND GPS.set_of_books_id = ASP.set_of_books_id
3215: AND P_Awt_Date BETWEEN GPS.start_date AND GPS.END_date