[Home] [Help]
390: i PLS_INTEGER;
391: d PLS_INTEGER;
392: l_temp_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE; --NUMBER;
393: l_temp_seg_num fnd_id_flex_segments.segment_num%TYPE; --NUMBER(15)
394: l_temp_seg_att_type fnd_segment_attribute_values.segment_attribute_type%TYPE; --VARCHAR2(30)
395: l_temp_tax_currency_code ar_system_parameters_all.tax_currency_code%TYPE; --VARCHAR2(15)
396: l_temp_tax_precision ar_system_parameters_all.tax_precision%TYPE; --NUMBER(1)
397: l_temp_tax_mau ar_system_parameters_all.tax_minimum_accountable_unit%TYPE; --NUMBER
398: l_temp_country_code ar_system_parameters_all.default_country%TYPE; --VARCHAR2(60)
439: --decode(asp.cross_currency_rate_type,'User','Corporate',asp.cross_currency_rate_type) cross_curr_rate_type
440: NULL cross_curr_rate_type
441: FROM fnd_id_flex_structures str,
442: fnd_id_flex_segments segment,
443: fnd_segment_attribute_values qual,
444: ar_system_parameters_all asp,
445: ar_vat_tax_all_b avt,
446: gl_sets_of_books gsob
447: WHERE str.id_flex_code = 'RLOC'
534: -- Bug 4204464: Check TAX_ACCOUNT
535: CURSOR chk_tax_acct_cur (p_flex_num NUMBER,
536: p_appl_col_name VARCHAR2) IS
537: SELECT count(attribute_value) l_count
538: FROM fnd_segment_attribute_values fsav
539: WHERE fsav.application_id = 222
540: AND fsav.id_flex_code = 'RLOC'
541: AND fsav.id_flex_num = p_flex_num
542: AND fsav.application_column_name = p_appl_col_name
545:
546: CURSOR chk_exemptions_cur (p_flex_num NUMBER,
547: p_appl_col_name VARCHAR2) IS
548: SELECT count(attribute_value) l_count
549: FROM fnd_segment_attribute_values fsav
550: WHERE fsav.application_id = 222
551: AND fsav.id_flex_code = 'RLOC'
552: AND fsav.id_flex_num = p_flex_num
553: AND fsav.application_column_name = p_appl_col_name