DBA Data[Home] [Help]

APPS.PA_INVOICE_CURRENCY dependencies on PA_PROJECTS_ALL

Line 251: from pa_projects_all

247: l_PFC_Exchg_Rate_Date_Code, -- FP_M Changes
248: l_projfunc_Exchg_Rate_type,
249: l_projfunc_Exchg_Rate_Date,
250: l_ProjFunc_Attr_For_AR_Flag
251: from pa_projects_all
252: where project_id = P_Project_Id;
253:
254: /*Added the following code for bug9453939*/
255: SELECT NVL(di.retention_invoice_flag,'N')

Line 1017: from PA_PROJECTS_ALL

1013: This procedure has to return PFC */
1014: cursor get_proj_cur
1015: is
1016: select PROJFUNC_CURRENCY_CODE
1017: from PA_PROJECTS_ALL
1018: where PROJECT_ID = P_Project_Id;
1019:
1020: l_proj_curr PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1021:

Line 1020: l_proj_curr PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

1016: select PROJFUNC_CURRENCY_CODE
1017: from PA_PROJECTS_ALL
1018: where PROJECT_ID = P_Project_Id;
1019:
1020: l_proj_curr PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1021:
1022: BEGIN
1023:
1024: open get_proj_cur;

Line 1208: from pa_projects_all

1204: l_PFC_Exchg_Rate_Date_Code,
1205: l_projfunc_Exchg_Rate_type,
1206: l_projfunc_Exchg_Rate_Date,
1207: l_ProjFunc_Attr_For_AR_Flag -- bug 7575486
1208: from pa_projects_all
1209: where project_id = P_Project_Id;
1210:
1211: IF g1_debug_mode = 'Y' THEN
1212: PA_MCB_INVOICE_PKG.log_message('recalculATE: ' || ' Project Currency Code ' || l_project_currency_code);