APPS.FA_SORP_UPG_PKG dependencies on FA_CASH_GEN_UNITS

Line 1881: FROM fa_cash_gen_units a, FA_MC_IMPAIRMENTS i

1877: NVL (i.description, 'Others') imp_description,
1878: NVL (SUBSTR (i.description, 1, 3),
1879: 'OTH'
1880: ) impair_classification_type
1881: FROM fa_cash_gen_units a, FA_MC_IMPAIRMENTS i
1882: WHERE a.cash_generating_unit_id = i.cash_generating_unit_id
1883: AND i.book_type_code = p_book;
1884:
1885: v_imp_cash_cur c_imp_cash_cur%ROWTYPE;

Line 2427: FROM fa_cash_gen_units a, fa_impairments i

2423: NVL (i.description, 'Others') imp_description,
2424: NVL (SUBSTR (i.description, 1, 3),
2425: 'OTH'
2426: ) impair_classification_type
2427: FROM fa_cash_gen_units a, fa_impairments i
2428: WHERE a.cash_generating_unit_id = i.cash_generating_unit_id
2429: AND i.book_type_code = p_book;
2430:
2431: v_imp_cash_cur c_imp_cash_cur%ROWTYPE;