eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_TRACK_MEMBER_PVT dependencies on FA_FISCAL_YEAR

Line 4467: from fa_fiscal_year

4463: from fa_book_controls
4464: where book_type_code=h_book_type_code;
4465:
4466: select fiscal_year into h_trans_fiscal_year
4467: from fa_fiscal_year
4468: where fiscal_year_name = h_fiscal_year_name
4469: and start_date <= l_transaction_date_entered
4470: and end_date >= l_transaction_date_entered;
4471:

Line 6447: FA_FISCAL_YEAR FY

6443: select TH.TRANSACTION_HEADER_ID
6444: from FA_TRANSACTION_HEADERS TH,
6445: FA_TRANSACTION_HEADERS TH1,
6446: FA_CALENDAR_PERIODS DP,
6447: FA_FISCAL_YEAR FY
6448: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6449: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6450: and TH.asset_id = p_member_asset_id
6451: and TH.transaction_type_code not in ('TRANSFER OUT', 'TRANSFER IN', 'TRANSFER', 'TRANSFER IN/VOID',

Line 6545: from FA_FISCAL_YEAR FY,

6541: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6542: end if;
6543:
6544: select DP.end_date into h_transaction_date
6545: from FA_FISCAL_YEAR FY,
6546: FA_CALENDAR_PERIODS DP
6547: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6548: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6549: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 6823: from FA_FISCAL_YEAR FY,

6819: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6820: end if;
6821:
6822: select DP.end_date into h_transaction_date
6823: from FA_FISCAL_YEAR FY,
6824: FA_CALENDAR_PERIODS DP
6825: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6826: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6827: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 7157: FA_FISCAL_YEAR FY,

7153: --* Get all transaction headers exists until the specified period
7154: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number,p_member_asset_id number) is
7155: select TH.TRANSACTION_HEADER_ID
7156: from FA_TRANSACTION_HEADERS TH,
7157: FA_FISCAL_YEAR FY,
7158: FA_CALENDAR_PERIODS DP
7159: where DP.calendar_type = h_calendar_type
7160: and DP.period_num = p_period_num
7161: and FY.fiscal_year_name = h_fiscal_year_name

Line 7220: FA_FISCAL_YEAR FY

7216: and exists
7217: (select TH1.TRANSACTION_HEADER_ID
7218: from FA_TRANSACTION_HEADERS TH1,
7219: FA_CALENDAR_PERIODS DP1,
7220: FA_FISCAL_YEAR FY
7221: where TH1.book_type_code = BK.book_type_code
7222: and DP1.calendar_type = h_calendar_type
7223: and DP1.period_num = p_period_num
7224: and FY.fiscal_year_name = h_fiscal_year_name

Line 7245: FA_FISCAL_YEAR FY

7241: and exists
7242: (select TH1.TRANSACTION_HEADER_ID
7243: from FA_TRANSACTION_HEADERS TH1,
7244: FA_CALENDAR_PERIODS DP1,
7245: FA_FISCAL_YEAR FY
7246: where TH1.book_type_code = BK.book_type_code
7247: and DP1.calendar_type = h_calendar_type
7248: and DP1.period_num = p_period_num
7249: and FY.fiscal_year_name = h_fiscal_year_name

Line 8553: from fa_fiscal_year FY,

8549: --* Cursor to get period counter from date
8550: cursor GET_FY_PERDNUM(p_date date) is
8551: select FY.fiscal_year,
8552: DP.period_num
8553: from fa_fiscal_year FY,
8554: fa_calendar_periods DP
8555: where FY.fiscal_year_name = h_fiscal_year_name
8556: and DP.calendar_type = h_deprn_calendar
8557: and DP.end_date <= FY.end_date

Line 8590: FA_FISCAL_YEAR FY

8586: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8587: from fa_books bk_in,
8588: FA_TRANSACTION_HEADERS TH1,
8589: FA_CALENDAR_PERIODS DP1,
8590: FA_FISCAL_YEAR FY
8591: where TH1.book_type_code = BK_in.book_type_code
8592: and DP1.calendar_type = h_deprn_calendar
8593: and DP1.period_num = p_period_num
8594: and FY.fiscal_year_name = h_fiscal_year_name

Line 8612: FA_FISCAL_YEAR FY

8608: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8609: from fa_books bk_in,
8610: FA_TRANSACTION_HEADERS TH1,
8611: FA_CALENDAR_PERIODS DP1,
8612: FA_FISCAL_YEAR FY
8613: where TH1.book_type_code = BK_in.book_type_code
8614: and DP1.calendar_type = h_deprn_calendar
8615: and DP1.period_num = p_period_num
8616: and FY.fiscal_year_name = h_fiscal_year_name

Line 8630: FA_FISCAL_YEAR FY2

8626: select distinct bk_in2.asset_id, bk_in2.book_type_code
8627: from fa_books bk_in2,
8628: FA_TRANSACTION_HEADERS TH2,
8629: FA_CALENDAR_PERIODS DP2,
8630: FA_FISCAL_YEAR FY2
8631: where TH2.book_type_code = BK_in2.book_type_code
8632: and DP2.calendar_type = h_deprn_calendar
8633: and DP2.period_num = p_period_num
8634: and FY2.fiscal_year_name = h_fiscal_year_name

Line 8670: FA_FISCAL_YEAR FY

8666: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8667: from fa_mc_books bk_in,
8668: FA_TRANSACTION_HEADERS TH1,
8669: FA_CALENDAR_PERIODS DP1,
8670: FA_FISCAL_YEAR FY
8671: where TH1.book_type_code = BK_in.book_type_code
8672: and DP1.calendar_type = h_deprn_calendar
8673: and DP1.period_num = p_period_num
8674: and FY.fiscal_year_name = h_fiscal_year_name

Line 8693: FA_FISCAL_YEAR FY

8689: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8690: from fa_mc_books bk_in,
8691: FA_TRANSACTION_HEADERS TH1,
8692: FA_CALENDAR_PERIODS DP1,
8693: FA_FISCAL_YEAR FY
8694: where TH1.book_type_code = BK_in.book_type_code
8695: and DP1.calendar_type = h_deprn_calendar
8696: and DP1.period_num = p_period_num
8697: and FY.fiscal_year_name = h_fiscal_year_name

Line 8712: FA_FISCAL_YEAR FY2

8708: select distinct bk_in2.asset_id, bk_in2.book_type_code
8709: from fa_mc_books bk_in2,
8710: FA_TRANSACTION_HEADERS TH2,
8711: FA_CALENDAR_PERIODS DP2,
8712: FA_FISCAL_YEAR FY2
8713: where TH2.book_type_code = BK_in2.book_type_code
8714: and DP2.calendar_type = h_deprn_calendar
8715: and DP2.period_num = p_period_num
8716: and FY2.fiscal_year_name = h_fiscal_year_name

Line 8768: FA_FISCAL_YEAR FY

8764: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number, p_member_asset_id number) is
8765: select TH.TRANSACTION_HEADER_ID, TH.TRANSACTION_TYPE_CODE,TH.TRANSACTION_KEY --Bug 8484007
8766: from FA_TRANSACTION_HEADERS TH,
8767: FA_CALENDAR_PERIODS DP,
8768: FA_FISCAL_YEAR FY
8769: where DP.calendar_type = h_deprn_calendar
8770: and DP.period_num = p_period_num
8771: and FY.fiscal_year_name = h_fiscal_year_name
8772: and FY.fiscal_year = p_fiscal_year

Line 11652: from fa_calendar_periods cp, fa_fiscal_year fy

11648: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
11649:
11650: select cp.period_name
11651: into h_period_name
11652: from fa_calendar_periods cp, fa_fiscal_year fy
11653: where cp.calendar_type = h_calendar_type and
11654: cp.period_num = p_period_num and
11655: cp.start_date >= fy.start_date and
11656: cp.end_date <= fy.end_date and