DBA Data[Home] [Help]

APPS.FA_GAINLOSS_UND_PKG dependencies on FA_TRANSACTION_HEADERS

Line 53: FROM fa_transaction_headers

49: l_group_thid number(15);
50:
51: CURSOR c_get_group_thid IS
52: SELECT transaction_header_id
53: FROM fa_transaction_headers
54: WHERE member_transaction_header_id = ret.th_id_in
55: AND asset_id = bk.group_asset_id
56: AND book_type_code = ret.book;
57:

Line 582: FA_TRANSACTION_HEADERS TH,

578: SELECT count(*)
579: INTO
580: h_is_prior_period
581: FROM
582: FA_TRANSACTION_HEADERS TH,
583: FA_BOOK_CONTROLS BC,
584: FA_DEPRN_PERIODS DP,
585: FA_DEPRN_PERIODS DP_NOW
586: WHERE

Line 1175: fa_transaction_headers th

1171: dh_new.distribution_id
1172: FROM fa_distribution_history dh_old,
1173: fa_distribution_history dh_new,
1174: fa_book_controls bc,
1175: fa_transaction_headers th
1176: WHERE th.transaction_header_id = h_rethdrout
1177: and th.asset_id = h_asset_id
1178: and th.book_type_code = h_book
1179: and bc.book_type_code = th.book_type_code

Line 2582: FROM fa_transaction_headers

2578: l_group_thid number(15);
2579:
2580: CURSOR c_get_group_thid IS
2581: SELECT transaction_header_id
2582: FROM fa_transaction_headers
2583: WHERE member_transaction_header_id = ret.th_id_in
2584: AND asset_id = bk.group_asset_id
2585: AND book_type_code = ret.book;
2586: