DBA Data[Home] [Help]

APPS.FII_TIME_M_C dependencies on PA_PERIODS_ALL

Line 186: pa_periods_all paprd,

182: (glprd.period_year * 10000) + glprd.period_num
183: from gl_date_period_map map,
184: pa_implementations_all imp,
185: gl_sets_of_books sob,
186: pa_periods_all paprd,
187: gl_periods glprd
188: where imp.set_of_books_id = sob.set_of_books_id
189: and paprd.org_id = imp.org_id
190: and map.period_type = imp.pa_period_type

Line 211: pa_periods_all paprd,

207: imp.pa_period_type,
208: (glprd.period_year * 10000) + glprd.period_num
209: from pa_implementations_all imp,
210: gl_sets_of_books sob,
211: pa_periods_all paprd,
212: gl_periods glprd
213: where imp.set_of_books_id = sob.set_of_books_id
214: and paprd.org_id = imp.org_id
215: and paprd.end_date >= NVL(p_from_date, paprd.end_date)