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.PQH_DOCUMENTS_WRAPPER dependencies on PQH_DOCUMENTS_F

Line 46: select (effective_end_date) from pqh_documents_f pdf where p_effective_date between effective_start_date and effective_end_date

42: from pqh_document_attributes_f pdaf
43: where pdaf.document_id = p_document_id
44: and pdaf.effective_start_date >
45: (
46: select (effective_end_date) from pqh_documents_f pdf where p_effective_date between effective_start_date and effective_end_date
47: and pdf.document_id = pdaf.document_id
48: );
49:
50: Cursor csr_future_versions IS

Line 51: Select 'PRESENT' from pqh_documents_f

47: and pdf.document_id = pdaf.document_id
48: );
49:
50: Cursor csr_future_versions IS
51: Select 'PRESENT' from pqh_documents_f
52: where document_id =p_document_id
53: and p_effective_date between effective_start_date and effective_end_date
54: and effective_end_date <> hr_general.end_of_time;
55: --