APPS.PA_FP_GEN_FCST_AMT_PUB4 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_BDGT_COMPLETE_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_BDGT_COMPLETE_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 146: FROM pa_resource_assignments

142:
143: IF NVL(P_TGT_RES_ASG_ID,-99)>0 THEN
144: SELECT rate_based_flag
145: INTO l_rate_based_flag
146: FROM pa_resource_assignments
147: WHERE resource_assignment_id = p_tgt_res_asg_id;
148: ELSE
149: l_rate_based_flag:='N';
150: END IF;

Line 574: FROM pa_resource_assignments

570:
571: IF NVL(P_TGT_RES_ASG_ID_TAB(main_loop),-99)>0 THEN
572: SELECT rate_based_flag
573: INTO l_rate_based_flag
574: FROM pa_resource_assignments
575: WHERE resource_assignment_id = p_tgt_res_asg_id_tab(main_loop);
576: ELSE
577: l_rate_based_flag:='N';
578: END IF;