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 2201: l_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;

2197: x_commission_amount OUT NOCOPY CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
2198: x_object_version_number OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS
2199:
2200: l_base NUMBER := 1;
2201: l_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;
2202: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
2203: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;
2204: l_number_tier CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE;
2205: l_number_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;

Line 2220: FROM cn_rate_dim_tiers

2216: AND rd.rate_dimension_id = p_rate_dimension_id;
2217:
2218: CURSOR tier_info(p_rate_dim_tier_id NUMBER) IS
2219: SELECT tier_sequence, rate_dimension_id
2220: FROM cn_rate_dim_tiers
2221: WHERE rate_dim_tier_id = p_rate_dim_tier_id;
2222:
2223: CURSOR get_tier IS
2224: SELECT rate_tier_id, nvl(commission_amount,0), object_version_number

Line 2324: from cn_rate_sch_dims rsd, cn_rate_dim_tiers rdt

2320: if l_number_dim = 1 then
2321: -- strip off extra commas
2322: sres := replace(sbuf, ',');
2323: select rdt.tier_sequence into x_rate_sequence
2324: from cn_rate_sch_dims rsd, cn_rate_dim_tiers rdt
2325: where rsd.rate_schedule_id = x_schedule_id
2326: and rsd.rate_dimension_id = rdt.rate_dimension_id
2327: and rdt.rate_dim_tier_id = sres;
2328: return x_rate_sequence;