APPS.JA_CN_FA_RAI_EXPORT_PKG dependencies on FA_DEPRN_PERIODS

Line 273: FROM fa_deprn_periods fdp

269: AND fdh.asset_id = faav.asset_id
270: -- Check legal entity
271: AND EXISTS
272: (SELECT fdp.period_close_date
273: FROM fa_deprn_periods fdp
274: WHERE fdp.book_type_code = fb.book_type_code
275: AND fdp.calendar_period_close_date BETWEEN ld_start_date AND
276: ld_end_date
277: AND fdp.period_close_date IS NOT NULL)

Line 280: FROM fa_deprn_periods fdp

276: ld_end_date
277: AND fdp.period_close_date IS NOT NULL)
278: AND fdh.date_effective <
279: nvl((SELECT MAX(fdp.period_close_date)
280: FROM fa_deprn_periods fdp
281: WHERE fdp.book_type_code = fb.book_type_code
282: AND fdp.calendar_period_close_date <= ld_end_date
283: AND fdp.period_close_date IS NOT NULL),
284: SYSDATE)

Line 287: FROM fa_deprn_periods fdp

283: AND fdp.period_close_date IS NOT NULL),
284: SYSDATE)
285: AND (fdh.date_ineffective >
286: nvl((SELECT MAX(fdp.period_close_date)
287: FROM fa_deprn_periods fdp
288: WHERE fdp.book_type_code = fb.book_type_code
289: AND fdp.calendar_period_close_date <= ld_end_date
290: AND fdp.period_close_date IS NOT NULL),
291: SYSDATE) OR fdh.date_ineffective IS NULL)

Line 309: FROM fa_deprn_periods dp

305: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
306: least(SYSDATE,
307: dp.calendar_period_close_date)),
308: dp.calendar_period_open_date)
309: FROM fa_deprn_periods dp
310: WHERE fthv.book_type_code = dp.book_type_code
311: AND fthv.date_effective BETWEEN dp.period_open_date AND
312: nvl(dp.period_close_date, SYSDATE)) <= ld_end_date)
313: ORDER BY faav.asset_number, flk.concatenated_segments;

Line 383: FROM fa_deprn_periods fdp

379:
380: --get the period counter
381: SELECT MAX(fdp.period_close_date)
382: INTO ld_dp_period_close_date
383: FROM fa_deprn_periods fdp
384: WHERE greatest(greatest(fdp.calendar_period_open_date,
385: least(sysdate, fdp.calendar_period_close_date)),
386: fdp.calendar_period_open_date) BETWEEN ld_start_date AND
387: ld_end_date

Line 417: FROM fa_deprn_periods dp

413: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
414: least(sysdate,
415: dp.calendar_period_close_date)),
416: dp.calendar_period_open_date)
417: FROM fa_deprn_periods dp
418: WHERE fthv.book_type_code = dp.book_type_code
419: AND fthv.date_effective BETWEEN dp.period_open_date AND
420: nvl(dp.period_close_date, SYSDATE)) <= ld_end_date);
421: IF (ln_full_retirement_count <> 0) THEN

Line 434: FROM fa_deprn_periods dp

430: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
431: least(SYSDATE,
432: dp.calendar_period_close_date)),
433: dp.calendar_period_open_date)
434: FROM fa_deprn_periods dp
435: WHERE fthv.book_type_code = dp.book_type_code
436: AND fthv.date_effective BETWEEN dp.period_open_date AND
437: nvl(dp.period_close_date, SYSDATE)) <= ld_end_date);
438: IF (ln_reinstate_count = 0) THEN

Line 452: FROM fa_deprn_periods dp

448: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
449: least(sysdate,
450: dp.calendar_period_close_date)),
451: dp.calendar_period_open_date)
452: FROM fa_deprn_periods dp
453: WHERE fthv.book_type_code = dp.book_type_code
454: AND fthv.date_effective BETWEEN dp.period_open_date AND
455: nvl(dp.period_close_date, SYSDATE)) <=
456: ld_end_date);

Line 468: FROM fa_deprn_periods dp

464: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
465: least(SYSDATE,
466: dp.calendar_period_close_date)),
467: dp.calendar_period_open_date)
468: FROM fa_deprn_periods dp
469: WHERE fthv.book_type_code = dp.book_type_code
470: AND fthv.date_effective BETWEEN dp.period_open_date AND
471: nvl(dp.period_close_date, SYSDATE)) <=
472: ld_end_date);