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.HZ_ORG_INFO_PUB dependencies on DUAL

Line 64: INTO l_stock_exchange_id from dual;

60: l_count := 1;
61:
62: WHILE l_count >0 LOOP
63: SELECT hz_stock_markets_s.nextval
64: INTO l_stock_exchange_id from dual;
65:
66: SELECT count(*)
67: INTO l_count
68: FROM HZ_STOCK_MARKETS

Line 281: INTO l_security_issued_id from DUAL;

277: l_count := 1;
278:
279: WHILE l_count > 0 LOOP
280: SELECT hz_security_issued_s.nextval
281: INTO l_security_issued_id from DUAL;
282:
283: SELECT count(*)
284: INTO l_count
285: FROM HZ_SECURITY_ISSUED

Line 549: INTO l_financial_report_id from dual;

545: l_count := 1;
546:
547: WHILE l_count >0 LOOP
548: SELECT hz_financial_reports_s.nextval
549: INTO l_financial_report_id from dual;
550:
551: SELECT count(*)
552: INTO l_count
553: FROM HZ_FINANCIAL_REPORTS

Line 903: INTO l_financial_number_id from dual;

899: l_count := 1;
900:
901: WHILE l_count >0 LOOP
902: SELECT hz_financial_numbers_s.nextval
903: INTO l_financial_number_id from dual;
904:
905: SELECT count(*)
906: INTO l_count
907: FROM HZ_FINANCIAL_NUMBERS

Line 1315: INTO l_certification_id from dual;

1311: l_count := 1;
1312:
1313: WHILE l_count >0 LOOP
1314: SELECT hz_certifications_s.nextval
1315: INTO l_certification_id from dual;
1316:
1317: SELECT count(*)
1318: INTO l_count
1319: FROM HZ_CERTIFICATIONS

Line 1541: INTO l_industry_reference_id from dual;

1537: l_count := 1;
1538:
1539: WHILE l_count >0 LOOP
1540: SELECT hz_industrial_reference_s.nextval
1541: INTO l_industry_reference_id from dual;
1542:
1543: SELECT count(*)
1544: INTO l_count
1545: FROM HZ_INDUSTRIAL_REFERENCE

Line 1764: INTO l_industrial_class_id from dual;

1760: l_count := 1;
1761:
1762: WHILE l_count >0 LOOP
1763: SELECT hz_industrial_classes_s.nextval
1764: INTO l_industrial_class_id from dual;
1765:
1766: SELECT count(*)
1767: INTO l_count
1768: FROM HZ_INDUSTRIAL_CLASSES

Line 2510: INTO l_code_applied_id from dual;

2506: l_count := 1;
2507:
2508: WHILE l_count >0 LOOP
2509: SELECT hz_industrial_class_app_s.nextval
2510: INTO l_code_applied_id from dual;
2511:
2512: SELECT count(*)
2513: INTO l_count
2514: FROM HZ_INDUSTRIAL_CLASS_APP