APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_TRX_FACTORS

Line 1468: UPDATE cn_trx_factors

1464: x_loading_status := 'CN_TRX_TYPE_NOT_EXISTS';
1465: RAISE fnd_api.g_exc_error;
1466: END IF;
1467:
1468: UPDATE cn_trx_factors
1469: SET event_factor = p_trx_factor_rec_tbl (OUTER).event_factor
1470: WHERE quota_rule_id = l_quota_rule_id AND quota_id = p_quota_id AND trx_type = p_trx_factor_rec_tbl (INNER).trx_type;
1471: END IF; -- trx Factor Exists
1472: END LOOP; -- Trx Loop

Line 3270: UPDATE cn_trx_factors

3266: -- Update the Trx factors
3267: IF (l_p_trx_factor_rec_tbl (j).rev_class_name = l_trx_factor_rec_tbl (i).rev_class_name)
3268: THEN
3269: -- Update the trx Factors
3270: UPDATE cn_trx_factors
3271: SET event_factor = l_p_trx_factor_rec_tbl (j).event_factor
3272: WHERE quota_rule_id = l_quota_rule_id
3273: AND quota_id = NVL (l_pe_rec.quota_id, l_pe_rec_old.quota_id)
3274: AND trx_type = l_p_trx_factor_rec_tbl (j).trx_type;

Line 4278: FROM cn_trx_factors tf

4274: SELECT tf.trx_type,
4275: tf.event_factor,
4276: tf.org_id
4277: -- rev_class_name get it from previous cursor
4278: FROM cn_trx_factors tf
4279: WHERE tf.quota_id = pe_id AND tf.quota_rule_id = p_quota_rule_id;
4280:
4281: -- Period Quotas Cursor
4282: CURSOR c_period_quotas_rec_csr (