DBA Data[Home] [Help]

APPS.FA_DRILLDOWN_PKG dependencies on FA_MC_DEPRN_SUMMARY

Line 93: from fa_mc_deprn_summary

89: select secondary_exists
90: into l_deprn_run_id
91: from (
92: select 1 secondary_exists
93: from fa_mc_deprn_summary
94: where book_type_code = p_source_id_char_1
95: and asset_id = p_source_id_int_1
96: and period_counter = p_source_id_int_2
97: and deprn_run_id = p_source_id_int_3

Line 100: from fa_mc_deprn_summary_h

96: and period_counter = p_source_id_int_2
97: and deprn_run_id = p_source_id_int_3
98: union
99: select 2 secondary_exists
100: from fa_mc_deprn_summary_h
101: where book_type_code = p_source_id_char_1
102: and asset_id = p_source_id_int_1
103: and period_counter = p_source_id_int_2
104: and deprn_run_id = p_source_id_int_3