APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_SALESREPS

Line 980: AND NOT EXISTS (SELECT 1 FROM cn_salesreps

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

Line 993: FROM cn_salesreps

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

Line 1006: FROM cn_salesreps

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

Line 1102: FROM cn_salesreps cs1

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

Line 1112: FROM cn_salesreps cs

1108: AND api.trx_type <> 'FORECAST'
1109: AND (adjust_status <> 'SCA_PENDING')-- OR adjust_status IS NULL)
1110: AND EXISTS(
1111: SELECT /*+ NO_UNNEST */ employee_number
1112: FROM cn_salesreps cs
1113: WHERE api.employee_number = cs.employee_number
1114: AND cs.org_id = api.org_id -- vensrini
1115: AND cs.org_id = p_org_id) -- vensrini
1116: AND api.processed_date >= TRUNC(p_start_date)

Line 1127: FROM cn_salesreps cs1

1123: -- UPDATE /*+ index(api, cn_comm_lines_api_n1)*/ cn_comm_lines_api_all api
1124: UPDATE cn_comm_lines_api_all api
1125: SET employee_number =
1126: (SELECT employee_number
1127: FROM cn_salesreps cs1
1128: WHERE cs1.salesrep_id = api.salesrep_id
1129: AND cs1.org_id = api.org_id -- vensrini
1130: AND cs1.org_id = p_org_id) -- vensrini
1131: WHERE employee_number IS NULL

Line 1137: FROM cn_salesreps cs

1133: AND trx_type <> 'FORECAST'
1134: AND (adjust_status <> 'SCA_PENDING')-- OR adjust_status IS NULL)
1135: AND EXISTS(
1136: SELECT /*+ NO_UNNEST*/ salesrep_id
1137: FROM cn_salesreps cs
1138: WHERE api.salesrep_id = cs.salesrep_id
1139: AND cs.org_id = api.org_id -- vensrini
1140: AND cs.org_id = p_org_id) -- vensrini
1141: AND api.processed_date >= TRUNC(p_start_date)