APPS.IGIRX_IMP_IAC_REP dependencies on IGI_IMP_IAC_INTERFACE

Line 385: FROM igi_imp_iac_interface ii

381: p_category_id IN NUMBER)
382: IS
383: SELECT YTD_HIST,YTD_MHCA,asset_number,
384: cost_hist,cost_mhca
385: FROM igi_imp_iac_interface ii
386: WHERE
387: ii.asset_id=p_asset_id AND
388: ii.book_type_code=p_book_type_code AND
389: ii.category_id=p_category_id ;

Line 419: FROM Igi_Imp_Iac_Interface ii,

415: nvl(ii.Operating_Account_Cost * (dh.units_Assigned/ad.current_units) ,0) Operating_Account_Cost,
416: nvl(ii.Operating_Account_Backlog * (dh.units_Assigned/ad.current_units) ,0) Operating_Account_Backlog,
417: nvl(ii.NBV_Hist * (dh.units_Assigned/ad.current_units) ,0) NBV_Hist,
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

Line 539: FROM igi_imp_iac_interface

535:
536: CURSOR C_asset(p_category_id in number)
537: IS
538: SELECT asset_id
539: FROM igi_imp_iac_interface
540: WHERE
541: book_type_code=p_book_type_code AND
542: category_id=p_category_id;
543:

Line 548: igi_imp_iac_interface_ctrl

544: CURSOR C_category(p_category_id in number)
545: IS
546: SELECT distinct category_id
547: FROM
548: igi_imp_iac_interface_ctrl
549: WHERE book_type_code=p_book_type_code AND
550: category_id=nvl(p_category_id,category_id);
551:
552: