APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_PROJECTS_ALL

Line 198: FROM pa_projects_all

194: x_projfunc_bil_exchange_rate,
195: x_funding_rate_date_code, x_funding_rate_type,
196: x_funding_rate_date, x_funding_exchange_rate,
197: x_baseline_funding_flag, x_multi_currency_billing_flag
198: FROM pa_projects_all
199: WHERE project_id = p_project_id;
200:
201:
202: IF x_invproc_currency_type = 'PROJECT_CURRENCY' THEN

Line 304: FROM pa_projects_all

300: BEGIN
301:
302: SELECT multi_currency_billing_flag
303: INTO l_multi_currency_billing_flag
304: FROM pa_projects_all
305: WHERE project_id = p_project_id;
306:
307: RETURN l_multi_currency_billing_flag;
308:

Line 446: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

442: +----------------------------------------------------------------------------------------*/
443: FUNCTION get_invoice_processing_cur ( p_project_id IN NUMBER)
444: RETURN VARCHAR2 IS
445:
446: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
447: l_invproc_currency_code pa_projects_all.project_currency_code%TYPE;
448: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
449: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
450:

Line 447: l_invproc_currency_code pa_projects_all.project_currency_code%TYPE;

443: FUNCTION get_invoice_processing_cur ( p_project_id IN NUMBER)
444: RETURN VARCHAR2 IS
445:
446: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
447: l_invproc_currency_code pa_projects_all.project_currency_code%TYPE;
448: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
449: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
450:
451: BEGIN

Line 448: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

444: RETURN VARCHAR2 IS
445:
446: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
447: l_invproc_currency_code pa_projects_all.project_currency_code%TYPE;
448: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
449: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
450:
451: BEGIN
452:

Line 449: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

445:
446: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
447: l_invproc_currency_code pa_projects_all.project_currency_code%TYPE;
448: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
449: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
450:
451: BEGIN
452:
453: SELECT invproc_currency_type, project_currency_code,

Line 457: FROM pa_projects_all

453: SELECT invproc_currency_type, project_currency_code,
454: projfunc_currency_code
455: INTO l_invproc_currency_type, l_project_currency_code,
456: l_projfunc_currency_code
457: FROM pa_projects_all
458: WHERE project_id = p_project_id;
459:
460:
461: IF l_invproc_currency_type = 'PROJECT_CURRENCY' THEN

Line 828: pa_projects_all pr

824: FC.Extended_Precision ep
825: FROM FND_CURRENCIES FC
826: WHERE EXISTS
827: (SELECT null FROM
828: pa_projects_all pr
829: where pr.project_id = p_project_id AND
830: fc.currency_code in (pr.project_currency_code,
831: pr.projfunc_currency_code)
832: UNION

Line 1175: pa_projects_all P

1171:
1172: SELECT 'Y' INTO lv_return_flag FROM DUAL
1173: WHERE EXISTS ( SELECT spf.project_id
1174: FROM pa_summary_project_fundings spf, pa_agreements a,
1175: pa_projects_all P
1176: WHERE spf.agreement_id = a.agreement_id
1177: AND spf.project_id = p.project_id
1178: AND a.org_id <> p.org_id);
1179:

Line 1284: from pa_projects_all

1280:
1281: begin
1282:
1283: select baseline_funding_flag into lv_baseline_flag
1284: from pa_projects_all
1285: where project_id = p_project_id;
1286:
1287: return lv_baseline_flag;
1288:

Line 1329: P_Project_ID IN PA_PROJECTS_ALL.Project_ID%TYPE,

1325: --
1326: -- Inputs: Project_ID and Project_Functional_Currency_Code
1327: ----------------------------------------------------------------------------------
1328: FUNCTION MCB_Flag_Required(
1329: P_Project_ID IN PA_PROJECTS_ALL.Project_ID%TYPE,
1330: P_PFC_Currency_Code IN PA_PROJECTS_ALL.ProjFunc_Currency_Code%TYPE
1331: )
1332: RETURN VARCHAR2
1333: IS

Line 1330: P_PFC_Currency_Code IN PA_PROJECTS_ALL.ProjFunc_Currency_Code%TYPE

1326: -- Inputs: Project_ID and Project_Functional_Currency_Code
1327: ----------------------------------------------------------------------------------
1328: FUNCTION MCB_Flag_Required(
1329: P_Project_ID IN PA_PROJECTS_ALL.Project_ID%TYPE,
1330: P_PFC_Currency_Code IN PA_PROJECTS_ALL.ProjFunc_Currency_Code%TYPE
1331: )
1332: RETURN VARCHAR2
1333: IS
1334: