DBA Data[Home] [Help]

APPS.FA_MASSCP_PKG dependencies on FA_CALENDAR_PERIODS

Line 2172: fa_calendar_periods cal1,

2168: select count(*)
2169: into l_count
2170: from fa_conventions conv1,
2171: fa_conventions conv2,
2172: fa_calendar_periods cal1,
2173: fa_calendar_periods cal2
2174: where conv1.prorate_convention_code =
2175: fa_cache_pkg.fazccbd_record.retirement_prorate_convention
2176: and conv2.prorate_convention_code =

Line 2173: fa_calendar_periods cal2

2169: into l_count
2170: from fa_conventions conv1,
2171: fa_conventions conv2,
2172: fa_calendar_periods cal1,
2173: fa_calendar_periods cal2
2174: where conv1.prorate_convention_code =
2175: fa_cache_pkg.fazccbd_record.retirement_prorate_convention
2176: and conv2.prorate_convention_code =
2177: fa_cache_pkg.fazccbd_record.retirement_prorate_convention