APPS.PA_FP_GEN_FCST_AMT_PUB dependencies on PA_FP_PLANNING_RES_TMP1

Line 4715: DELETE FROM PA_FP_PLANNING_RES_TMP1;

4711: pa_debug.set_curr_function( p_function => 'MAINTAIN_RES_ASG',
4712: p_debug_mode => p_pa_debug_mode);
4713: END IF;
4714:
4715: DELETE FROM PA_FP_PLANNING_RES_TMP1;
4716: IF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'L' THEN
4717: -- hr_utility.trace('inside lowest task in maintain res asg :');
4718: /* PA_FP_PLANNING_RES_TMP1 will have res asg id column with
4719: > 0 value - actual res asg id from WP or FP budget version

Line 4718: /* PA_FP_PLANNING_RES_TMP1 will have res asg id column with

4714:
4715: DELETE FROM PA_FP_PLANNING_RES_TMP1;
4716: IF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'L' THEN
4717: -- hr_utility.trace('inside lowest task in maintain res asg :');
4718: /* PA_FP_PLANNING_RES_TMP1 will have res asg id column with
4719: > 0 value - actual res asg id from WP or FP budget version
4720: source, all negative res asg values are inserted either for
4721: tasks with etc source as WORK_QUANTITY or the etc is NONE or NULL. */
4722: INSERT INTO PA_FP_PLANNING_RES_TMP1 (

Line 4722: INSERT INTO PA_FP_PLANNING_RES_TMP1 (

4718: /* PA_FP_PLANNING_RES_TMP1 will have res asg id column with
4719: > 0 value - actual res asg id from WP or FP budget version
4720: source, all negative res asg values are inserted either for
4721: tasks with etc source as WORK_QUANTITY or the etc is NONE or NULL. */
4722: INSERT INTO PA_FP_PLANNING_RES_TMP1 (
4723: TASK_ID,
4724: RESOURCE_LIST_MEMBER_ID,
4725: RESOURCE_ASSIGNMENT_ID,
4726: planning_start_date,

Line 4737: INSERT INTO PA_FP_PLANNING_RES_TMP1 (

4733: FROM PA_FP_CALC_AMT_TMP1
4734: GROUP BY mapped_fin_task_id,TARGET_RLM_ID,to_number(NULL));
4735: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'P' THEN
4736: -- hr_utility.trace('inside proj lvl in maintain res asg :');
4737: INSERT INTO PA_FP_PLANNING_RES_TMP1 (
4738: TASK_ID,
4739: RESOURCE_LIST_MEMBER_ID,
4740: RESOURCE_ASSIGNMENT_ID,
4741: planning_start_date,

Line 4753: INSERT INTO PA_FP_PLANNING_RES_TMP1 (

4749: group by 0, TARGET_RLM_ID,
4750: to_number(NULL) );
4751: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'T' THEN
4752: -- hr_utility.trace('inside top task in maintain res asg :');
4753: INSERT INTO PA_FP_PLANNING_RES_TMP1 (
4754: TASK_ID,
4755: RESOURCE_LIST_MEMBER_ID,
4756: RESOURCE_ASSIGNMENT_ID,
4757: planning_start_date,

Line 4768: -- select count(*) into l_count from PA_FP_PLANNING_RES_TMP1;

4764: FROM PA_FP_CALC_AMT_TMP1 group by
4765: mapped_fin_task_id,TARGET_RLM_ID,
4766: to_number(NULL) );
4767: END IF;
4768: -- select count(*) into l_count from PA_FP_PLANNING_RES_TMP1;
4769: -- hr_utility.trace('in maintain res asg plan res tmp1 count :'||l_count);
4770: IF P_PA_DEBUG_MODE = 'Y' THEN
4771: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4772: P_MSG => 'Before calling pa_fp_copy_actuals_pub.create_res_asg',