622: IF ll_plan_period_type = 'GL' THEN
623: select gp.START_DATE INTO l_start_date
624: from gl_periods gp,
625: gl_sets_of_books gsb,
626: pa_implementations_all pia,
627: pa_projects_all ppa
628: where
629: gp.period_set_name = gsb.period_set_name
630: and gp.period_type = gsb.accounted_period_type
634: and sysdate between gp.START_DATE and gp.END_DATE;
635: elsif ll_plan_period_type = 'PA' THEN
636: select gp.START_DATE INTO l_start_date
637: from gl_periods gp,
638: pa_implementations_all pia,
639: pa_projects_all ppa
640: where
641: gp.period_set_name = pia.period_set_name
642: and gp.period_type = pia.pa_period_type