APPS.FA_JAPAN_DEP_TAX_SUMMARY_PKG dependencies on FA_LOOKUPS

Line 21: from FA_LOOKUPS

17: and SOB.Set_of_books_id = BC.Set_of_books_ID;
18:
19: select meaning
20: into h_imperial_code
21: from FA_LOOKUPS
22: where lookup_type ='JP_IMPERIAL'
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'''))

Line 31: from FA_LOOKUPS

27: from dual;
28:
29: select meaning
30: into h_today_imperial_code
31: from FA_LOOKUPS
32: where lookup_type ='JP_IMPERIAL'
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'''))

Line 118: from fa_lookups

114: l_meaning varchar2(80);
115: begin
116: select meaning
117: into l_meaning
118: from fa_lookups
119: where lookup_type = l_type
120: and lookup_code = l_code;
121:
122: return (l_meaning);