APPS.PA_BUDGET_CORE dependencies on PA_FP_CPY_PERIODS_TMP

Line 2222: DELETE FROM pa_fp_cpy_periods_tmp;

2218: into l_project_id
2219: from pa_budget_versions
2220: where budget_version_id = x_src_version_id;
2221:
2222: DELETE FROM pa_fp_cpy_periods_tmp;
2223:
2224: if (nvl(x_shift_days,0) <> 0) then
2225: if ( (x_time_phased_type_code = 'G')
2226: or (x_time_phased_type_code = 'P')) then

Line 2336: INSERT INTO pa_fp_cpy_periods_tmp

2332: return;
2333: end if;
2334: /* Bug 4772773: Populating a temp table with the new shifted period name, start date and end date */
2335: IF (NOT (l_period_info_tbl.EXISTS(x_period_name)) AND x_period_name IS NOT NULL) THEN -- Fix for bug 12760225
2336: INSERT INTO pa_fp_cpy_periods_tmp
2337: (PA_PERIOD_NAME
2338: ,GL_PERIOD_NAME
2339: ,PERIOD_NAME
2340: ,START_DATE

Line 2880: PA_FP_CPY_PERIODS_TMP pptmp

2876: pa_tasks st,
2877: pa_tasks dt,
2878: pa_resource_assignments da,
2879: pa_fp_bl_map_tmp bmt, /* FPB2 */
2880: PA_FP_CPY_PERIODS_TMP pptmp
2881: where l.budget_version_id = x_src_version_id
2882: and l.resource_assignment_id = sa.resource_assignment_id
2883: and decode(x_time_phased_type_code,
2884: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P, pptmp.pa_period_name,

Line 2987: PA_FP_CPY_PERIODS_TMP pptmp

2983: from pa_budget_lines l,
2984: pa_resource_assignments sa,
2985: pa_resource_assignments da,
2986: pa_fp_bl_map_tmp bmt, /* FPB2 */
2987: PA_FP_CPY_PERIODS_TMP pptmp
2988: where l.budget_version_id = x_src_version_id
2989: and l.resource_assignment_id = sa.resource_assignment_id
2990: and decode(x_time_phased_type_code,
2991: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P, pptmp.pa_period_name,