APPS.PA_FP_COPY_FROM_PKG dependencies on PA_IMPLEMENTATIONS

Line 8307: l_pa_period_type pa_implementations.pa_period_type%TYPE;

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;
8311: l_plan_end_date pa_periods.end_date%TYPE;

Line 8430: -- replaced with pa_implementations_all table.

8426: ,l_accounted_period_type
8427: ,l_pa_period_type
8428: FROM pa_projects_all p
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

Line 8431: --,pa_implementations a

8427: ,l_pa_period_type
8428: FROM pa_projects_all p
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

Line 8432: ,pa_implementations_all a

8428: FROM pa_projects_all p
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.

Line 8507: ,pa_implementations i

8503: ,start_date
8504: INTO l_start_period
8505: ,l_start_period_start_date
8506: FROM gl_period_statuses g
8507: ,pa_implementations i
8508: WHERE g.application_id = pa_period_process_pkg.application_id
8509: AND g.set_of_books_id = i.set_of_books_id
8510: AND g.adjustment_period_flag = 'N'
8511: AND TRUNC(source_profile_info_rec.period1_start_date + p_shift_days) BETWEEN start_date AND end_date;