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 835: pa_projects_all pr

831: FC.Extended_Precision ep
832: FROM FND_CURRENCIES FC
833: WHERE EXISTS
834: (SELECT null FROM
835: pa_projects_all pr
836: where pr.project_id = p_project_id AND
837: fc.currency_code in (pr.project_currency_code,
838: pr.projfunc_currency_code)
839: UNION

Line 1182: pa_projects_all P

1178:
1179: SELECT 'Y' INTO lv_return_flag FROM DUAL
1180: WHERE EXISTS ( SELECT spf.project_id
1181: FROM pa_summary_project_fundings spf, pa_agreements a,
1182: pa_projects_all P
1183: WHERE spf.agreement_id = a.agreement_id
1184: AND spf.project_id = p.project_id
1185: AND a.org_id <> p.org_id);
1186:

Line 1226: FROM pa_std_bill_rate_schedules_all br, pa_projects p

1222: BEGIN
1223:
1224: SELECT 'Y' INTO lv_return_flag FROM DUAL
1225: WHERE EXISTS (SELECT p.project_id
1226: FROM pa_std_bill_rate_schedules_all br, pa_projects p
1227: WHERE ( p.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1228: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))
1229: OR ( p.emp_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1230: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1246: FROM pa_std_bill_rate_schedules_all br, pa_projects p,

1242: /* Fix for Performance bug 4939354
1243:
1244: SELECT 'Y' INTO lv_return_flag FROM DUAL
1245: WHERE EXISTS (SELECT p.project_id
1246: FROM pa_std_bill_rate_schedules_all br, pa_projects p,
1247: pa_tasks t
1248: WHERE p.project_id = t.project_id
1249: AND ( ( t.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1250: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1258: FROM pa_projects p, pa_tasks t

1254: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))));
1255: */
1256: SELECT 'Y' INTO lv_return_flag FROM DUAL
1257: WHERE EXISTS (SELECT p.project_id
1258: FROM pa_projects p, pa_tasks t
1259: WHERE p.project_id = t.project_id
1260: AND EXISTS
1261: (select null
1262: FROM pa_std_bill_rate_schedules_all br

Line 1291: from pa_projects_all

1287:
1288: begin
1289:
1290: select baseline_funding_flag into lv_baseline_flag
1291: from pa_projects_all
1292: where project_id = p_project_id;
1293:
1294: return lv_baseline_flag;
1295:

Line 1336: P_Project_ID IN PA_PROJECTS_ALL.Project_ID%TYPE,

1332: --
1333: -- Inputs: Project_ID and Project_Functional_Currency_Code
1334: ----------------------------------------------------------------------------------
1335: FUNCTION MCB_Flag_Required(
1336: P_Project_ID IN PA_PROJECTS_ALL.Project_ID%TYPE,
1337: P_PFC_Currency_Code IN PA_PROJECTS_ALL.ProjFunc_Currency_Code%TYPE
1338: )
1339: RETURN VARCHAR2
1340: IS

Line 1337: P_PFC_Currency_Code IN PA_PROJECTS_ALL.ProjFunc_Currency_Code%TYPE

1333: -- Inputs: Project_ID and Project_Functional_Currency_Code
1334: ----------------------------------------------------------------------------------
1335: FUNCTION MCB_Flag_Required(
1336: P_Project_ID IN PA_PROJECTS_ALL.Project_ID%TYPE,
1337: P_PFC_Currency_Code IN PA_PROJECTS_ALL.ProjFunc_Currency_Code%TYPE
1338: )
1339: RETURN VARCHAR2
1340: IS
1341:

Line 1450: FROM pa_projects

1446: BEGIN
1447: lv_return_flag := 'N';
1448:
1449: SELECT projfunc_currency_code into lv_projfunc_currency
1450: FROM pa_projects
1451: WHERE project_id = p_project_id;
1452:
1453: BEGIN
1454: SELECT 'Y' into lv_return_flag from dual

Line 1521: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_projects p

1517:
1518: BEGIN
1519: SELECT 'Y' into lv_return_flag from dual
1520: where exists (select null
1521: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_projects p
1522: where p.project_id = p_project_id
1523: and br.BILL_RATE_SCH_ID in
1524: (nvl(p.job_bill_rate_schedule_id,-99),
1525: nvl(p.emp_bill_rate_schedule_id,-99),