DBA Data[Home] [Help]

APPS.PA_FP_WP_GEN_BUDGET_AMT_PUB dependencies on PA_RES_LIST_MAP_TMP1

Line 882: DELETE FROM PA_RES_LIST_MAP_TMP1;

878:
879: /*populating tmp1 with PA_RESOURCE_ASSIGNMENTS*/
880: IF l_fp_cols_rec_source.x_resource_list_id <>
881: l_fp_cols_rec_target.x_resource_list_id THEN
882: DELETE FROM PA_RES_LIST_MAP_TMP1;
883: DELETE from pa_res_list_map_tmp4;
884:
885: -- Bug 3962468: Previously, the code was pulling data for target resource assignments.
886: -- Changed query to get source (l_source_id) resource assignments instead.