APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_SALESREPS

Line 977: AND NOT EXISTS (SELECT 1 FROM cn_salesreps

973: AND Trunc(processed_date) >= Trunc(p_start_date)
974: AND Trunc(processed_date) <= Trunc(p_end_date)
975: AND ((p_salesrep_id IS NULL) OR (salesrep_id = p_salesrep_id))
976: AND trx_type <> 'FORECAST'
977: AND NOT EXISTS (SELECT 1 FROM cn_salesreps
978: WHERE employee_number =
979: cn_comm_lines_api.employee_number); */
980: IF (p_salesrep_id IS NULL) THEN
981: UPDATE cn_comm_lines_api_all

Line 990: FROM cn_salesreps

986: AND processed_date <(TRUNC(p_end_date) + 1)
987: AND trx_type <> 'FORECAST'
988: AND org_id = p_org_id
989: AND NOT EXISTS(SELECT 1
990: FROM cn_salesreps
991: WHERE employee_number = cn_comm_lines_api_all.employee_number);
992: ELSE
993: UPDATE cn_comm_lines_api_all
994: SET load_status = 'SALESREP ERROR'

Line 1003: FROM cn_salesreps

999: AND salesrep_id = p_salesrep_id
1000: AND trx_type <> 'FORECAST'
1001: AND org_id = p_org_id
1002: AND NOT EXISTS(SELECT 1
1003: FROM cn_salesreps
1004: WHERE employee_number = cn_comm_lines_api_all.employee_number);
1005: END IF;
1006:
1007: debugmsg('Loader : Post_Conc_Dispatch : # of SALESREP ERROR = ' || TO_CHAR(SQL%ROWCOUNT));

Line 1099: FROM cn_salesreps cs1

1095: --+
1096: UPDATE /* index (api, mis_cn_comm_lines_api_n1) */ cn_comm_lines_api_all api
1097: SET api.salesrep_id =
1098: (SELECT cs1.salesrep_id
1099: FROM cn_salesreps cs1
1100: WHERE cs1.employee_number = api.employee_number
1101: AND cs1.org_id = api.org_id -- vensrini
1102: AND cs1.org_id = p_org_id) -- vensrini
1103: WHERE api.salesrep_id IS NULL

Line 1109: FROM cn_salesreps cs

1105: AND api.trx_type <> 'FORECAST'
1106: AND (adjust_status <> 'SCA_PENDING' OR adjust_status IS NULL)
1107: AND EXISTS(
1108: SELECT employee_number
1109: FROM cn_salesreps cs
1110: WHERE api.employee_number = cs.employee_number
1111: AND cs.org_id = api.org_id -- vensrini
1112: AND cs.org_id = p_org_id) -- vensrini
1113: AND api.processed_date >= TRUNC(p_start_date)

Line 1123: FROM cn_salesreps cs1

1119: --+
1120: UPDATE cn_comm_lines_api_all api
1121: SET employee_number =
1122: (SELECT employee_number
1123: FROM cn_salesreps cs1
1124: WHERE cs1.salesrep_id = api.salesrep_id
1125: AND cs1.org_id = api.org_id -- vensrini
1126: AND cs1.org_id = p_org_id) -- vensrini
1127: WHERE employee_number IS NULL

Line 1133: FROM cn_salesreps cs

1129: AND trx_type <> 'FORECAST'
1130: AND (adjust_status <> 'SCA_PENDING' OR adjust_status IS NULL)
1131: AND EXISTS(
1132: SELECT salesrep_id
1133: FROM cn_salesreps cs
1134: WHERE api.salesrep_id = cs.salesrep_id
1135: AND cs.org_id = api.org_id -- vensrini
1136: AND cs.org_id = p_org_id) -- vensrini
1137: AND api.processed_date >= TRUNC(p_start_date)