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 1057: SELECT 'Y' into lv_return_flag FROM dual

1053: FROM PA_PROJECT_FUNDINGS P
1054: WHERE P.PROJECT_ID = p_project_id
1055: AND budget_type_code = 'DRAFT';
1056: */
1057: SELECT 'Y' into lv_return_flag FROM dual
1058: WHERE exists
1059: (SELECT project_id
1060: FROM pa_project_fundings
1061: WHERE project_id = p_project_id

Line 1078: SELECT 'Y' into lv_return_flag from dual

1074: -- check to see if any Event records exists
1075:
1076: begin
1077:
1078: SELECT 'Y' into lv_return_flag from dual
1079: where exists
1080: (select project_id
1081: from pa_events
1082: where project_id = p_project_id);

Line 1099: SELECT 'Y' into lv_return_flag from dual

1095:
1096: begin
1097:
1098: /*Commented for bug 3088683
1099: SELECT 'Y' into lv_return_flag from dual
1100: where exists
1101: (select T.project_id
1102: from pa_expenditure_items_all E, pa_tasks T
1103: where T.project_id = p_project_id

Line 1109: SELECT 'Y' into lv_return_flag from dual

1105: End of comment for bug 3088683 */
1106:
1107: /*Added for bug 3088683 */
1108:
1109: SELECT 'Y' into lv_return_flag from dual
1110: where exists
1111: (select E.project_id
1112: from pa_expenditure_items_all E
1113: where E.project_id = p_project_id);

Line 1179: SELECT 'Y' INTO lv_return_flag FROM DUAL

1175: lv_return_flag varchar2(1);
1176:
1177: BEGIN
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

Line 1206: SELECT 'Y' INTO lv_return_flag FROM DUAL

1202: lv_return_flag varchar2(1);
1203:
1204: BEGIN
1205:
1206: SELECT 'Y' INTO lv_return_flag FROM DUAL
1207: WHERE EXISTS (SELECT p.project_type_id
1208: FROM pa_std_bill_rate_schedules_all br, pa_project_types p
1209: WHERE ( p.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1210: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1224: SELECT 'Y' INTO lv_return_flag FROM DUAL

1220: WHEN OTHERS THEN
1221:
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))

Line 1244: SELECT 'Y' INTO lv_return_flag FROM DUAL

1240: BEGIN
1241:
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

Line 1256: SELECT 'Y' INTO lv_return_flag FROM DUAL

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

Line 1349: FROM Dual

1345: -- different currency code, other than the Given Currency Code
1346: BEGIN
1347: SELECT 'Y'
1348: INTO l_Flag
1349: FROM Dual
1350: WHERE Exists ( SELECt 1 FROM PA_Project_Customers
1351: WHERE Project_ID = p_Project_ID
1352: AND Inv_Currency_Code <> p_pfc_Currency_Code);
1353: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1364: FROM Dual

1360: THEN
1361: BEGIN
1362: SELECT 'Y'
1363: INTO l_Flag
1364: FROM Dual
1365: WHERE Exists ( SELECT 1 FROM PA_Draft_Invoices_All
1366: WHERE Project_ID = p_Project_ID
1367: AND Inv_Currency_Code <> p_pfc_Currency_Code);
1368: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1402: from dual ;

1398: /* Code addition for bug 2872748 starts */
1399: begin
1400: select pa_currency.get_currency_code
1401: into l_currency_code
1402: from dual ;
1403: end;
1404: /* Code addition for bug 2872748 ends */
1405:
1406: SELECT 'N' INTO lv_return_flag FROM DUAL

Line 1406: SELECT 'N' INTO lv_return_flag FROM DUAL

1402: from dual ;
1403: end;
1404: /* Code addition for bug 2872748 ends */
1405:
1406: SELECT 'N' INTO lv_return_flag FROM DUAL
1407: WHERE EXISTS ( SELECT a.agreement_id
1408: FROM pa_agreements a
1409: WHERE a.agreement_currency_code <> l_currency_code);
1410: /* for bug 2872748 replaced pa_currency.get_currency_code with l_currency_code in above sql */

Line 1420: SELECT 'N' INTO lv_return_flag FROM DUAL

1416: WHEN OTHERS THEN
1417:
1418: BEGIN
1419:
1420: SELECT 'N' INTO lv_return_flag FROM DUAL
1421: WHERE EXISTS ( SELECT b.bill_rate_sch_id
1422: /* Commented for bug 2867740
1423: FROM pa_bill_rates b
1424: WHERE b.RATE_CURRENCY_CODE <> pa_currency.get_currency_code); */

Line 1454: SELECT 'Y' into lv_return_flag from dual

1450: FROM pa_projects
1451: WHERE project_id = p_project_id;
1452:
1453: BEGIN
1454: SELECT 'Y' into lv_return_flag from dual
1455: where exists (select null
1456: from pa_billing_assignments asg
1457: /* where nvl(asg.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002*/
1458: where asg.project_id = p_project_id

Line 1469: SELECT 'Y' into lv_return_flag from dual

1465: lv_return_flag := 'N';
1466: END;
1467:
1468: BEGIN
1469: SELECT 'Y' into lv_return_flag from dual
1470: where exists (select null
1471: FROM pa_job_bill_rate_overrides jbr
1472: /* where nvl(jbr.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002 */
1473: where jbr.project_id = p_project_id

Line 1485: SELECT 'Y' into lv_return_flag from dual

1481: lv_return_flag := 'N';
1482: END;
1483:
1484: BEGIN
1485: SELECT 'Y' into lv_return_flag from dual
1486: where exists (select null
1487: FROM pa_nl_bill_rate_overrides nlr
1488: /* where nvl(nlr.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002 */
1489: where nlr.project_id = p_project_id

Line 1502: SELECT 'Y' into lv_return_flag from dual

1498: END;
1499:
1500:
1501: BEGIN
1502: SELECT 'Y' into lv_return_flag from dual
1503: where exists (select null
1504: FROM pa_emp_bill_rate_overrides emp
1505: /* where nvl(emp.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002 */
1506: where emp.project_id = p_project_id

Line 1519: SELECT 'Y' into lv_return_flag from dual

1515: END;
1516:
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

Line 1539: SELECT 'Y' into lv_return_flag from dual

1535: --- task level overrides
1536:
1537:
1538: BEGIN
1539: SELECT 'Y' into lv_return_flag from dual
1540: where exists (select null
1541: from pa_billing_assignments asg, pa_tasks t
1542: where t.project_id = p_project_id
1543: /* and nvl(asg.top_task_id,-99) = t.task_id Bug 2702200 Modified on 20/12/2002 */

Line 1557: SELECT 'Y' into lv_return_flag from dual

1553: lv_return_flag := 'N';
1554: END;
1555:
1556: BEGIN
1557: SELECT 'Y' into lv_return_flag from dual
1558: where exists (select null
1559: FROM pa_job_bill_rate_overrides jbr, pa_tasks t
1560: where t.project_id = p_project_id
1561: /* and nvl(jbr.task_id,-99) = t.task_id Bug 2702200 Modified on 20/12/2002 */

Line 1574: SELECT 'Y' into lv_return_flag from dual

1570: lv_return_flag := 'N';
1571: END;
1572:
1573: BEGIN
1574: SELECT 'Y' into lv_return_flag from dual
1575: where exists (select null
1576: FROM pa_nl_bill_rate_overrides nlr, pa_tasks t
1577: where t.project_id = p_project_id
1578: /* and nvl(nlr.task_id,-99) = t.task_id Modifed on 20/12/2002 */

Line 1592: SELECT 'Y' into lv_return_flag from dual

1588: END;
1589:
1590:
1591: BEGIN
1592: SELECT 'Y' into lv_return_flag from dual
1593: where exists (select null
1594: FROM pa_emp_bill_rate_overrides emp, pa_tasks t
1595: where t.project_id = p_project_id
1596: /* and nvl(emp.task_id,-99) = t.task_id Modifed on 20/12/2002*/

Line 1610: SELECT 'Y' into lv_return_flag from dual

1606: END;
1607:
1608:
1609: BEGIN
1610: SELECT 'Y' into lv_return_flag from dual
1611: where exists (select null
1612: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_tasks t
1613: where t.project_id = p_project_id
1614: and br.BILL_RATE_SCH_ID in