DBA Data[Home] [Help]

APPS.FA_JAPAN_DEP_TAX_SUMMARY_PKG dependencies on DUAL

Line 27: from dual;

23: and lookup_code = to_char(to_date(to_char(p_year),'YYYY'),'E','nls_calendar=''Japanese Imperial''');
24:
25: select to_number(to_char(to_date(to_char(p_year),'YYYY'),'YY','nls_calendar=''Japanese Imperial'''))
26: into h_imperial_year
27: from dual;
28:
29: select meaning
30: into h_today_imperial_code
31: from FA_LOOKUPS

Line 37: from dual;

33: and lookup_code = to_char(to_date(to_char(sysdate,'YYYY'),'YYYY'),'E','nls_calendar=''Japanese Imperial''');
34:
35: select to_number(to_char(to_date(to_char(sysdate,'YYYY'),'YYYY'),'YY','nls_calendar=''Japanese Imperial'''))
36: into h_today_imperial_year
37: from dual;
38:
39: return (TRUE);
40:
41: end;