APPS.FA_GROUP_RECLASS2_PVT dependencies on FA_DEPRN_PERIODS

Line 1886: fa_deprn_periods dp1

1882: --* Cursor to populate the member level amounts
1883: cursor MEM_EXP_RESERVE is
1884: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
1885: from fa_deprn_summary ds1,
1886: fa_deprn_periods dp1
1887: where ds1.book_type_code = h_book_type_code
1888: and ds1.asset_id = h_member_asset_id
1889: and dp1.book_type_code = ds1.book_type_Code
1890: and dp1.period_counter = ds1.period_counter

Line 1924: fa_deprn_periods dp1,

1920: and ret.asset_id = h_member_asset_id
1921: and ret.transaction_header_id_in in
1922: (select th1.transaction_header_id
1923: from fa_transaction_headers th1,
1924: fa_deprn_periods dp1,
1925: fa_deprn_periods dp3
1926: where th1.asset_id = ret.asset_id
1927: and dp1.book_type_code = h_book_type_code
1928: and dp1.fiscal_year =

Line 1925: fa_deprn_periods dp3

1921: and ret.transaction_header_id_in in
1922: (select th1.transaction_header_id
1923: from fa_transaction_headers th1,
1924: fa_deprn_periods dp1,
1925: fa_deprn_periods dp3
1926: where th1.asset_id = ret.asset_id
1927: and dp1.book_type_code = h_book_type_code
1928: and dp1.fiscal_year =
1929: (select dp2.fiscal_year

Line 1930: from fa_deprn_periods dp2

1926: where th1.asset_id = ret.asset_id
1927: and dp1.book_type_code = h_book_type_code
1928: and dp1.fiscal_year =
1929: (select dp2.fiscal_year
1930: from fa_deprn_periods dp2
1931: where dp2.book_type_code = dp1.book_type_code
1932: and dp2.period_Counter = h_period_counter - 1)
1933: and dp1.period_num = 1
1934: and dp3.book_type_code = dp1.book_type_code

Line 1949: fa_deprn_periods dp1,

1945: and ret.set_of_books_id = h_set_of_books_id
1946: and ret.transaction_header_id_in in
1947: (select th1.transaction_header_id
1948: from fa_transaction_headers th1,
1949: fa_deprn_periods dp1,
1950: fa_deprn_periods dp3
1951: where th1.asset_id = ret.asset_id
1952: and dp1.book_type_code = h_book_type_code
1953: and dp1.fiscal_year =

Line 1950: fa_deprn_periods dp3

1946: and ret.transaction_header_id_in in
1947: (select th1.transaction_header_id
1948: from fa_transaction_headers th1,
1949: fa_deprn_periods dp1,
1950: fa_deprn_periods dp3
1951: where th1.asset_id = ret.asset_id
1952: and dp1.book_type_code = h_book_type_code
1953: and dp1.fiscal_year =
1954: (select dp2.fiscal_year

Line 1955: from fa_deprn_periods dp2

1951: where th1.asset_id = ret.asset_id
1952: and dp1.book_type_code = h_book_type_code
1953: and dp1.fiscal_year =
1954: (select dp2.fiscal_year
1955: from fa_deprn_periods dp2
1956: where dp2.book_type_code = dp1.book_type_code
1957: and dp2.period_Counter = h_period_counter - 1)
1958: and dp1.period_num = 1
1959: and dp3.book_type_code = dp1.book_type_code

Line 1976: from fa_deprn_periods dp1,

1972: and adj.adjustment_type = 'RESERVE'
1973: and adj.source_type_code = 'ADJUSTMENT'
1974: and adj.period_counter_adjusted in
1975: (select dp2.period_counter
1976: from fa_deprn_periods dp1,
1977: fa_deprn_periods dp2
1978: where dp1.book_type_code = adj.book_type_code
1979: and dp1.period_counter = h_period_counter - 1
1980: and dp2.book_type_code = dp1.book_type_code

Line 1977: fa_deprn_periods dp2

1973: and adj.source_type_code = 'ADJUSTMENT'
1974: and adj.period_counter_adjusted in
1975: (select dp2.period_counter
1976: from fa_deprn_periods dp1,
1977: fa_deprn_periods dp2
1978: where dp1.book_type_code = adj.book_type_code
1979: and dp1.period_counter = h_period_counter - 1
1980: and dp2.book_type_code = dp1.book_type_code
1981: and dp2.fiscal_year = dp1.fiscal_year

Line 2038: from fa_deprn_periods

2034: -- Get Reserve Amount between member's DPIS and current period -- For Source Group Reserve
2035: if p_mrc_sob_type_code <> 'R' then
2036:
2037: select fiscal_year into h_cur_fiscal_year
2038: from fa_deprn_periods
2039: where book_type_code = h_book_type_code
2040: and period_counter = h_period_counter;
2041:
2042: open MEM_EXP_RESERVE;