APPS.FA_GAINLOSS_RET_PKG dependencies on FA_CALENDAR_PERIODS

Line 115: fa_calendar_periods cp,

111: if cpdnum_set = 'N' then
112: SELECT to_number (to_char (cp.start_date, 'J'))
113: INTO h_cpp_jstartdate
114: FROM fa_deprn_periods dp,
115: fa_calendar_periods cp,
116: fa_fiscal_year fy
117: WHERE cp.calendar_type = h_d_cal
118: AND fy.fiscal_year_name = h_fiscal_year_name
119: AND fy.fiscal_year = h_cpd_fy

Line 140: FROM fa_calendar_periods

136: -- Added the condition to check for daily prorate assets
137: if cpdnum_set = 'N' then
138: SELECT period_num
139: INTO h_startpp
140: FROM fa_calendar_periods
141: WHERE calendar_type = h_p_cal
142: AND to_date (h_cpp_jstartdate,'J')
143: between start_date and end_date;
144: else

Line 159: FROM fa_calendar_periods

155:
156: begin
157: SELECT period_num
158: INTO h_endpp
159: FROM fa_calendar_periods
160: WHERE calendar_type = h_p_cal
161: AND trunc(h_ret_p_date)
162: between start_date and end_date;
163: EXCEPTION

Line 411: from fa_calendar_periods fcp1,

407: prd_flag varchar2(1);
408: cpdnum_set varchar2(1);
409: cursor c_prd_flag is
410: select 'Y'
411: from fa_calendar_periods fcp1,
412: fa_calendar_periods fcp2,
413: fa_book_controls fbc
414: where to_date (dpr.prorate_jdate,'J') BETWEEN fcp1.start_date and fcp1.end_date
415: and fbc.book_type_code = dpr.book

Line 412: fa_calendar_periods fcp2,

408: cpdnum_set varchar2(1);
409: cursor c_prd_flag is
410: select 'Y'
411: from fa_calendar_periods fcp1,
412: fa_calendar_periods fcp2,
413: fa_book_controls fbc
414: where to_date (dpr.prorate_jdate,'J') BETWEEN fcp1.start_date and fcp1.end_date
415: and fbc.book_type_code = dpr.book
416: and fcp1.calendar_type = fbc.deprn_calendar

Line 536: FROM fa_calendar_periods facp

532: cpdnum_set := 'Y';
533:
534: SELECT facp.period_num
535: INTO h_cpdnum
536: FROM fa_calendar_periods facp
537: WHERE facp.calendar_type = bk.p_cal
538: AND ( facp.start_date = bk.prorate_date
539: OR facp.end_date = bk.prorate_date );
540: else

Line 611: from fa_calendar_periods cp

607:
608: begin
609: select period_num
610: into h_end_pd
611: from fa_calendar_periods cp
612: where calendar_type = dpr.calendar_type
613: and bk.ret_prorate_date between start_date and end_date;
614:
615: select fiscal_year