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.OZF_CLAIM_SETTLEMENT_VAL_PVT dependencies on GL_PERIOD_STATUSES

Line 422: FROM gl_period_statuses gl

418: CURSOR csr_gl_date_validate( cv_app_id IN NUMBER
419: , cv_claim_id IN NUMBER
420: ) IS
421: SELECT DECODE(MAX(gl.period_name), '', 0, 1)
422: FROM gl_period_statuses gl
423: , ozf_claims c
424: WHERE gl.application_id = cv_app_id
425: AND c.claim_id= cv_claim_id
426: AND gl.set_of_books_id = c.set_of_books_id

Line 543: FROM gl_period_statuses

539: AND claim_currency_amount <> 0;
540:
541: CURSOR csr_gl_date_validate(cv_app_id IN NUMBER, cv_set_of_books_id IN NUMBER) IS
542: SELECT DECODE(MAX(period_name), '', 0, 1)
543: FROM gl_period_statuses
544: WHERE application_id = cv_app_id
545: AND set_of_books_id = cv_set_of_books_id
546: AND adjustment_period_flag = 'N'
547: AND SYSDATE BETWEEN start_date AND end_date