APPS.CN_TRX_FACTOR_PVT dependencies on CN_REVENUE_CLASSES

Line 536: l_rev_class_name cn_revenue_classes.NAME%TYPE;

532: g_last_updated_by NUMBER := fnd_global.user_id;
533: g_creation_date DATE := SYSDATE;
534: g_created_by NUMBER := fnd_global.user_id;
535: g_last_update_login NUMBER := fnd_global.login_id;
536: l_rev_class_name cn_revenue_classes.NAME%TYPE;
537: l_factor_name VARCHAR2(200);
538: l_note_msg VARCHAR2 (2000);
539: l_note_id NUMBER;
540: BEGIN

Line 630: select NAME into l_rev_class_name from cn_revenue_classes

626:
627: --GENERATE NOTE FOR THE UPDATE
628: IF (l_old_rec.event_factor <> p_trx_factor.event_factor) THEN
629: --Get Revenue Class Name
630: select NAME into l_rev_class_name from cn_revenue_classes
631: where REVENUE_CLASS_ID = p_trx_factor.revenue_class_id
632: and org_id = p_trx_factor.org_id;
633: --Get Factor Name
634: l_factor_name := cn_api.get_lkup_meaning(p_trx_factor.trx_type, 'TRX TYPES');

Line 737: l_rev_class_name cn_revenue_classes.NAME%TYPE;

733: l_api_version CONSTANT NUMBER := 1.0;
734: l_quota_id NUMBER;
735: l_quota_rule_id NUMBER;
736: l_rev_class_id NUMBER;
737: l_rev_class_name cn_revenue_classes.NAME%TYPE;
738: l_trx_factor_rec cn_trx_factor_pvt.trx_factor_rec_type;
739: l_loading_status VARCHAR2 (80);
740: l_rev_class_names_array jtf_varchar2_table_4000;
741: BEGIN

Line 818: cn_revenue_classes rc

814: THEN
815: SELECT rc.NAME AS revenue_class_name
816: BULK COLLECT INTO l_rev_class_names_array
817: FROM cn_quota_rules qr,
818: cn_revenue_classes rc
819: WHERE qr.quota_id = l_quota_id AND qr.revenue_class_id = rc.revenue_class_id;
820: ELSE
821: l_rev_class_names_array := jtf_varchar2_table_4000 (p_revenue_class_name);
822: END IF;