APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_REVENUE_CLASSES

Line 649: (SELECT 1 FROM cn_revenue_classes

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

Line 650: WHERE cn_revenue_classes.revenue_class_id =

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

Line 665: FROM cn_revenue_classes

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

Line 666: WHERE cn_revenue_classes.revenue_class_id =

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

Line 681: FROM cn_revenue_classes

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

Line 682: WHERE cn_revenue_classes.revenue_class_id =

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