DBA Data[Home] [Help]

APPS.PA_FP_CI_IMPLEMENT_PKG dependencies on PA_PROJECTS_ALL

Line 77: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;

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

Line 78: l_projfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;

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

Line 135: FROM pa_projects_all

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