DBA Data[Home] [Help]

APPS.CN_MULTI_RATE_SCHEDULES_PVT dependencies on CN_RATE_DIM_TIERS_ALL

Line 170: from cn_rate_dim_tiers_all rdt, cn_rate_dimensions_all rd, cn_calc_sql_exps e1, cn_calc_sql_exps e2

166: 'AMOUNT', rdt.minimum_amount || ' - ' || rdt.maximum_amount,
167: 'PERCENT', rdt.minimum_amount * 100 || '% - ' || rdt.maximum_amount * 100 || '%',
168: 'STRING', rdt.string_value,
169: 'EXPRESSION', e1.name || ' - ' || e2.name) tier
170: from cn_rate_dim_tiers_all rdt, cn_rate_dimensions_all rd, cn_calc_sql_exps e1, cn_calc_sql_exps e2
171: where rdt.rate_dimension_id = p_rate_dimension_id
172: and rdt.tier_sequence = p_sequence
173: and rd.rate_dimension_id = rdt.rate_dimension_id
174: and rdt.min_exp_id = e1.calc_sql_exp_id(+)