APPS.PA_FP_COPY_FROM_PKG dependencies on GL_SETS_OF_BOOKS

Line 8305: l_period_set_name gl_sets_of_books.period_set_name%TYPE;

8301: l_msg_index_out NUMBER;
8302: l_return_status VARCHAR2(2000);
8303: l_index NUMBER;
8304:
8305: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
8306: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
8307: l_pa_period_type pa_implementations.pa_period_type%TYPE;
8308:
8309: l_number_of_periods NUMBER;

Line 8306: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;

8302: l_return_status VARCHAR2(2000);
8303: l_index NUMBER;
8304:
8305: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
8306: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
8307: l_pa_period_type pa_implementations.pa_period_type%TYPE;
8308:
8309: l_number_of_periods NUMBER;
8310: l_plan_start_date pa_periods.start_date%TYPE;

Line 8433: ,gl_sets_of_books b

8429: -- MOAC changes
8430: -- replaced with pa_implementations_all table.
8431: --,pa_implementations a
8432: ,pa_implementations_all a
8433: ,gl_sets_of_books b
8434: WHERE p.project_id = p_target_project_id
8435: -- MOAC changes
8436: -- removed the nvl around the org_id.
8437: -- AND NVL(p.Org_Id,-99) = NVL(a.Org_Id,-99)