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_GAINLOSS_UPD_PKG dependencies on FA_FISCAL_YEAR

Line 2266: the lenght of FA_FISCAL_YEAR.FISCAL_YEAR_NAME varchar2(30) */

2262: dpy_begin integer;
2263: dpp_begin integer;
2264: --fy_name varchar2(20); -- bug 2719715
2265: /* the length of fy_name should be equal to
2266: the lenght of FA_FISCAL_YEAR.FISCAL_YEAR_NAME varchar2(30) */
2267: --fy_name varchar2(30); -- bug 2719715
2268: fy_name FA_FISCAL_YEAR.FISCAL_YEAR_NAME%TYPE;
2269:
2270: temp_start_pp number;

Line 2268: fy_name FA_FISCAL_YEAR.FISCAL_YEAR_NAME%TYPE;

2264: --fy_name varchar2(20); -- bug 2719715
2265: /* the length of fy_name should be equal to
2266: the lenght of FA_FISCAL_YEAR.FISCAL_YEAR_NAME varchar2(30) */
2267: --fy_name varchar2(30); -- bug 2719715
2268: fy_name FA_FISCAL_YEAR.FISCAL_YEAR_NAME%TYPE;
2269:
2270: temp_start_pp number;
2271: source_type_code varchar2(30);
2272: prev_dist_id number;

Line 2888: -- Bug 9576503 : Use join with fa_fiscal_year to make sure of same year

2884:
2885: if p_pers_per_yr = 365 then
2886: if h_i = h_start_pdnum then
2887:
2888: -- Bug 9576503 : Use join with fa_fiscal_year to make sure of same year
2889: select fcp2.period_num + 1 - fcp1.period_num, fcp3.end_date + 1 - fcp3.start_date
2890: into h_ret_pd_nums, h_tot_days_in_mon
2891: from fa_calendar_periods fcp1,
2892: fa_calendar_periods fcp2,

Line 2894: fa_fiscal_year fy

2890: into h_ret_pd_nums, h_tot_days_in_mon
2891: from fa_calendar_periods fcp1,
2892: fa_calendar_periods fcp2,
2893: fa_calendar_periods fcp3,
2894: fa_fiscal_year fy
2895: where fcp1.calendar_type = p_cal
2896: and bk.ret_prorate_date between fcp1.start_date and fcp1.end_date
2897: and fcp2.calendar_type = fcp1.calendar_type
2898: and fcp3.calendar_type = d_cal

Line 2912: fa_fiscal_year fy

2908: -- Bug 9411825 : Removed the join between cp.start_date and bk.ret_prorate_date
2909: select cp.end_date + 1 - cp.start_date
2910: into h_tot_days_in_mon
2911: from fa_calendar_periods cp,
2912: fa_fiscal_year fy
2913: where cp.calendar_type = d_cal
2914: and cp.period_num = h_i
2915: and fy.fiscal_year_name = h_fiscal_year_name
2916: and bk.ret_prorate_date between fy.start_date and fy.end_date

Line 2947: --Bug#9739739:Changed query to use fa_fiscal_year

2943: -- added the if condition
2944: -- Added the below logic so that the daily prorate conv can be taken
2945: -- into account during retirement
2946: -- Also changed the logic of temp_deprn_tot
2947: --Bug#9739739:Changed query to use fa_fiscal_year
2948: begin
2949: select 'Y'
2950: into l_same_year
2951: from fa_transaction_headers th,

Line 2952: fa_fiscal_year fy,

2948: begin
2949: select 'Y'
2950: into l_same_year
2951: from fa_transaction_headers th,
2952: fa_fiscal_year fy,
2953: fa_deprn_periods dp
2954: where th.asset_id = h_asset_id
2955: and th.book_type_code = h_book
2956: and dp.book_type_code = th.book_type_code

Line 3029: fa_fiscal_year fy,

3025: begin
3026: select 'Y'
3027: into l_same_deprn_start_yr
3028: from fa_transaction_headers th,
3029: fa_fiscal_year fy,
3030: fa_deprn_periods dp
3031: where th.asset_id = h_asset_id
3032: and th.book_type_code = h_book
3033: and dp.book_type_code = th.book_type_code

Line 3127: fa_fiscal_year ffy1,

3123: into h_ret_pd_nums, h_tot_days_in_mon
3124: from fa_calendar_periods fcp1,
3125: fa_calendar_periods fcp2,
3126: fa_calendar_periods fcp3,
3127: fa_fiscal_year ffy1,
3128: fa_fiscal_year ffy3
3129: where fcp1.calendar_type = p_cal
3130: and bk.ret_prorate_date between fcp1.start_date and fcp1.end_date
3131: and fcp2.calendar_type = fcp1.calendar_type

Line 3128: fa_fiscal_year ffy3

3124: from fa_calendar_periods fcp1,
3125: fa_calendar_periods fcp2,
3126: fa_calendar_periods fcp3,
3127: fa_fiscal_year ffy1,
3128: fa_fiscal_year ffy3
3129: where fcp1.calendar_type = p_cal
3130: and bk.ret_prorate_date between fcp1.start_date and fcp1.end_date
3131: and fcp2.calendar_type = fcp1.calendar_type
3132: and fcp3.calendar_type = d_cal

Line 3146: fa_fiscal_year fy

3142:
3143: select cp.end_date + 1 - cp.start_date
3144: into h_tot_days_in_mon
3145: from fa_calendar_periods cp,
3146: fa_fiscal_year fy
3147: where cp.calendar_type = d_cal
3148: and cp.period_num = h_i
3149: and fy.fiscal_year_name = h_fiscal_year_name
3150: and bk.ret_prorate_date between fy.start_date and fy.end_date

Line 3180: fa_fiscal_year ffy

3176: select 'Y'
3177: into l_same_year
3178: from fa_transaction_headers th,
3179: fa_deprn_periods dp,
3180: fa_fiscal_year ffy
3181: where th.asset_id = h_asset_id
3182: and th.book_type_code = h_book
3183: and th.transaction_type_code = 'ADDITION'
3184: and dp.book_type_code = th.book_type_code

Line 3218: fa_fiscal_year ffy

3214: to_char(trunc(th.transaction_date_entered),'J')
3215: into l_tot_days
3216: from fa_transaction_headers th,
3217: fa_deprn_periods dp,
3218: fa_fiscal_year ffy
3219: where th.asset_id = h_asset_id
3220: and th.book_type_code = h_book
3221: and th.transaction_type_code = 'ADDITION'
3222: and dp.book_type_code = th.book_type_code

Line 3359: , fa_fiscal_year fy1

3355:
3356: select h_pc - (fy1.fiscal_year * pds_per_year + cp1.period_num)
3357: into l_num_d_periods
3358: from fa_calendar_periods cp1
3359: , fa_fiscal_year fy1
3360: where cp1.calendar_type = d_cal
3361: and bk.prorate_date between cp1.start_Date and cp1.end_date
3362: and fy1.fiscal_year_name = h_fiscal_year_name
3363: and bk.prorate_date between fy1.start_Date and fy1.end_date;

Line 4256: FROM FA_FISCAL_YEAR fy1,

4252: 'TABLE', 2,
4253: 'FLAT', 3)
4254: INTO h_same_fy, h_depr_first_year_ret,
4255: h_dwacq, h_rate_source_rule
4256: FROM FA_FISCAL_YEAR fy1,
4257: FA_FISCAL_YEAR fy2,
4258: FA_BOOKS bk,
4259: FA_RETIREMENTS rt,
4260: FA_CONVENTION_TYPES ctype,

Line 4257: FA_FISCAL_YEAR fy2,

4253: 'FLAT', 3)
4254: INTO h_same_fy, h_depr_first_year_ret,
4255: h_dwacq, h_rate_source_rule
4256: FROM FA_FISCAL_YEAR fy1,
4257: FA_FISCAL_YEAR fy2,
4258: FA_BOOKS bk,
4259: FA_RETIREMENTS rt,
4260: FA_CONVENTION_TYPES ctype,
4261: FA_METHODS mt,

Line 4291: FROM FA_FISCAL_YEAR fy1,

4287: 'TABLE', 2,
4288: 'FLAT', 3)
4289: INTO h_same_fy, h_depr_first_year_ret,
4290: h_dwacq, h_rate_source_rule
4291: FROM FA_FISCAL_YEAR fy1,
4292: FA_FISCAL_YEAR fy2,
4293: FA_MC_BOOKS bk,
4294: FA_MC_RETIREMENTS rt,
4295: FA_CONVENTION_TYPES ctype,

Line 4292: FA_FISCAL_YEAR fy2,

4288: 'FLAT', 3)
4289: INTO h_same_fy, h_depr_first_year_ret,
4290: h_dwacq, h_rate_source_rule
4291: FROM FA_FISCAL_YEAR fy1,
4292: FA_FISCAL_YEAR fy2,
4293: FA_MC_BOOKS bk,
4294: FA_MC_RETIREMENTS rt,
4295: FA_CONVENTION_TYPES ctype,
4296: FA_METHODS mt,

Line 5263: from fa_fiscal_year fy,

5259:
5260: begin
5261: select fy.fiscal_year
5262: into l_first_fiscal_year
5263: from fa_fiscal_year fy,
5264: fa_book_controls bc,
5265: fa_books bks
5266: where bc.book_type_code = ret.book
5267: and bc.fiscal_year_name = fy.fiscal_year_name

Line 5412: fa_fiscal_year fy,

5408:
5409: SELECT to_number (to_char (dcp.start_date, 'J'))
5410: INTO h_cpp_jstartdate
5411: FROM fa_calendar_periods dcp,
5412: fa_fiscal_year fy,
5413: fa_book_controls bc
5414: WHERE bc.book_type_code = h_book
5415: AND bc.fiscal_year_name = fy.fiscal_year_name
5416: AND dcp.calendar_type = h_d_cal