[Home] [Help]
83: ***********************************************************************/
84: IS
85: SELECT fcp.end_date
86: FROM fa_calendar_periods fcp
87: , fa_calendar_types fct
88: , fa_book_controls fbc
89: WHERE fbc.book_type_code = p_book_type_code
90: AND fcp.calendar_type = fct.calendar_type
91: AND fcp.calendar_type = fbc.deprn_calendar
124: ***********************************************************************/
125: IS
126: SELECT LAST_DAY (ADD_MONTHS (fcp.end_date, p_counter))
127: FROM fa_calendar_periods fcp
128: , fa_calendar_types fct
129: , fa_book_controls fbc
130: WHERE fbc.book_type_code = p_book_type_code
131: AND fcp.calendar_type = fct.calendar_type
132: AND fcp.calendar_type = fbc.deprn_calendar
210: SELECT cp1.period_name
211: FROM fa_calendar_periods cp
212: , fa_fiscal_year fy
213: , fa_book_controls fb
214: , fa_calendar_types fc
215: , fa_calendar_periods cp1
216: WHERE cp.period_name = p_start_period
217: AND cp.calendar_type = fb.deprn_calendar
218: AND fb.book_type_code = p_book_type
257: ***********************************************************************/
258: IS
259: SELECT fcp.period_name
260: FROM fa_calendar_periods fcp
261: , fa_calendar_types fct
262: , fa_book_controls fbc
263: WHERE fbc.book_type_code = p_book_type_code
264: AND fcp.calendar_type = fct.calendar_type
265: AND fcp.calendar_type = fbc.deprn_calendar
447: THEN
448: l_sql_query :=
449: 'SELECT FCP.period_name
450: FROM fa_calendar_periods FCP
451: , fa_calendar_types FCT
452: , fa_book_controls FBC
453: WHERE FBC.book_type_code = '''
454: || p_book_type_code
455: || '''
581:
582: l_sql_query2 :=
583: 'SELECT FCP.period_name
584: FROM fa_calendar_periods FCP
585: , fa_calendar_types FCT
586: , fa_book_controls FBC
587: WHERE FBC.book_type_code = '''
588: || p_book_type_code
589: || '''
877: FROM fa_books fb
878: , fa_book_controls fbc
879: ,fa_calendar_periods cp
880: , fa_fiscal_year fy
881: , fa_calendar_types fct
882: , fa_additions fa
883: , fa_distribution_history fdh
884: , fa_locations_kfv flk
885: , gl_code_combinations_kfv gcck
982: SELECT cp1.period_name
983: FROM fa_calendar_periods cp
984: , fa_fiscal_year fy
985: , fa_book_controls fb
986: , fa_calendar_types fc
987: , fa_calendar_periods cp1
988: WHERE cp.period_name = p_start_period
989: AND cp.calendar_type = fb.deprn_calendar
990: AND fb.book_type_code = p_book_type
1073: ***********************************************************************/
1074: IS
1075: SELECT LAST_DAY (ADD_MONTHS (fcp.end_date, p_counter))
1076: FROM fa_calendar_periods fcp
1077: , fa_calendar_types fct
1078: , fa_book_controls fbc
1079: WHERE fbc.book_type_code = p_book_type_code
1080: AND fcp.calendar_type = fct.calendar_type
1081: AND fcp.calendar_type = fbc.deprn_calendar
1113: ***********************************************************************/
1114: IS
1115: SELECT fcp.period_name
1116: FROM fa_calendar_periods fcp
1117: , fa_calendar_types fct
1118: , fa_book_controls fbc
1119: WHERE fbc.book_type_code = p_book_type_code
1120: AND fcp.calendar_type = fct.calendar_type
1121: AND fcp.calendar_type = fbc.deprn_calendar
1577: SELECT cp1.period_name
1578: FROM fa_calendar_periods cp
1579: , fa_fiscal_year fy
1580: , fa_book_controls fb
1581: , fa_calendar_types fc
1582: , fa_calendar_periods cp1
1583: WHERE cp.period_name = p_start_period
1584: AND cp.calendar_type = fb.deprn_calendar
1585: AND fb.book_type_code = p_book_type
1670: ***********************************************************************/
1671: IS
1672: SELECT LAST_DAY (ADD_MONTHS (fcp.end_date, p_counter))
1673: FROM fa_calendar_periods fcp
1674: , fa_calendar_types fct
1675: , fa_book_controls fbc
1676: WHERE fbc.book_type_code = p_book_type_code
1677: AND fcp.calendar_type = fct.calendar_type
1678: AND fcp.calendar_type = fbc.deprn_calendar
1712: ***********************************************************************/
1713: IS
1714: SELECT LAST_DAY (ADD_MONTHS (fcp.end_date, p_counter))
1715: FROM fa_calendar_periods fcp
1716: , fa_calendar_types fct
1717: , fa_book_controls fbc
1718: WHERE fbc.book_type_code = p_book_type_code
1719: AND fcp.calendar_type = fct.calendar_type
1720: AND fcp.calendar_type = fbc.deprn_calendar
1752: ***********************************************************************/
1753: IS
1754: SELECT fcp.period_name
1755: FROM fa_calendar_periods fcp
1756: , fa_calendar_types fct
1757: , fa_book_controls fbc
1758: WHERE fbc.book_type_code = p_book_type_code
1759: AND fcp.calendar_type = fct.calendar_type
1760: AND fcp.calendar_type = fbc.deprn_calendar
1791: ***********************************************************************/
1792: IS
1793: SELECT fcp.end_date
1794: FROM fa_calendar_periods fcp
1795: , fa_calendar_types fct
1796: , fa_book_controls fbc
1797: WHERE fbc.book_type_code = p_book_type_code
1798: AND fcp.calendar_type = fct.calendar_type
1799: AND fcp.calendar_type = fbc.deprn_calendar
2651:
2652: BEGIN
2653: SELECT number_per_fiscal_year
2654: INTO h_nop
2655: FROM fa_calendar_types fc
2656: , fa_book_controls fb
2657: WHERE fc.calendar_type = fb.deprn_calendar
2658: AND fb.book_type_code = x_book;
2659: END;
3531: INTO l_dtcntr1
3532: FROM fa_calendar_periods fc
3533: , fa_book_controls fb
3534: , fa_fiscal_year ffy
3535: , fa_calendar_types fct
3536: WHERE fc.calendar_type = fb.deprn_calendar
3537: AND fb.book_type_code = x_book_typ
3538: AND ffy.fiscal_year_name = fb.fiscal_year_name
3539: AND ffy.fiscal_year_name = fct.fiscal_year_name