70:
71: ELSIF l_country_code = 'BR' then
72:
73: -- Get Global_Attribute1..7, due_date from ap_payment_schedule
74: --Bug6238399 Use fnd_number.canonical_to_number instead of to_number
75: SELECT substr(global_attribute1,1,15) interest_type,
76: fnd_number.canonical_to_number(substr(global_attribute2,1,15)) interest_rate_amount,
77: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
78: substr(global_attribute4,1,30) interest_formula,
72:
73: -- Get Global_Attribute1..7, due_date from ap_payment_schedule
74: --Bug6238399 Use fnd_number.canonical_to_number instead of to_number
75: SELECT substr(global_attribute1,1,15) interest_type,
76: fnd_number.canonical_to_number(substr(global_attribute2,1,15)) interest_rate_amount,
77: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
78: substr(global_attribute4,1,30) interest_formula,
79: fnd_number.canonical_to_number(substr(global_attribute5,1,4)) interest_grace_days,
80: substr(global_attribute6,1,15) penalty_type,
73: -- Get Global_Attribute1..7, due_date from ap_payment_schedule
74: --Bug6238399 Use fnd_number.canonical_to_number instead of to_number
75: SELECT substr(global_attribute1,1,15) interest_type,
76: fnd_number.canonical_to_number(substr(global_attribute2,1,15)) interest_rate_amount,
77: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
78: substr(global_attribute4,1,30) interest_formula,
79: fnd_number.canonical_to_number(substr(global_attribute5,1,4)) interest_grace_days,
80: substr(global_attribute6,1,15) penalty_type,
81: fnd_number.canonical_to_number(substr(global_attribute7,1,15)) penalty_rate_amount
75: SELECT substr(global_attribute1,1,15) interest_type,
76: fnd_number.canonical_to_number(substr(global_attribute2,1,15)) interest_rate_amount,
77: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
78: substr(global_attribute4,1,30) interest_formula,
79: fnd_number.canonical_to_number(substr(global_attribute5,1,4)) interest_grace_days,
80: substr(global_attribute6,1,15) penalty_type,
81: fnd_number.canonical_to_number(substr(global_attribute7,1,15)) penalty_rate_amount
82: INTO l_interest_type,
83: l_interest_rate_amount,
77: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
78: substr(global_attribute4,1,30) interest_formula,
79: fnd_number.canonical_to_number(substr(global_attribute5,1,4)) interest_grace_days,
80: substr(global_attribute6,1,15) penalty_type,
81: fnd_number.canonical_to_number(substr(global_attribute7,1,15)) penalty_rate_amount
82: INTO l_interest_type,
83: l_interest_rate_amount,
84: l_interest_period,
85: l_interest_formula,