DBA Data[Home] [Help]

APPS.PA_INVOICE_CURRENCY dependencies on PA_PROJECTS_ALL

Line 236: from pa_projects_all

232: l_PFC_Exchg_Rate_Date_Code, -- FP_M Changes
233: l_projfunc_Exchg_Rate_type,
234: l_projfunc_Exchg_Rate_Date,
235: l_ProjFunc_Attr_For_AR_Flag
236: from pa_projects_all
237: where project_id = P_Project_Id;
238:
239: IF g1_debug_mode = 'Y' THEN
240: PA_MCB_INVOICE_PKG.log_message('recalculATE: ' || ' Project Currency Code ' || l_project_currency_code);

Line 874: from PA_PROJECTS_ALL

870: This procedure has to return PFC */
871: cursor get_proj_cur
872: is
873: select PROJFUNC_CURRENCY_CODE
874: from PA_PROJECTS_ALL
875: where PROJECT_ID = P_Project_Id;
876:
877: l_proj_curr PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
878:

Line 877: l_proj_curr PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

873: select PROJFUNC_CURRENCY_CODE
874: from PA_PROJECTS_ALL
875: where PROJECT_ID = P_Project_Id;
876:
877: l_proj_curr PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
878:
879: BEGIN
880:
881: open get_proj_cur;

Line 1044: from pa_projects_all

1040: INVPROC_CURRENCY_TYPE
1041: into l_func_curr,
1042: l_project_currency_code,
1043: l_invproc_currency_type
1044: from pa_projects_all
1045: where project_id = P_Project_Id;
1046:
1047: IF g1_debug_mode = 'Y' THEN
1048: PA_MCB_INVOICE_PKG.log_message('recalculATE: ' || ' Project Currency Code ' || l_project_currency_code);