[Home] [Help]
3617: l_org_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
3618: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
3619: l_period_set_name pa_implementations_all.period_set_name%TYPE;
3620: l_act_period_type gl_periods.period_type%TYPE;
3621: l_org_projfunc_currency_code gl_sets_of_books.currency_code%TYPE;
3622: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;
3623: l_request_id pa_budget_versions.request_id%TYPE;
3624: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;
3625: l_fcst_start_date pa_proj_fp_options.fin_plan_start_date%TYPE;
7113: l_project_start_date gl_periods.start_date%TYPE;
7114: l_project_completion_date gl_periods.end_date%TYPE;
7115:
7116: l_number_of_periods NUMBER;
7117: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
7118: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
7119: l_pa_period_type pa_implementations.pa_period_type%TYPE;
7120:
7121: l_plan_start_date gl_periods.start_date%TYPE;
7114: l_project_completion_date gl_periods.end_date%TYPE;
7115:
7116: l_number_of_periods NUMBER;
7117: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
7118: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
7119: l_pa_period_type pa_implementations.pa_period_type%TYPE;
7120:
7121: l_plan_start_date gl_periods.start_date%TYPE;
7122: l_plan_end_date gl_periods.end_date%TYPE;
7243: INTO l_period_set_name
7244: ,l_accounted_period_type
7245: ,l_pa_period_type
7246: FROM pa_implementations a
7247: ,gl_sets_of_books b
7248: WHERE a.set_of_books_id = b.set_of_books_id;
7249:
7250: IF TRUNC(SYSDATE) BETWEEN l_start_date AND l_end_date THEN /*2690087*/
7251: