APPS.CN_MULTI_RATE_SCHEDULES_PVT dependencies on CN_RATE_DIMENSIONS_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(+)

Line 2410: select * from cn_rate_dimensions_all

2406: and org_id = p_org_id;
2407:
2408: cursor rate_dim_info(l_dim_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE)
2409: is
2410: select * from cn_rate_dimensions_all
2411: where rate_dimension_id = l_dim_id
2412: and org_id = p_org_id;
2413:
2414: