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 3042: INSERT INTO PA_FP_CALC_AMT_TMP1 (

3038: WHERE resource_list_id = P_TARGET_RES_LIST_ID
3039: AND resource_class_flag = 'Y'
3040: AND resource_class_code = 'PEOPLE';
3041: */
3042: INSERT INTO PA_FP_CALC_AMT_TMP1 (
3043: RESOURCE_ASSIGNMENT_ID,
3044: BUDGET_VERSION_ID,
3045: PROJECT_ID,
3046: TASK_ID,

Line 3171: INSERT INTO PA_FP_CALC_AMT_TMP1 (

3167: -- hr_utility.trace('inside none etc class rlm id:'||l_target_class_rlm_id);
3168: /* bug 3741059 target_rlm_id col should be populated instead of
3169: resource_list_member_id col in the following insert for the value
3170: l_target_class_rlm_id value. */
3171: INSERT INTO PA_FP_CALC_AMT_TMP1 (
3172: RESOURCE_ASSIGNMENT_ID,
3173: BUDGET_VERSION_ID,
3174: PROJECT_ID,
3175: TASK_ID,

Line 4980: FROM PA_FP_CALC_AMT_TMP1 tmp1,

4976: BEGIN
4977: -- for etc_method_code
4978: SELECT tmp1.etc_method_code
4979: INTO l_etc_method_code
4980: FROM PA_FP_CALC_AMT_TMP1 tmp1,
4981: PA_FP_CALC_AMT_TMP2 tmp2
4982: WHERE tmp1.TARGET_RES_ASG_ID = l_ra_id_tbl_1(kk)
4983: AND tmp2.TARGET_RES_ASG_ID = l_ra_id_tbl_1(kk)
4984: AND tmp1.resource_assignment_id = tmp2.resource_assignment_id

Line 5000: FROM PA_FP_CALC_AMT_TMP1 tmp1,

4996: SELECT tmp2.etc_plan_quantity
4997: ,tmp2.actual_work_qty
4998: INTO l_etc_plan_qty
4999: ,l_act_work_qty
5000: FROM PA_FP_CALC_AMT_TMP1 tmp1,
5001: PA_FP_CALC_AMT_TMP2 tmp2
5002: WHERE tmp1.resource_assignment_id = ((-1) * l_task_id_tab(kk))
5003: AND tmp2.resource_assignment_id = ((-1) * l_task_id_tab(kk))
5004: AND tmp1.resource_assignment_id = tmp2.resource_assignment_id