APPS.FA_JP_TAX_EXTN_PVT dependencies on DUAL

Line 367: FROM DUAL';

363: l_sql_counter_query :=
364: 'SELECT months_between(''' || l_first_period_date
365: || ''',''' || l_start_period_date
366: || ''') counter
367: FROM DUAL';
368:
369: EXECUTE IMMEDIATE l_sql_counter_query
370: INTO l_count;
371:

Line 429: FROM DUAL;

425: , -1, l_start_period_date
426: , l_first_period_date
427: )
428: INTO l_last_date
429: FROM DUAL;
430:
431: SELECT DECODE (SIGN (l_first_period_date - l_start_period_date)
432: , -1, l_first_period_date
433: , l_start_period_date

Line 436: FROM DUAL;

432: , -1, l_first_period_date
433: , l_start_period_date
434: )
435: INTO l_start_date
436: FROM DUAL;
437:
438: IF p_flag = 'Y'
439: THEN
440: l_last_date := l_date;

Line 604: FROM DUAL;

600: l_count := 0;
601: ELSE
602: select round(months_between(l_start_period_date, l_first_period_date),0)
603: INTO l_count
604: FROM DUAL;
605: END IF;
606:
607: IF l_whatif_period_tbl2.COUNT = 0
608: THEN

Line 1926: FROM DUAL;

1922: --As per the Bug 7210341
1923: /* SELECT MONTHS_BETWEEN (TO_DATE (lc_period, 'MM-RRRR')
1924: , TO_DATE (p_start_period, 'MM-RRRR'))
1925: INTO l_temp
1926: FROM DUAL;
1927: */
1928: --Bug#9595652:Changed to < 0 as what_if cannot be run for
1929: --already closed periods.
1930: IF l_temp < 0

Line 2018: FROM DUAL;

2014: BEGIN
2015: SELECT ADD_MONTHS (l_date_extn_end, i-1)
2016: -- SELECT ADD_MONTHS(l_date_extn_end,i-1) (For Bug : 6971130)
2017: INTO l_extended_date
2018: FROM DUAL;
2019:
2020: IF l_extended_date IS NOT NULL
2021: THEN
2022: l_exit := l_exit + 1;

Line 2087: FROM DUAL;

2083: BEGIN
2084: SELECT ADD_MONTHS (l_date_extn_end, i-1)
2085: --SELECT ADD_MONTHS(l_date_extn_end,i-1) (For Bug : 6971130)
2086: INTO l_extended_date
2087: FROM DUAL;
2088:
2089: IF l_extended_date IS NOT NULL
2090: THEN
2091: l_exit := l_exit + 1;