DBA Data[Home] [Help]

APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_IMPLEMENTATIONS_ALL

Line 626: pa_implementations_all pia,

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

Line 638: pa_implementations_all pia,

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