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_CDE_PKG dependencies on FA_CALENDAR_PERIODS

Line 10: g_pre_period_name fa_calendar_periods.period_name%TYPE;

6:
7: g_tested_use_annual_round BOOLEAN:= FALSE;
8: g_use_annual_round INTEGER:= ROUND_WITH_RESTRICTIONS;
9: primary_cost NUMBER;
10: g_pre_period_name fa_calendar_periods.period_name%TYPE;
11: g_pre_period_ctr fa_calendar_periods.period_num%TYPE;
12: g_pre_fyctr fa_fiscal_year.fiscal_year%TYPE;
13:
14:

Line 11: g_pre_period_ctr fa_calendar_periods.period_num%TYPE;

7: g_tested_use_annual_round BOOLEAN:= FALSE;
8: g_use_annual_round INTEGER:= ROUND_WITH_RESTRICTIONS;
9: primary_cost NUMBER;
10: g_pre_period_name fa_calendar_periods.period_name%TYPE;
11: g_pre_period_ctr fa_calendar_periods.period_num%TYPE;
12: g_pre_fyctr fa_fiscal_year.fiscal_year%TYPE;
13:
14:
15: FUNCTION faxgpr (

Line 1364: from fa_calendar_periods fcp1,

1360: prod_life_complete varchar2(1) := 'N';
1361:
1362: cursor c_prd_flag is
1363: select 'Y'
1364: from fa_calendar_periods fcp1,
1365: fa_calendar_periods fcp2,
1366: fa_book_controls fbc
1367: where to_date (dpr_in.prorate_jdate,'J') BETWEEN fcp1.start_date AND fcp1.end_date
1368: and fbc.book_type_code = dpr_in.book

Line 1365: fa_calendar_periods fcp2,

1361:
1362: cursor c_prd_flag is
1363: select 'Y'
1364: from fa_calendar_periods fcp1,
1365: fa_calendar_periods fcp2,
1366: fa_book_controls fbc
1367: where to_date (dpr_in.prorate_jdate,'J') BETWEEN fcp1.start_date AND fcp1.end_date
1368: and fbc.book_type_code = dpr_in.book
1369: and fcp1.calendar_type = fbc.deprn_calendar

Line 2339: FA_CALENDAR_PERIODS CL,

2335: /* Below query will fetch the Fiscal year and Period number of DPIS */
2336: SELECT fy.fiscal_year,cl.period_num
2337: INTO dpis_fy,dpis_perd_num
2338: FROM FA_BOOKS bk,
2339: FA_CALENDAR_PERIODS CL,
2340: FA_BOOK_CONTROLS BC,
2341: FA_FISCAL_YEAR fy
2342: WHERE bk.asset_id = dpr.asset_id
2343: AND bk.book_type_code = dpr.book

Line 4910: FROM fa_calendar_periods cp, fa_fiscal_year fy

4906: SELECT cp.period_name,
4907: fy.fiscal_year * h_num_per_fy + cp.period_num
4908: INTO perd_name,
4909: l_period_counter
4910: FROM fa_calendar_periods cp, fa_fiscal_year fy
4911: WHERE cp.calendar_type = h_calendar_type AND
4912: cp.period_num = perd_ctr AND
4913: cp.start_date >= fy.start_date AND
4914: cp.end_date <= fy.end_date AND