DBA Data[Home] [Help]

APPS.PA_FP_GEN_PUB dependencies on PA_IMPLEMENTATIONS_ALL

Line 1581: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

1577:
1578: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1579: l_org_id pa_projects_all.org_id%TYPE;
1580: l_target_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1581: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1582: l_target_period_name pa_budget_lines.period_name%TYPE;
1583: l_target_start_date pa_budget_lines.start_date%TYPE;
1584: l_target_end_date pa_budget_lines.end_date%TYPE;
1585: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 1586: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

1582: l_target_period_name pa_budget_lines.period_name%TYPE;
1583: l_target_start_date pa_budget_lines.start_date%TYPE;
1584: l_target_end_date pa_budget_lines.end_date%TYPE;
1585: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1586: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1587: l_source_period_name pa_budget_lines.period_name%TYPE;
1588: l_source_start_date pa_budget_lines.start_date%TYPE;
1589: l_source_end_date pa_budget_lines.end_date%TYPE;
1590:

Line 1611: c_set_of_books PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE) IS

1607: pa_period_rec pa_period_csr%ROWTYPE;
1608:
1609: --Cursor used to select the GL period that contains the amts_thru_date and later
1610: CURSOR gl_period_csr(c_amt_thru PA_PERIODS_ALL.END_DATE%TYPE,
1611: c_set_of_books PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE) IS
1612: SELECT period_name, start_date , end_date
1613: FROM gl_period_statuses
1614: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id and
1615: set_of_books_id = c_set_of_books and

Line 1665: pa_implementations_all pia

1661: l_source_bv_id
1662: from pa_resource_assignments ra,
1663: pa_projects_all p,
1664: pa_proj_fp_options po,
1665: pa_implementations_all pia
1666: where ra.resource_assignment_id = p_src_res_asg_id_tab(1) and
1667: ra.project_id = p.project_id and
1668: ra.budget_version_id = po.fin_plan_version_id and
1669: po.fin_plan_option_level_code = 'PLAN_VERSION' and