APPS.CN_MULTI_RATE_SCHEDULES_PVT dependencies on CN_RATE_DIM_TIERS

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 1632: p_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := NULL,

1628: -- 2. form processing changes in the following order: delete --> update --> insert
1629: PROCEDURE create_rate_tiers
1630: (p_rate_schedule_id CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
1631: p_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := NULL,
1632: p_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := NULL,
1633: p_num_tiers NUMBER := 1,
1634: --R12 MOAC Changes--Start
1635: p_org_id IN CN_RATE_TIERS.ORG_ID%TYPE
1636: --R12 MOAC Changes--End

Line 1649: FROM cn_rate_dim_tiers rdt,

1645: l_num_tiers number := nvl(p_num_tiers,1);
1646:
1647: CURSOR dims_info IS
1648: SELECT COUNT(*) number_tier
1649: FROM cn_rate_dim_tiers rdt,
1650: cn_rate_sch_dims rsd
1651: WHERE rdt.rate_dimension_id = rsd.rate_dimension_id
1652: AND rsd.rate_schedule_id = p_rate_schedule_id
1653: GROUP BY rsd.rate_dim_sequence

Line 1739: p_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := NULL,

1735:
1736: PROCEDURE delete_rate_tiers
1737: (p_rate_schedule_id CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
1738: p_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
1739: p_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := NULL,
1740: p_num_tiers NUMBER := 1) IS
1741:
1742: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;
1743: l_coords NUM_TBL_TYPE;

Line 1753: FROM cn_rate_dim_tiers rdt,

1749: delete_flag boolean;
1750:
1751: CURSOR dims_info IS
1752: SELECT COUNT(*) number_tier
1753: FROM cn_rate_dim_tiers rdt,
1754: cn_rate_sch_dims rsd
1755: WHERE rdt.rate_dimension_id = rsd.rate_dimension_id
1756: AND rsd.rate_schedule_id = p_rate_schedule_id
1757: GROUP BY rsd.rate_dim_sequence

Line 2210: l_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;

2206: x_commission_amount OUT NOCOPY CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
2207: x_object_version_number OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS
2208:
2209: l_base NUMBER := 1;
2210: l_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;
2211: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
2212: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;
2213: l_number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;
2214: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;

Line 2229: FROM cn_rate_dim_tiers

2225: AND rd.rate_dimension_id = p_rate_dimension_id;
2226:
2227: CURSOR tier_info(p_rate_dim_tier_id NUMBER) IS
2228: SELECT tier_sequence, rate_dimension_id
2229: FROM cn_rate_dim_tiers
2230: WHERE rate_dim_tier_id = p_rate_dim_tier_id;
2231:
2232: CURSOR get_tier IS
2233: SELECT rate_tier_id, nvl(commission_amount,0), object_version_number

Line 2333: from cn_rate_sch_dims rsd, cn_rate_dim_tiers rdt

2329: if l_number_dim = 1 then
2330: -- strip off extra commas
2331: sres := replace(sbuf, ',');
2332: select rdt.tier_sequence into x_rate_sequence
2333: from cn_rate_sch_dims rsd, cn_rate_dim_tiers rdt
2334: where rsd.rate_schedule_id = x_schedule_id
2335: and rsd.rate_dimension_id = rdt.rate_dimension_id
2336: and rdt.rate_dim_tier_id = sres;
2337: return x_rate_sequence;