APPS.IGI_EXP_UTILS dependencies on IGI_EXP_DU_TYPE_HEADERS

Line 490: pv_app_id igi_exp_du_type_headers.application_id%TYPE,

486: SELECT purch_encumbrance_flag
487: FROM financials_system_parameters;
488:
489: CURSOR c_open_period(pv_sob_id gl_sets_of_books.set_of_books_id%TYPE,
490: pv_app_id igi_exp_du_type_headers.application_id%TYPE,
491: pv_gl_date DATE)
492: IS
493: SELECT gps.period_year,
494: gsob.latest_encumbrance_year

Line 505: pv_app_id igi_exp_du_type_headers.application_id%TYPE,

501: AND gps.closing_status IN ('O', 'F')
502: AND NVL(gps.adjustment_period_flag, 'N') = 'N';
503:
504: CURSOR c_last_open_period(pv_sob_id gl_sets_of_books.set_of_books_id%TYPE,
505: pv_app_id igi_exp_du_type_headers.application_id%TYPE,
506: pv_period_year number)
507: IS
508: SELECT gps.period_year,
509: gsob.latest_encumbrance_year,

Line 521: pv_app_id igi_exp_du_type_headers.application_id%TYPE,

517: AND gps.period_year = pv_period_year; -- shsaxena Bug 2777575.
518:
519: /* shsaxena Bug 2777575 START */
520: CURSOR Cur_current_fis_year (pv_sob_id gl_sets_of_books.set_of_books_id%TYPE,
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,

Line 534: pv_app_id igi_exp_du_type_headers.application_id%TYPE,

530: AND trunc(pv_gl_date) BETWEEN trunc(gps.start_date) AND trunc(gps.end_date);
531:
532:
533: CURSOR Cur_prev_year_end_date (pv_sob_id gl_sets_of_books.set_of_books_id%TYPE,
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