APPS.JA_AU_FA_BAL_CHG dependencies on FA_DEPRN_PERIODS

Line 19: v_from_date fa_deprn_periods.period_open_date%type;

15: v_to_period varchar2(15) := (P_To_Period);
16: v_category_id integer := to_number(P_Category_id);
17: v_cat_temp integer := 1;
18: v_category varchar2(80);
19: v_from_date fa_deprn_periods.period_open_date%type;
20: v_from_counter fa_deprn_periods.period_counter%type;
21: v_from_cal_date fa_deprn_periods.calendar_period_open_date%type;
22: v_to_date fa_deprn_periods.period_close_date%type;
23: v_to_counter fa_deprn_periods.period_counter%type;

Line 20: v_from_counter fa_deprn_periods.period_counter%type;

16: v_category_id integer := to_number(P_Category_id);
17: v_cat_temp integer := 1;
18: v_category varchar2(80);
19: v_from_date fa_deprn_periods.period_open_date%type;
20: v_from_counter fa_deprn_periods.period_counter%type;
21: v_from_cal_date fa_deprn_periods.calendar_period_open_date%type;
22: v_to_date fa_deprn_periods.period_close_date%type;
23: v_to_counter fa_deprn_periods.period_counter%type;
24: v_col1 fnd_id_flex_segments.application_column_name%type;

Line 21: v_from_cal_date fa_deprn_periods.calendar_period_open_date%type;

17: v_cat_temp integer := 1;
18: v_category varchar2(80);
19: v_from_date fa_deprn_periods.period_open_date%type;
20: v_from_counter fa_deprn_periods.period_counter%type;
21: v_from_cal_date fa_deprn_periods.calendar_period_open_date%type;
22: v_to_date fa_deprn_periods.period_close_date%type;
23: v_to_counter fa_deprn_periods.period_counter%type;
24: v_col1 fnd_id_flex_segments.application_column_name%type;
25: v_col2 fnd_id_flex_segments.application_column_name%type;

Line 22: v_to_date fa_deprn_periods.period_close_date%type;

18: v_category varchar2(80);
19: v_from_date fa_deprn_periods.period_open_date%type;
20: v_from_counter fa_deprn_periods.period_counter%type;
21: v_from_cal_date fa_deprn_periods.calendar_period_open_date%type;
22: v_to_date fa_deprn_periods.period_close_date%type;
23: v_to_counter fa_deprn_periods.period_counter%type;
24: v_col1 fnd_id_flex_segments.application_column_name%type;
25: v_col2 fnd_id_flex_segments.application_column_name%type;
26:

Line 23: v_to_counter fa_deprn_periods.period_counter%type;

19: v_from_date fa_deprn_periods.period_open_date%type;
20: v_from_counter fa_deprn_periods.period_counter%type;
21: v_from_cal_date fa_deprn_periods.calendar_period_open_date%type;
22: v_to_date fa_deprn_periods.period_close_date%type;
23: v_to_counter fa_deprn_periods.period_counter%type;
24: v_col1 fnd_id_flex_segments.application_column_name%type;
25: v_col2 fnd_id_flex_segments.application_column_name%type;
26:
27: CURSOR C_Get_First_Category IS

Line 75: from fa_deprn_periods dp1,

71: nvl(dp2.period_close_date, sysdate),
72: dp2.period_counter,
73: flex1.application_column_name,
74: nvl(flex2.application_column_name, ' ')
75: from fa_deprn_periods dp1,
76: fa_deprn_periods dp2,
77: fnd_id_flexs flexid,
78: fnd_id_flex_segments flex1,
79: fnd_id_flex_segments flex2

Line 76: fa_deprn_periods dp2,

72: dp2.period_counter,
73: flex1.application_column_name,
74: nvl(flex2.application_column_name, ' ')
75: from fa_deprn_periods dp1,
76: fa_deprn_periods dp2,
77: fnd_id_flexs flexid,
78: fnd_id_flex_segments flex1,
79: fnd_id_flex_segments flex2
80: where dp1.book_type_code = C_book_type_code

Line 279: fa_deprn_periods dp2

275: where ds.asset_id = t.asset_id
276: and ds.period_counter =
277: (select max(dp2.period_counter)
278: from fa_deprn_summary ds2,
279: fa_deprn_periods dp2
280: where ds2.asset_id = t.asset_id
281: and ds2.period_counter = dp2.period_counter
282: and ds2.book_type_code = v_book_type_code
283: and dp2.book_type_code = v_book_type_code

Line 297: fa_deprn_periods dp2

293: where ds.asset_id = t.asset_id
294: and ds.period_counter =
295: (select max(dp2.period_counter)
296: from fa_deprn_summary ds2,
297: fa_deprn_periods dp2
298: where ds2.asset_id = t.asset_id
299: and ds2.period_counter = dp2.period_counter
300: and ds2.book_type_code = v_book_type_code
301: and dp2.book_type_code = v_book_type_code

Line 312: fa_deprn_periods dp

308: update ja_au_srw_tax_deprn_tmp t
309: set deprn_amount =
310: (select sum(ds.deprn_amount)
311: from fa_deprn_summary ds,
312: fa_deprn_periods dp
313: where ds.asset_id = t.asset_id
314: and ds.period_counter = dp.period_counter
315: and ds.book_type_code = v_book_type_code
316: and dp.book_type_code = v_book_type_code

Line 446: from FA_DEPRN_PERIODS DP,

442: r.status ,
443: r.date_retired ,
444: nvl(r.gain_loss_amount,0) gain_loss_amount,
445: nvl(r.cost_retired,0) - nvl(r.nbv_retired,0) deprn_retired
446: from FA_DEPRN_PERIODS DP,
447: FA_TRANSACTION_HEADERS TH,
448: FA_RETIREMENTS R,
449: FA_ADDITIONS A,
450: FA_BOOKS B