2465: INTO l_report_date
2466: FROM
2467: pji_time_cal_period_v TIM
2468: , gl_period_statuses glps
2469: , pa_implementations paimp
2470: WHERE 1=1
2471: AND TIM.calendar_id = x_calendar_id
2472: AND paimp.set_of_books_id = glps.set_of_books_id
2473: AND glps.application_id = l_application_id
2478: INTO l_report_date
2479: FROM
2480: pji_time_cal_period_v TIM
2481: , gl_period_statuses glps
2482: , pa_implementations paimp
2483: WHERE 1=1
2484: AND TIM.calendar_id = x_calendar_id
2485: AND paimp.set_of_books_id = glps.set_of_books_id
2486: AND glps.application_id = 275
2491: INTO l_report_date
2492: FROM
2493: pji_time_cal_period_v TIM
2494: , gl_period_statuses glps
2495: , pa_implementations paimp
2496: WHERE 1=1
2497: AND TIM.calendar_id = x_calendar_id
2498: AND paimp.set_of_books_id = glps.set_of_books_id
2499: AND glps.application_id = l_application_id