APPS.PA_FP_GEN_FCST_AMT_PUB5 dependencies on PA_RESOURCE_ASSIGNMENTS

Line 7: P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: PROCEDURE GET_ETC_EARNED_VALUE_AMTS (
7: P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
8: P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
9: P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
10: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
11: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,

Line 8: P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: PROCEDURE GET_ETC_EARNED_VALUE_AMTS (
7: P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
8: P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
9: P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
10: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
11: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
12: P_RESOURCE_LIST_MEMBER_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,

Line 192: FROM pa_resource_assignments

188:
189: IF NVL(P_TGT_RES_ASG_ID,-99)>0 THEN
190: SELECT rate_based_flag
191: INTO l_rate_based_flag
192: FROM pa_resource_assignments
193: WHERE resource_assignment_id = p_tgt_res_asg_id;
194: ELSE
195: l_rate_based_flag:='N';
196: END IF;

Line 717: FROM pa_resource_assignments

713:
714: IF NVL(P_TGT_RES_ASG_ID_TAB(main_loop),-99)>0 THEN
715: SELECT rate_based_flag
716: INTO l_rate_based_flag
717: FROM pa_resource_assignments
718: WHERE resource_assignment_id = p_tgt_res_asg_id_tab(main_loop);
719: ELSE
720: l_rate_based_flag:='N';
721: END IF;