APPS.PA_FP_GEN_PUB dependencies on PA_FP_CALC_AMT_TMP1

Line 1998: * processed. Furthermore, the PA_FP_CALC_AMT_TMP1 table should contain

1994: * the target forecast version is time phased.
1995: *
1996: * Before calling this API, the TXN_RESOURCE_ASSIGNMENT_ID column of the
1997: * PA_RES_LIST_MAP_TMP1 table should be populated with resources to be
1998: * processed. Furthermore, the PA_FP_CALC_AMT_TMP1 table should contain
1999: * the resource mapping and ETC source code information for said resources.
2000: *
2001: * An Invalid Argument Exception will be raised if the p_fp_cols_rec
2002: * parameter is NULL or has NULL values for either the project id or the

Line 2146: SELECT /*+ INDEX(map,PA_FP_CALC_AMT_TMP1_N1)*/

2142:
2143: l_gen_etc_src_code := l_gen_etc_src_code_tab(i);
2144: --dbms_output.put_line('l_gen_etc_src_code = ' || l_gen_etc_src_code);
2145: /* Pick up the source resource assignment attributes. */
2146: SELECT /*+ INDEX(map,PA_FP_CALC_AMT_TMP1_N1)*/
2147: TMP1.TXN_RESOURCE_ASSIGNMENT_ID,
2148: RA.RESOURCE_CLASS_FLAG,
2149: RA.RESOURCE_CLASS_CODE,
2150: RA.RES_TYPE_CODE,

Line 2210: PA_FP_CALC_AMT_TMP1 map

2206: l_org_id_tab,
2207: l_res_rate_based_flag_tab -- Added for IPM ER
2208: FROM PA_RESOURCE_ASSIGNMENTS RA,
2209: PA_RES_LIST_MAP_TMP1 tmp1,
2210: PA_FP_CALC_AMT_TMP1 map
2211: WHERE RA.budget_version_id = l_src_version_id
2212: AND RA.resource_assignment_id = map.resource_assignment_id
2213: AND map.target_res_asg_id = tmp1.txn_resource_assignment_id
2214: AND map.transaction_source_code = l_gen_etc_src_code;