APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_REVENUE_CLASSES

Line 646: (SELECT 1 FROM cn_revenue_classes

642: AND ((p_salesrep_id IS NULL) OR (salesrep_id = p_salesrep_id))
643: AND trx_type <> 'FORECAST'
644: AND revenue_class_id IS NOT NULL
645: AND NOT EXISTS
646: (SELECT 1 FROM cn_revenue_classes
647: WHERE cn_revenue_classes.revenue_class_id =
648: cn_comm_lines_api.revenue_class_id); */
649: -- Added by rchenna on 06/12/01
650: IF (p_salesrep_id IS NULL) THEN

Line 647: WHERE cn_revenue_classes.revenue_class_id =

643: AND trx_type <> 'FORECAST'
644: AND revenue_class_id IS NOT NULL
645: AND NOT EXISTS
646: (SELECT 1 FROM cn_revenue_classes
647: WHERE cn_revenue_classes.revenue_class_id =
648: cn_comm_lines_api.revenue_class_id); */
649: -- Added by rchenna on 06/12/01
650: IF (p_salesrep_id IS NULL) THEN
651: UPDATE cn_comm_lines_api_all

Line 662: FROM cn_revenue_classes

658: AND revenue_class_id IS NOT NULL
659: AND org_id = p_org_id
660: AND NOT EXISTS(
661: SELECT 1
662: FROM cn_revenue_classes
663: WHERE cn_revenue_classes.revenue_class_id =
664: cn_comm_lines_api_all.revenue_class_id);
665: ELSE
666: UPDATE cn_comm_lines_api_all

Line 663: WHERE cn_revenue_classes.revenue_class_id =

659: AND org_id = p_org_id
660: AND NOT EXISTS(
661: SELECT 1
662: FROM cn_revenue_classes
663: WHERE cn_revenue_classes.revenue_class_id =
664: cn_comm_lines_api_all.revenue_class_id);
665: ELSE
666: UPDATE cn_comm_lines_api_all
667: SET load_status = 'ERROR - REVENUE_CLASS'

Line 678: FROM cn_revenue_classes

674: AND revenue_class_id IS NOT NULL
675: AND org_id = p_org_id
676: AND NOT EXISTS(
677: SELECT 1
678: FROM cn_revenue_classes
679: WHERE cn_revenue_classes.revenue_class_id =
680: cn_comm_lines_api_all.revenue_class_id);
681: END IF;
682:

Line 679: WHERE cn_revenue_classes.revenue_class_id =

675: AND org_id = p_org_id
676: AND NOT EXISTS(
677: SELECT 1
678: FROM cn_revenue_classes
679: WHERE cn_revenue_classes.revenue_class_id =
680: cn_comm_lines_api_all.revenue_class_id);
681: END IF;
682:
683: --