DBA Data[Home] [Help]

APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_PROJECTS_ALL

Line 948: l_pc_code pa_projects_all.PROJECT_CURRENCY_CODE%TYPE;

944: l_ins_flag VARCHAR2(1);
945:
946: l_unplanned_res_flag PA_RESOURCE_ASSIGNMENTS.UNPLANNED_FLAG%TYPE;
947:
948: l_pc_code pa_projects_all.PROJECT_CURRENCY_CODE%TYPE;
949: l_pfc_code pa_projects_all.PROJFUNC_CURRENCY_CODE%TYPE;
950:
951: l_spread_curve_id PA_RESOURCE_ASSIGNMENTS.SPREAD_CURVE_ID%TYPE;
952: l_multi_bdgt_lines NUMBER;

Line 949: l_pfc_code pa_projects_all.PROJFUNC_CURRENCY_CODE%TYPE;

945:
946: l_unplanned_res_flag PA_RESOURCE_ASSIGNMENTS.UNPLANNED_FLAG%TYPE;
947:
948: l_pc_code pa_projects_all.PROJECT_CURRENCY_CODE%TYPE;
949: l_pfc_code pa_projects_all.PROJFUNC_CURRENCY_CODE%TYPE;
950:
951: l_spread_curve_id PA_RESOURCE_ASSIGNMENTS.SPREAD_CURVE_ID%TYPE;
952: l_multi_bdgt_lines NUMBER;
953:

Line 1013: FROM pa_projects_all

1009:
1010: SELECT project_currency_code,
1011: projfunc_currency_code INTO
1012: l_pc_code, l_pfc_code
1013: FROM pa_projects_all
1014: WHERE project_id = p_project_id;
1015:
1016: IF P_CALLING_CONTEXT = 'FP_GEN_FCST_COPY_ACTUAL' THEN
1017: