APPS.PA_FP_VIEW_PLANS_PUB dependencies on GL_PERIODS

Line 624: from gl_periods gp,

620: -- Bug 8868407:10394217 : Use the period start date depending on the phase to be used
621: -- as the date when 'Current Period' is choosen in periodic view.
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

Line 637: from gl_periods gp,

633: and ppa.project_id = l_project_id
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