APPS.CN_RATE_DIMENSIONS_PVT dependencies on CN_RATE_SCH_DIMS

Line 389: FROM cn_rate_sch_dims rsd

385: CURSOR formula_info IS
386: SELECT 1
387: FROM dual
388: WHERE exists (SELECT 1
389: FROM cn_rate_sch_dims rsd
390: WHERE rsd.rate_dimension_id = p_rate_dimension_id
391: AND exists (SELECT 1
392: FROM cn_rt_formula_asgns
393: WHERE rate_schedule_id = rsd.rate_schedule_id));

Line 701: FROM cn_rate_sch_dims

697: CURSOR parent_table_exist IS
698: SELECT 1
699: FROM dual
700: WHERE exists (SELECT 1
701: FROM cn_rate_sch_dims
702: WHERE rate_dimension_id = p_rate_dimension_id);
703: BEGIN
704: -- Standard Start of API savepoint
705: SAVEPOINT Delete_Dimension;

Line 841: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;

837: IS
838: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Tier';
839: l_api_version CONSTANT NUMBER := 1.0;
840:
841: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;
842: l_tier_sequence CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE;
843: l_dummy pls_integer;
844: l_rate_dimension_id CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE;
845:

Line 855: FROM cn_rate_sch_dims

851: l_note_id NUMBER;
852:
853: CURSOR rate_tables IS
854: SELECT rate_schedule_id
855: FROM cn_rate_sch_dims
856: WHERE rate_dimension_id = l_rate_dimension_id;
857:
858: CURSOR last_tier IS
859: SELECT 1

Line 924: FROM cn_rate_sch_dims

920: END IF;
921:
922: SELECT rate_dim_sequence
923: INTO l_rate_dim_sequence
924: FROM cn_rate_sch_dims
925: WHERE rate_schedule_id = rate_table.rate_schedule_id
926: AND rate_dimension_id = l_rate_dimension_id;
927:
928: -- delete corresponding records in cn_rate_tiers

Line 1295: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;

1291: IS
1292: l_api_name CONSTANT VARCHAR2(30) := 'Create_Tier';
1293: l_api_version CONSTANT NUMBER := 1.0;
1294:
1295: l_rate_dim_sequence CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE;
1296: i pls_integer := 1;
1297:
1298: --R12 Notes Hoistory
1299: l_from VARCHAR2(100);

Line 1306: FROM cn_rate_sch_dims

1302: l_note_id NUMBER;
1303:
1304: CURSOR rate_tables IS
1305: SELECT rate_schedule_id
1306: FROM cn_rate_sch_dims
1307: WHERE rate_dimension_id = p_rate_dimension_id;
1308: BEGIN
1309: -- Standard Start of API savepoint
1310: SAVEPOINT Create_tier;

Line 1355: FROM cn_rate_sch_dims

1351: FOR rate_table IN rate_tables LOOP
1352: -- NOTE: a rate table can not have two dimensions with the same rate_dimension_id
1353: SELECT rate_dim_sequence
1354: INTO l_rate_dim_sequence
1355: FROM cn_rate_sch_dims
1356: WHERE rate_dimension_id = p_rate_dimension_id
1357: AND rate_schedule_id = rate_table.rate_schedule_id;
1358:
1359: cn_multi_rate_schedules_pvt.create_rate_tiers