[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'
552: -- Bug 4204464: Check TAX_ACCOUNT
553: CURSOR chk_tax_acct_cur (p_flex_num NUMBER,
554: p_appl_col_name VARCHAR2) IS
555: SELECT count(attribute_value) l_count
556: FROM fnd_segment_attribute_values fsav
557: WHERE fsav.application_id = 222
558: AND fsav.id_flex_code = 'RLOC'
559: AND fsav.id_flex_num = p_flex_num
560: AND fsav.application_column_name = p_appl_col_name
563:
564: CURSOR chk_exemptions_cur (p_flex_num NUMBER,
565: p_appl_col_name VARCHAR2) IS
566: SELECT count(attribute_value) l_count
567: FROM fnd_segment_attribute_values fsav
568: WHERE fsav.application_id = 222
569: AND fsav.id_flex_code = 'RLOC'
570: AND fsav.id_flex_num = p_flex_num
571: AND fsav.application_column_name = p_appl_col_name