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

Line 495: FROM gl_period_statuses gps,

491: pv_gl_date DATE)
492: IS
493: SELECT gps.period_year,
494: gsob.latest_encumbrance_year
495: FROM gl_period_statuses gps,
496: gl_sets_of_books gsob
497: WHERE gps.application_id = pv_app_id
498: AND gps.set_of_books_id = pv_sob_id
499: AND gps.set_of_books_id = gsob.set_of_books_id

Line 511: FROM gl_period_statuses gps,

507: IS
508: SELECT gps.period_year,
509: gsob.latest_encumbrance_year,
510: gps.end_date
511: FROM gl_period_statuses gps,
512: gl_sets_of_books gsob
513: WHERE gps.application_id = pv_app_id
514: AND gps.set_of_books_id = pv_sob_id
515: AND gps.set_of_books_id = gsob.set_of_books_id

Line 525: FROM gl_period_statuses gps,

521: pv_app_id igi_exp_du_type_headers.application_id%TYPE,
522: pv_gl_date DATE)
523: IS
524: SELECT gps.period_year
525: FROM gl_period_statuses gps,
526: gl_sets_of_books gsob
527: WHERE gps.application_id = pv_app_id
528: AND gps.set_of_books_id = pv_sob_id
529: AND gps.set_of_books_id = gsob.set_of_books_id

Line 538: FROM gl_period_statuses gps

534: pv_app_id igi_exp_du_type_headers.application_id%TYPE,
535: pv_period_year number)
536: IS
537: SELECT gps.end_date
538: FROM gl_period_statuses gps
539: WHERE gps.application_id = pv_app_id
540: AND gps.set_of_books_id = pv_sob_id
541: AND gps.period_year = pv_period_year
542: AND gps.period_num =

Line 543: (SELECT max(gps1.period_num) from gl_period_statuses gps1

539: WHERE gps.application_id = pv_app_id
540: AND gps.set_of_books_id = pv_sob_id
541: AND gps.period_year = pv_period_year
542: AND gps.period_num =
543: (SELECT max(gps1.period_num) from gl_period_statuses gps1
544: WHERE gps1.application_id = pv_app_id
545: AND gps1.set_of_books_id = pv_sob_id
546: AND gps1.period_year = pv_period_year);
547:

Line 558: l_period_year gl_period_statuses.period_year%TYPE ;

554: l_du_fiscal_year igi_exp_dus_v.du_fiscal_year%TYPE;
555: /* shsaxena Bug 2777575 END */
556:
557: l_latest_encumbrance_year gl_sets_of_books.latest_encumbrance_year%TYPE ;
558: l_period_year gl_period_statuses.period_year%TYPE ;
559: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE ;
560: l_sob_id gl_sets_of_books.set_of_books_id%TYPE ;
561: l_debug_info VARCHAR2(2000);
562: l_gl_date DATE;