APPS.CN_TRX_FACTOR_PVT dependencies on CN_TRX_FACTORS

Line 397: FROM cn_trx_factors

393: END IF;
394:
395: SELECT COUNT (*)
396: INTO l_temp_count
397: FROM cn_trx_factors
398: WHERE revenue_class_id = p_trx_factor.revenue_class_id
399: AND quota_id = p_trx_factor.quota_id
400: AND quota_rule_id = p_trx_factor.quota_rule_id
401: AND trx_type = p_trx_factor.trx_type

Line 423: FROM cn_trx_factors

419:
420: -- 2. trx type must be unique
421: SELECT COUNT (1)
422: INTO l_temp_count
423: FROM cn_trx_factors
424: WHERE quota_rule_id = p_trx_factor.quota_rule_id
425: AND trx_type = p_trx_factor.trx_type
426: AND trx_factor_id <> p_trx_factor.trx_factor_id
427: AND ROWNUM = 1;

Line 520: FROM cn_trx_factors

516: factor_id NUMBER
517: )
518: IS
519: SELECT *
520: FROM cn_trx_factors
521: WHERE trx_factor_id = factor_id;
522:
523: l_old_trx_factor trx_factor_csr%ROWTYPE;
524: l_old_rec trx_factor_rec_type;

Line 606: cn_trx_factors_pkg.begin_record (x_operation => 'UPDATE',

602: END IF;
603:
604: -- update the record
605: -- org_id depends on the plan elements org_id
606: cn_trx_factors_pkg.begin_record (x_operation => 'UPDATE',
607: x_rowid => l_row_id,
608: x_trx_factor_id => p_trx_factor.trx_factor_id,
609: x_object_version_number => p_trx_factor.object_version_number,
610: x_event_factor => p_trx_factor.event_factor,

Line 858: FROM cn_trx_factors

854: SELECT trx_factor_id,
855: object_version_number
856: INTO l_trx_factor_rec.trx_factor_id,
857: l_trx_factor_rec.object_version_number
858: FROM cn_trx_factors
859: WHERE quota_rule_id = l_trx_factor_rec.quota_rule_id
860: AND trx_type = l_trx_factor_rec.trx_type
861: AND quota_id = l_trx_factor_rec.quota_id
862: AND revenue_class_id = l_trx_factor_rec.revenue_class_id;

Line 1083: FROM cn_trx_factors

1079:
1080: CURSOR l_trx_factor_cr
1081: IS
1082: SELECT *
1083: FROM cn_trx_factors
1084: WHERE quota_rule_id = p_quota_rule_id;
1085:
1086: l_counter NUMBER;
1087: BEGIN