APPS.IGIRX_IMP_IAC_REP dependencies on IGI_IMP_IAC_CONTROLS

Line 422: igi_imp_iac_controls ct

418: nvl(ii.NBV_MHCA * (dh.units_Assigned/ad.current_units) ,0) NBV_MHCA
419: FROM Igi_Imp_Iac_Interface ii,
420: Fa_Distribution_History dh,
421: Fa_Additions ad,
422: igi_imp_iac_controls ct
423: WHERE
424: ii.book_type_code=p_book_type_code AND
425: ii.CATEGORY_ID=NVL(P_CATEGORY_ID,ii.CATEGORY_ID) AND
426: ct.book_type_code = ii.book_type_code AND

Line 455: FROM igi_imp_iac_controls

451:
452: CURSOR C_period_counter
453: IS
454: SELECT max(period_counter)
455: FROM igi_imp_iac_controls
456: WHERE Book_Type_Code = p_book_type_code;
457:
458: CURSOR C_period (p_max_period_counter in VARCHAR2)
459: IS