DBA Data[Home] [Help]

APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on FND_ID_FLEX_SEGMENTS

Line 392: l_temp_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE; --NUMBER;

388: tax_mau_tbl num_tbl_type;
389: cnt PLS_INTEGER;
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)

Line 393: l_temp_seg_num fnd_id_flex_segments.segment_num%TYPE; --NUMBER(15)

389: cnt PLS_INTEGER;
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

Line 442: fnd_id_flex_segments segment,

438: -- Bug 6006519/5654551, 'User' is not a valid exchange rate type
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