APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_DEPRN_PERIODS

Line 139: fa_deprn_periods dp,

135: th1.date_effective
136: from fa_transaction_headers th1,
137: fa_transaction_headers th2,
138: fa_book_controls bc,
139: fa_deprn_periods dp,
140: fa_trx_references tr,
141: fa_lookups_tl lk1,
142: fa_lookups_tl lk2,
143: gl_period_statuses ps

Line 2540: fa_deprn_periods dp,

2536: ), 'OTHER') je_category_name,
2537: th.date_effective
2538: from fa_transaction_headers th,
2539: fa_asset_history ah,
2540: fa_deprn_periods dp,
2541: gl_sets_of_books glsob,
2542: fa_book_controls bc,
2543: fa_lookups_tl lk,
2544: gl_period_statuses ps

Line 2616: fa_deprn_periods dp,

2612: 'UNIT ADJUSTMENT', bc.je_transfer_category),
2613: 'OTHER') je_category_name,
2614: th.date_effective
2615: from fa_transaction_headers th,
2616: fa_deprn_periods dp,
2617: gl_sets_of_books glsob,
2618: fa_book_controls bc,
2619: fa_lookups_tl lk,
2620: gl_period_statuses ps

Line 4536: fa_deprn_periods dp,

4532: dp.period_counter period_counter,
4533: th.asset_id asset_id
4534: from fa_transaction_headers th,
4535: fa_book_controls bc,
4536: fa_deprn_periods dp,
4537: gl_period_statuses ps,
4538: fa_lookups_tl lk,
4539: fa_asset_history ah
4540: where th.rowid between p_start_rowid and p_end_rowid

Line 4618: fa_deprn_periods dp,

4614: dp.period_counter period_counter,
4615: th.asset_id asset_id
4616: from fa_transaction_headers th,
4617: fa_book_controls bc,
4618: fa_deprn_periods dp,
4619: gl_period_statuses ps,
4620: fa_lookups_tl lk
4621: where th.rowid between p_start_rowid and p_end_rowid
4622: and th.member_transaction_header_id is null

Line 6785: select /*+ ordered leading(dp) index(dp fa_deprn_periods_u3) rowid(ds) index(ah fa_asset_history_n2) */

6781: null, -- product_rule_version
6782: c_application_id, -- upg_source_application_id
6783: null -- upg_valid_flag
6784: )
6785: select /*+ ordered leading(dp) index(dp fa_deprn_periods_u3) rowid(ds) index(ah fa_asset_history_n2) */
6786: ds.asset_id asset_id,
6787: ds.book_type_code book_type_code,
6788: bc.set_of_books_id set_of_books_id,
6789: ds.deprn_run_date transaction_date_entered,

Line 6809: fa_deprn_periods dp,

6805: je_category_name
6806: from fa_deprn_summary ds,
6807: fa_book_controls bc,
6808: gl_sets_of_books glsob,
6809: fa_deprn_periods dp,
6810: fa_asset_history ah,
6811: fa_category_books cb
6812: where ds.rowid between p_start_rowid and p_end_rowid
6813: and ds.book_type_code = bc.book_type_code

Line 7119: select /*+ ordered leading(dp) index(dp fa_deprn_periods_u3) rowid(ds) index(ah fa_asset_history_n2) */

7115: null, -- product_rule_version
7116: c_application_id, -- upg_source_application_id
7117: null -- upg_valid_flag
7118: )
7119: select /*+ ordered leading(dp) index(dp fa_deprn_periods_u3) rowid(ds) index(ah fa_asset_history_n2) */
7120: ds.asset_id asset_id,
7121: ds.book_type_code book_type_code,
7122: bc.set_of_books_id set_of_books_id,
7123: ds.deprn_run_date transaction_date_entered,

Line 7143: fa_deprn_periods dp,

7139: je_category_name
7140: from fa_deprn_summary ds,
7141: fa_book_controls bc,
7142: gl_sets_of_books glsob,
7143: fa_deprn_periods dp,
7144: fa_asset_history ah,
7145: fa_category_books cb,
7146: gl_period_statuses ps
7147: where ds.rowid between p_start_rowid and p_end_rowid

Line 8228: fa_deprn_periods dp,

8224: df.tax_period_counter,
8225: glsob.currency_code,
8226: nvl (bc.je_deferred_deprn_category, 'OTHER') je_category_name
8227: from fa_deferred_deprn df,
8228: fa_deprn_periods dp,
8229: gl_sets_of_books glsob,
8230: fa_book_controls bc,
8231: fa_lookups_tl lk_de,
8232: fa_lookups_tl lk_dr,