APPS.FA_GAINLOSS_RET_PKG dependencies on FA_DEPRN_PERIODS

Line 850: FROM fa_deprn_periods dp,

846: -- Added the condition to check for daily prorate assets
847: if cpdnum_set = 'N' then
848: SELECT to_number (to_char (cp.start_date, 'J'))
849: INTO h_cpp_jstartdate
850: FROM fa_deprn_periods dp,
851: fa_calendar_periods cp,
852: fa_fiscal_year fy
853: WHERE cp.calendar_type = h_d_cal
854: AND fy.fiscal_year_name = h_fiscal_year_name

Line 1443: , fa_deprn_periods dp

1439: --bug13014394: checking to see if override is used or not
1440: cursor c_override_exist (c_asset_id number, c_status varchar2, c_rowid rowid)is
1441: select do.rowid
1442: from fa_deprn_override do
1443: , fa_deprn_periods dp
1444: where do.asset_id = c_asset_id
1445: and do.book_type_code = ret.book
1446: and dp.period_counter = cpd_ctr
1447: and do.period_name = dp.period_name