APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_FP_CALC_AMT_TMP1

Line 632: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/

628: IS
629: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub1.chk_upd_rate_based_flag';
630:
631: CURSOR get_res_asg_cur IS
632: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
633: DISTINCT(tmp.target_res_asg_id)
634: FROM pa_fp_calc_amt_tmp1 tmp,
635: pa_resource_assignments ra
636: WHERE ra.resource_assignment_id = tmp.target_res_asg_id

Line 634: FROM pa_fp_calc_amt_tmp1 tmp,

630:
631: CURSOR get_res_asg_cur IS
632: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
633: DISTINCT(tmp.target_res_asg_id)
634: FROM pa_fp_calc_amt_tmp1 tmp,
635: pa_resource_assignments ra
636: WHERE ra.resource_assignment_id = tmp.target_res_asg_id
637: and ra.budget_version_id = p_budget_version_id
638: and ra.rate_based_flag = 'Y'

Line 3019: INSERT INTO PA_FP_CALC_AMT_TMP1 (

3015: WHERE resource_list_id = P_TARGET_RES_LIST_ID
3016: AND resource_class_flag = 'Y'
3017: AND resource_class_code = 'PEOPLE';
3018: */
3019: INSERT INTO PA_FP_CALC_AMT_TMP1 (
3020: RESOURCE_ASSIGNMENT_ID,
3021: BUDGET_VERSION_ID,
3022: PROJECT_ID,
3023: TASK_ID,

Line 3148: INSERT INTO PA_FP_CALC_AMT_TMP1 (

3144: -- hr_utility.trace('inside none etc class rlm id:'||l_target_class_rlm_id);
3145: /* bug 3741059 target_rlm_id col should be populated instead of
3146: resource_list_member_id col in the following insert for the value
3147: l_target_class_rlm_id value. */
3148: INSERT INTO PA_FP_CALC_AMT_TMP1 (
3149: RESOURCE_ASSIGNMENT_ID,
3150: BUDGET_VERSION_ID,
3151: PROJECT_ID,
3152: TASK_ID,

Line 4955: FROM PA_FP_CALC_AMT_TMP1 tmp1,

4951: BEGIN
4952: -- for etc_method_code
4953: SELECT tmp1.etc_method_code
4954: INTO l_etc_method_code
4955: FROM PA_FP_CALC_AMT_TMP1 tmp1,
4956: PA_FP_CALC_AMT_TMP2 tmp2
4957: WHERE tmp1.TARGET_RES_ASG_ID = l_ra_id_tbl_1(kk)
4958: AND tmp2.TARGET_RES_ASG_ID = l_ra_id_tbl_1(kk)
4959: AND tmp1.resource_assignment_id = tmp2.resource_assignment_id

Line 4975: FROM PA_FP_CALC_AMT_TMP1 tmp1,

4971: SELECT tmp2.etc_plan_quantity
4972: ,tmp2.actual_work_qty
4973: INTO l_etc_plan_qty
4974: ,l_act_work_qty
4975: FROM PA_FP_CALC_AMT_TMP1 tmp1,
4976: PA_FP_CALC_AMT_TMP2 tmp2
4977: WHERE tmp1.resource_assignment_id = ((-1) * l_task_id_tab(kk))
4978: AND tmp2.resource_assignment_id = ((-1) * l_task_id_tab(kk))
4979: AND tmp1.resource_assignment_id = tmp2.resource_assignment_id