[Home] [Help]
3601: l_org_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
3602: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
3603: l_period_set_name pa_implementations_all.period_set_name%TYPE;
3604: l_act_period_type gl_periods.period_type%TYPE;
3605: l_org_projfunc_currency_code gl_sets_of_books.currency_code%TYPE;
3606: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;
3607: l_request_id pa_budget_versions.request_id%TYPE;
3608: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;
3609: l_fcst_start_date pa_proj_fp_options.fin_plan_start_date%TYPE;
7093: l_project_start_date gl_periods.start_date%TYPE;
7094: l_project_completion_date gl_periods.end_date%TYPE;
7095:
7096: l_number_of_periods NUMBER;
7097: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
7098: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
7099: l_pa_period_type pa_implementations.pa_period_type%TYPE;
7100:
7101: l_plan_start_date gl_periods.start_date%TYPE;
7094: l_project_completion_date gl_periods.end_date%TYPE;
7095:
7096: l_number_of_periods NUMBER;
7097: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
7098: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
7099: l_pa_period_type pa_implementations.pa_period_type%TYPE;
7100:
7101: l_plan_start_date gl_periods.start_date%TYPE;
7102: l_plan_end_date gl_periods.end_date%TYPE;
7223: INTO l_period_set_name
7224: ,l_accounted_period_type
7225: ,l_pa_period_type
7226: FROM pa_implementations a
7227: ,gl_sets_of_books b
7228: WHERE a.set_of_books_id = b.set_of_books_id;
7229:
7230: IF TRUNC(SYSDATE) BETWEEN l_start_date AND l_end_date THEN /*2690087*/
7231: