APPS.FA_GAINLOSS_RET_PKG dependencies on FA_CALENDAR_PERIODS

Line 851: fa_calendar_periods cp,

847: if cpdnum_set = 'N' then
848: SELECT to_number (to_char (cp.start_date, 'J'))
849: INTO h_cpp_jstartdate
850: FROM fa_deprn_periods dp,
851: fa_calendar_periods cp,
852: fa_fiscal_year fy
853: WHERE cp.calendar_type = h_d_cal
854: AND fy.fiscal_year_name = h_fiscal_year_name
855: AND fy.fiscal_year = h_cpd_fy

Line 876: FROM fa_calendar_periods

872: -- Added the condition to check for daily prorate assets
873: if cpdnum_set = 'N' then
874: SELECT period_num
875: INTO h_startpp
876: FROM fa_calendar_periods
877: WHERE calendar_type = h_p_cal
878: AND to_date (h_cpp_jstartdate,'J')
879: between start_date and end_date;
880: end if;

Line 892: FROM fa_calendar_periods

888:
889: begin
890: SELECT period_num
891: INTO h_endpp
892: FROM fa_calendar_periods
893: WHERE calendar_type = h_p_cal
894: AND trunc(h_ret_p_date)
895: between start_date and end_date;
896: EXCEPTION

Line 1429: from fa_calendar_periods fcp1,

1425: prd_flag varchar2(1);
1426: cpdnum_set varchar2(1);
1427: cursor c_prd_flag is
1428: select 'Y'
1429: from fa_calendar_periods fcp1,
1430: fa_calendar_periods fcp2,
1431: fa_book_controls fbc
1432: where to_date (dpr.prorate_jdate,'J') BETWEEN fcp1.start_date and fcp1.end_date
1433: and fbc.book_type_code = dpr.book

Line 1430: fa_calendar_periods fcp2,

1426: cpdnum_set varchar2(1);
1427: cursor c_prd_flag is
1428: select 'Y'
1429: from fa_calendar_periods fcp1,
1430: fa_calendar_periods fcp2,
1431: fa_book_controls fbc
1432: where to_date (dpr.prorate_jdate,'J') BETWEEN fcp1.start_date and fcp1.end_date
1433: and fbc.book_type_code = dpr.book
1434: and fcp1.calendar_type = fbc.deprn_calendar

Line 1579: FROM fa_calendar_periods facp

1575: cpdnum_set := 'Y';
1576:
1577: SELECT facp.period_num
1578: INTO h_cpdnum
1579: FROM fa_calendar_periods facp
1580: WHERE facp.calendar_type = bk.p_cal
1581: AND ( facp.start_date = bk.prorate_date
1582: OR facp.end_date = bk.prorate_date );
1583: else