APPS.PA_FP_GEN_PUB dependencies on PA_FP_CALC_AMT_TMP1

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

1981: * the target forecast version is time phased.
1982: *
1983: * Before calling this API, the TXN_RESOURCE_ASSIGNMENT_ID column of the
1984: * PA_RES_LIST_MAP_TMP1 table should be populated with resources to be
1985: * processed. Furthermore, the PA_FP_CALC_AMT_TMP1 table should contain
1986: * the resource mapping and ETC source code information for said resources.
1987: *
1988: * An Invalid Argument Exception will be raised if the p_fp_cols_rec
1989: * parameter is NULL or has NULL values for either the project id or the

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

2129:
2130: l_gen_etc_src_code := l_gen_etc_src_code_tab(i);
2131: --dbms_output.put_line('l_gen_etc_src_code = ' || l_gen_etc_src_code);
2132: /* Pick up the source resource assignment attributes. */
2133: SELECT /*+ INDEX(map,PA_FP_CALC_AMT_TMP1_N1)*/
2134: TMP1.TXN_RESOURCE_ASSIGNMENT_ID,
2135: RA.RESOURCE_CLASS_FLAG,
2136: RA.RESOURCE_CLASS_CODE,
2137: RA.RES_TYPE_CODE,

Line 2197: PA_FP_CALC_AMT_TMP1 map

2193: l_org_id_tab,
2194: l_res_rate_based_flag_tab -- Added for IPM ER
2195: FROM PA_RESOURCE_ASSIGNMENTS RA,
2196: PA_RES_LIST_MAP_TMP1 tmp1,
2197: PA_FP_CALC_AMT_TMP1 map
2198: WHERE RA.budget_version_id = l_src_version_id
2199: AND RA.resource_assignment_id = map.resource_assignment_id
2200: AND map.target_res_asg_id = tmp1.txn_resource_assignment_id
2201: AND map.transaction_source_code = l_gen_etc_src_code;