APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_CALENDAR_PERIODS

Line 3328: FROM fa_calendar_periods pcal,

3324:
3325: begin
3326: SELECT pcal.period_num
3327: INTO h_start_pd_endpp
3328: FROM fa_calendar_periods pcal,
3329: fa_deprn_periods dp
3330: WHERE calendar_type = p_cal
3331: AND dp.book_type_code = h_book
3332: AND dp.fiscal_year = h_current_fiscal_yr

Line 4042: FROM fa_calendar_periods cp

4038:
4039: begin
4040: SELECT cp.period_num
4041: INTO h_work_pdnum
4042: FROM fa_calendar_periods cp
4043: WHERE h_ret_p_date
4044: between cp.start_date and cp.end_date
4045: AND cp.calendar_type = h_d_cal;
4046: EXCEPTION

Line 4089: FROM fa_calendar_periods dcp,

4085: */
4086:
4087: SELECT to_number (to_char (dcp.start_date, 'J'))
4088: INTO h_cpp_jstartdate
4089: FROM fa_calendar_periods dcp,
4090: fa_fiscal_year fy,
4091: fa_book_controls bc
4092: WHERE bc.book_type_code = h_book
4093: AND bc.fiscal_year_name = fy.fiscal_year_name

Line 4112: fa_calendar_periods dcp

4108: BEGIN
4109: SELECT to_number (to_char (bk.prorate_date, 'J'))
4110: INTO h_dpis_pr_jdt
4111: FROM fa_books bk,
4112: fa_calendar_periods dcp
4113: WHERE bk.book_type_code = ret.book
4114: AND transaction_header_id_out is null
4115: AND asset_id = ret.asset_id
4116: AND dcp.calendar_type = h_d_cal

Line 4132: FROM fa_calendar_periods

4128: -- Bug fix 5676896 ends here
4129:
4130: SELECT period_num
4131: INTO h_startpp
4132: FROM fa_calendar_periods
4133: WHERE calendar_type = h_p_cal
4134: AND to_date (h_cpp_jstartdate,'J')
4135: between start_date and end_date;
4136:

Line 4146: FROM fa_calendar_periods

4142: AND dp.period_num = h_stop_pdnum;
4143:
4144: SELECT period_num
4145: INTO h_endpp
4146: FROM fa_calendar_periods
4147: WHERE calendar_type = h_p_cal
4148: AND to_date (h_cpp_jenddate,'J')
4149: between start_date and end_date;
4150: