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_DNBUI_PVT dependencies on HZ_FINANCIAL_REPORTS

Line 390: FROM hz_financial_reports

386: * latest financial report
387: *
388: SELECT MAX(date_report_issued)
389: INTO l_date_report_issued
390: FROM hz_financial_reports
391: WHERE party_id = p_party_id
392: AND type_of_financial_report = p_type_of_financial_report
393: AND actual_content_source = p_actual_content_source;
394:

Line 397: FROM hz_financial_reports

393: AND actual_content_source = p_actual_content_source;
394:
395: SELECT MAX(report_end_date)
396: INTO l_report_end_date
397: FROM hz_financial_reports
398: WHERE party_id = p_party_id
399: AND type_of_financial_report = p_type_of_financial_report
400: AND actual_content_source = p_actual_content_source;
401: */

Line 404: FROM hz_financial_reports

400: AND actual_content_source = p_actual_content_source;
401: */
402: SELECT MAX(creation_date)
403: INTO l_creation_date
404: FROM hz_financial_reports
405: WHERE party_id = p_party_id
406: AND type_of_financial_report = p_type_of_financial_report
407: AND actual_content_source = p_actual_content_source;
408:

Line 411: FROM hz_financial_reports

407: AND actual_content_source = p_actual_content_source;
408:
409: SELECT financial_report_id
410: INTO l_financial_report_id
411: FROM hz_financial_reports
412: WHERE party_id = p_party_id
413: AND type_of_financial_report = p_type_of_financial_report
414: AND actual_content_source = p_actual_content_source
415: -- Bug 3395969 : Change the conditino to creation_date