eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_PROJECTS

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 1219: FROM pa_std_bill_rate_schedules_all br, pa_projects p

1215: BEGIN
1216:
1217: SELECT 'Y' INTO lv_return_flag FROM DUAL
1218: WHERE EXISTS (SELECT p.project_id
1219: FROM pa_std_bill_rate_schedules_all br, pa_projects p
1220: WHERE ( p.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1221: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))
1222: OR ( p.emp_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1223: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1239: FROM pa_std_bill_rate_schedules_all br, pa_projects p,

1235: /* Fix for Performance bug 4939354
1236:
1237: SELECT 'Y' INTO lv_return_flag FROM DUAL
1238: WHERE EXISTS (SELECT p.project_id
1239: FROM pa_std_bill_rate_schedules_all br, pa_projects p,
1240: pa_tasks t
1241: WHERE p.project_id = t.project_id
1242: AND ( ( t.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1243: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1251: FROM pa_projects p, pa_tasks t

1247: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))));
1248: */
1249: SELECT 'Y' INTO lv_return_flag FROM DUAL
1250: WHERE EXISTS (SELECT p.project_id
1251: FROM pa_projects p, pa_tasks t
1252: WHERE p.project_id = t.project_id
1253: AND EXISTS
1254: (select null
1255: FROM pa_std_bill_rate_schedules_all br

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:

Line 1443: FROM pa_projects

1439: BEGIN
1440: lv_return_flag := 'N';
1441:
1442: SELECT projfunc_currency_code into lv_projfunc_currency
1443: FROM pa_projects
1444: WHERE project_id = p_project_id;
1445:
1446: BEGIN
1447: SELECT 'Y' into lv_return_flag from dual

Line 1514: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_projects p

1510:
1511: BEGIN
1512: SELECT 'Y' into lv_return_flag from dual
1513: where exists (select null
1514: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_projects p
1515: where p.project_id = p_project_id
1516: and br.BILL_RATE_SCH_ID in
1517: (nvl(p.job_bill_rate_schedule_id,-99),
1518: nvl(p.emp_bill_rate_schedule_id,-99),