APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_LOOKUPS

Line 600: (SELECT 1 FROM cn_lookups WHERE lookup_type = 'TRX TYPES'

596: AND Trunc(processed_date) <= Trunc(p_end_date)
597: AND ((p_salesrep_id IS NULL) OR (salesrep_id = p_salesrep_id))
598: AND trx_type <> 'FORECAST'
599: AND NOT EXISTS
600: (SELECT 1 FROM cn_lookups WHERE lookup_type = 'TRX TYPES'
601: AND lookup_code =
602: cn_comm_lines_api.trx_type); */
603: -- Added by rchenna on 06/12/01
604: IF (p_salesrep_id IS NULL) THEN

Line 615: FROM cn_lookups

611: AND (adjust_status <> 'SCA_PENDING' OR adjust_status IS NULL)
612: AND org_id = p_org_id
613: AND NOT EXISTS(
614: SELECT 1
615: FROM cn_lookups
616: WHERE lookup_type = 'TRX TYPES'
617: AND lookup_code = cn_comm_lines_api_all.trx_type);
618: ELSE
619: UPDATE cn_comm_lines_api_all

Line 630: FROM cn_lookups

626: AND (adjust_status <> 'SCA_PENDING' OR adjust_status IS NULL)
627: AND org_id = p_org_id
628: AND NOT EXISTS(
629: SELECT 1
630: FROM cn_lookups
631: WHERE lookup_type = 'TRX TYPES'
632: AND lookup_code = cn_comm_lines_api_all.trx_type);
633: END IF;
634: