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 425: FROM gl_period_statuses gl

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

Line 440: FROM gl_period_statuses gl

436: , cv_claim_id IN NUMBER
437: , cv_gl_date IN DATE
438: ) IS
439: SELECT DECODE(MAX(gl.period_name), '', 0, 1)
440: FROM gl_period_statuses gl
441: , ozf_claims c
442: WHERE gl.application_id = cv_app_id
443: AND c.claim_id= cv_claim_id
444: AND gl.set_of_books_id = c.set_of_books_id

Line 582: FROM gl_period_statuses

578: AND claim_currency_amount <> 0;
579:
580: CURSOR csr_gl_date_validate(cv_app_id IN NUMBER, cv_set_of_books_id IN NUMBER) IS
581: SELECT DECODE(MAX(period_name), '', 0, 1)
582: FROM gl_period_statuses
583: WHERE application_id = cv_app_id
584: AND set_of_books_id = cv_set_of_books_id
585: AND adjustment_period_flag = 'N'
586: AND SYSDATE BETWEEN start_date AND end_date