APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_LOOKUPS

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

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

Line 618: FROM cn_lookups

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

Line 633: FROM cn_lookups

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