DBA Data[Home] [Help]

APPS.FA_JAPAN_DEP_TAX_ADDITION_PKG dependencies on FA_LOOKUPS

Line 22: from FA_LOOKUPS

18:
19:
20: select meaning
21: into h_classification
22: from FA_LOOKUPS
23: where lookup_type ='JP_CLASSIFICATION'
24: and lookup_code = p_classification;
25:
26: if p_classification = 'ADDITION' then

Line 41: from FA_LOOKUPS

37:
38:
39: select meaning
40: into h_imperial_code
41: from FA_LOOKUPS
42: where lookup_type ='JP_IMPERIAL'
43: and lookup_code = to_char(to_date(to_char(p_year),'YYYY'),'E','nls_calendar=''Japanese Imperial''');
44:
45: select to_number(to_char(to_date(to_char(p_year),'YYYY'),'YY','nls_calendar=''Japanese Imperial'''))