DBA Data[Home] [Help]

APPS.PA_FP_CI_IMPLEMENT_PKG dependencies on PA_PROJECTS_ALL

Line 78: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;

74: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
75: --These tbls will hold the change order amounts in PC and PFC.
76: l_amount_tab_in_pc PA_PLSQL_DATATYPES.NumTabTyp;
77: l_amount_tab_in_pfc PA_PLSQL_DATATYPES.NumTabTyp;
78: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
79: l_projfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
80: l_debug_mode VARCHAR2(30);
81: l_tmp_amount NUMBER;
82: l_rounded_agr_sum NUMBER;

Line 79: l_projfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;

75: --These tbls will hold the change order amounts in PC and PFC.
76: l_amount_tab_in_pc PA_PLSQL_DATATYPES.NumTabTyp;
77: l_amount_tab_in_pfc PA_PLSQL_DATATYPES.NumTabTyp;
78: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
79: l_projfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
80: l_debug_mode VARCHAR2(30);
81: l_tmp_amount NUMBER;
82: l_rounded_agr_sum NUMBER;
83: l_rounded_pc_sum NUMBER;

Line 136: FROM pa_projects_all

132: projfunc_currency_code
133: INTO
134: l_proj_curr_code,
135: l_projfunc_curr_code
136: FROM pa_projects_all
137: WHERE
138: project_id = p_project_id;
139:
140: SELECT budget_version_id,