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 DUAL

Line 1050: SELECT 'Y' into lv_return_flag FROM dual

1046: FROM PA_PROJECT_FUNDINGS P
1047: WHERE P.PROJECT_ID = p_project_id
1048: AND budget_type_code = 'DRAFT';
1049: */
1050: SELECT 'Y' into lv_return_flag FROM dual
1051: WHERE exists
1052: (SELECT project_id
1053: FROM pa_project_fundings
1054: WHERE project_id = p_project_id

Line 1071: SELECT 'Y' into lv_return_flag from dual

1067: -- check to see if any Event records exists
1068:
1069: begin
1070:
1071: SELECT 'Y' into lv_return_flag from dual
1072: where exists
1073: (select project_id
1074: from pa_events
1075: where project_id = p_project_id);

Line 1092: SELECT 'Y' into lv_return_flag from dual

1088:
1089: begin
1090:
1091: /*Commented for bug 3088683
1092: SELECT 'Y' into lv_return_flag from dual
1093: where exists
1094: (select T.project_id
1095: from pa_expenditure_items_all E, pa_tasks T
1096: where T.project_id = p_project_id

Line 1102: SELECT 'Y' into lv_return_flag from dual

1098: End of comment for bug 3088683 */
1099:
1100: /*Added for bug 3088683 */
1101:
1102: SELECT 'Y' into lv_return_flag from dual
1103: where exists
1104: (select E.project_id
1105: from pa_expenditure_items_all E
1106: where E.project_id = p_project_id);

Line 1172: SELECT 'Y' INTO lv_return_flag FROM DUAL

1168: lv_return_flag varchar2(1);
1169:
1170: BEGIN
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

Line 1199: SELECT 'Y' INTO lv_return_flag FROM DUAL

1195: lv_return_flag varchar2(1);
1196:
1197: BEGIN
1198:
1199: SELECT 'Y' INTO lv_return_flag FROM DUAL
1200: WHERE EXISTS (SELECT p.project_type_id
1201: FROM pa_std_bill_rate_schedules_all br, pa_project_types p
1202: WHERE ( p.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1203: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1217: SELECT 'Y' INTO lv_return_flag FROM DUAL

1213: WHEN OTHERS THEN
1214:
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))

Line 1237: SELECT 'Y' INTO lv_return_flag FROM DUAL

1233: BEGIN
1234:
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

Line 1249: SELECT 'Y' INTO lv_return_flag FROM DUAL

1245: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))
1246: OR ( t.non_lab_std_bill_rt_sch_id = br.BILL_RATE_SCH_ID
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

Line 1342: FROM Dual

1338: -- different currency code, other than the Given Currency Code
1339: BEGIN
1340: SELECT 'Y'
1341: INTO l_Flag
1342: FROM Dual
1343: WHERE Exists ( SELECt 1 FROM PA_Project_Customers
1344: WHERE Project_ID = p_Project_ID
1345: AND Inv_Currency_Code <> p_pfc_Currency_Code);
1346: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1357: FROM Dual

1353: THEN
1354: BEGIN
1355: SELECT 'Y'
1356: INTO l_Flag
1357: FROM Dual
1358: WHERE Exists ( SELECT 1 FROM PA_Draft_Invoices_All
1359: WHERE Project_ID = p_Project_ID
1360: AND Inv_Currency_Code <> p_pfc_Currency_Code);
1361: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1395: from dual ;

1391: /* Code addition for bug 2872748 starts */
1392: begin
1393: select pa_currency.get_currency_code
1394: into l_currency_code
1395: from dual ;
1396: end;
1397: /* Code addition for bug 2872748 ends */
1398:
1399: SELECT 'N' INTO lv_return_flag FROM DUAL

Line 1399: SELECT 'N' INTO lv_return_flag FROM DUAL

1395: from dual ;
1396: end;
1397: /* Code addition for bug 2872748 ends */
1398:
1399: SELECT 'N' INTO lv_return_flag FROM DUAL
1400: WHERE EXISTS ( SELECT a.agreement_id
1401: FROM pa_agreements a
1402: WHERE a.agreement_currency_code <> l_currency_code);
1403: /* for bug 2872748 replaced pa_currency.get_currency_code with l_currency_code in above sql */

Line 1413: SELECT 'N' INTO lv_return_flag FROM DUAL

1409: WHEN OTHERS THEN
1410:
1411: BEGIN
1412:
1413: SELECT 'N' INTO lv_return_flag FROM DUAL
1414: WHERE EXISTS ( SELECT b.bill_rate_sch_id
1415: /* Commented for bug 2867740
1416: FROM pa_bill_rates b
1417: WHERE b.RATE_CURRENCY_CODE <> pa_currency.get_currency_code); */

Line 1447: SELECT 'Y' into lv_return_flag from dual

1443: FROM pa_projects
1444: WHERE project_id = p_project_id;
1445:
1446: BEGIN
1447: SELECT 'Y' into lv_return_flag from dual
1448: where exists (select null
1449: from pa_billing_assignments asg
1450: /* where nvl(asg.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002*/
1451: where asg.project_id = p_project_id

Line 1462: SELECT 'Y' into lv_return_flag from dual

1458: lv_return_flag := 'N';
1459: END;
1460:
1461: BEGIN
1462: SELECT 'Y' into lv_return_flag from dual
1463: where exists (select null
1464: FROM pa_job_bill_rate_overrides jbr
1465: /* where nvl(jbr.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002 */
1466: where jbr.project_id = p_project_id

Line 1478: SELECT 'Y' into lv_return_flag from dual

1474: lv_return_flag := 'N';
1475: END;
1476:
1477: BEGIN
1478: SELECT 'Y' into lv_return_flag from dual
1479: where exists (select null
1480: FROM pa_nl_bill_rate_overrides nlr
1481: /* where nvl(nlr.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002 */
1482: where nlr.project_id = p_project_id

Line 1495: SELECT 'Y' into lv_return_flag from dual

1491: END;
1492:
1493:
1494: BEGIN
1495: SELECT 'Y' into lv_return_flag from dual
1496: where exists (select null
1497: FROM pa_emp_bill_rate_overrides emp
1498: /* where nvl(emp.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002 */
1499: where emp.project_id = p_project_id

Line 1512: SELECT 'Y' into lv_return_flag from dual

1508: END;
1509:
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

Line 1532: SELECT 'Y' into lv_return_flag from dual

1528: --- task level overrides
1529:
1530:
1531: BEGIN
1532: SELECT 'Y' into lv_return_flag from dual
1533: where exists (select null
1534: from pa_billing_assignments asg, pa_tasks t
1535: where t.project_id = p_project_id
1536: /* and nvl(asg.top_task_id,-99) = t.task_id Bug 2702200 Modified on 20/12/2002 */

Line 1550: SELECT 'Y' into lv_return_flag from dual

1546: lv_return_flag := 'N';
1547: END;
1548:
1549: BEGIN
1550: SELECT 'Y' into lv_return_flag from dual
1551: where exists (select null
1552: FROM pa_job_bill_rate_overrides jbr, pa_tasks t
1553: where t.project_id = p_project_id
1554: /* and nvl(jbr.task_id,-99) = t.task_id Bug 2702200 Modified on 20/12/2002 */

Line 1567: SELECT 'Y' into lv_return_flag from dual

1563: lv_return_flag := 'N';
1564: END;
1565:
1566: BEGIN
1567: SELECT 'Y' into lv_return_flag from dual
1568: where exists (select null
1569: FROM pa_nl_bill_rate_overrides nlr, pa_tasks t
1570: where t.project_id = p_project_id
1571: /* and nvl(nlr.task_id,-99) = t.task_id Modifed on 20/12/2002 */

Line 1585: SELECT 'Y' into lv_return_flag from dual

1581: END;
1582:
1583:
1584: BEGIN
1585: SELECT 'Y' into lv_return_flag from dual
1586: where exists (select null
1587: FROM pa_emp_bill_rate_overrides emp, pa_tasks t
1588: where t.project_id = p_project_id
1589: /* and nvl(emp.task_id,-99) = t.task_id Modifed on 20/12/2002*/

Line 1603: SELECT 'Y' into lv_return_flag from dual

1599: END;
1600:
1601:
1602: BEGIN
1603: SELECT 'Y' into lv_return_flag from dual
1604: where exists (select null
1605: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_tasks t
1606: where t.project_id = p_project_id
1607: and br.BILL_RATE_SCH_ID in