DBA Data[Home] [Help]

APPS.PA_FP_COPY_FROM_PKG dependencies on GL_SETS_OF_BOOKS

Line 8332: l_period_set_name gl_sets_of_books.period_set_name%TYPE;

8328: l_msg_index_out NUMBER;
8329: l_return_status VARCHAR2(2000);
8330: l_index NUMBER;
8331:
8332: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
8333: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
8334: l_pa_period_type pa_implementations.pa_period_type%TYPE;
8335:
8336: l_number_of_periods NUMBER;

Line 8333: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;

8329: l_return_status VARCHAR2(2000);
8330: l_index NUMBER;
8331:
8332: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
8333: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
8334: l_pa_period_type pa_implementations.pa_period_type%TYPE;
8335:
8336: l_number_of_periods NUMBER;
8337: l_plan_start_date pa_periods.start_date%TYPE;

Line 8460: ,gl_sets_of_books b

8456: -- MOAC changes
8457: -- replaced with pa_implementations_all table.
8458: --,pa_implementations a
8459: ,pa_implementations_all a
8460: ,gl_sets_of_books b
8461: WHERE p.project_id = p_target_project_id
8462: -- MOAC changes
8463: -- removed the nvl around the org_id.
8464: -- AND NVL(p.Org_Id,-99) = NVL(a.Org_Id,-99)