APPS.CN_GET_TX_DATA_PUB dependencies on CN_COMMISSION_HEADERS

Line 64: FROM cn_commission_headers_all h,

60: AND l.salesrep_id = s.salesrep_id;
61: --
62: CURSOR header_cur IS
63: SELECT h.*,s.employee_number,s.name
64: FROM cn_commission_headers_all h,
65: cn_salesreps s
66: WHERE comm_lines_api_id = p_comm_lines_api_id
67: AND h.direct_salesrep_id = s.salesrep_id;
68: --

Line 482: get the data from cn_comm_lines_api and cn_commission_headers tables. */

478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479: x_loading_status := 'CN_INSERTED';
480: -- API body
481: /* This API take the parameters and construct the SQL. Based on the SQL
482: get the data from cn_comm_lines_api and cn_commission_headers tables. */
483: cn_mass_adjust_util.search_result(
484: p_salesrep_id => p_salesrep_id,
485: p_pr_date_to => p_pr_date_to,
486: p_pr_date_from => p_pr_date_from,

Line 757: FROM cn_commission_headers h,

753: CURSOR header_cur IS
754: SELECT h.*,s.employee_number,s.name,
755: clad.meaning adjust_status_disp,
756: clt.meaning trx_type_disp
757: FROM cn_commission_headers h,
758: cn_salesreps s,
759: cn_lookups clad,
760: cn_lookups clt
761: WHERE h.trx_type = clt.lookup_code(+)

Line 1580: get the data from cn_comm_lines_api and cn_commission_headers tables. */

1576: --CN_mydebug.ADD('Adjusted table length before search : '||l_adj_tbl.count);
1577:
1578:
1579: /* This API take the parameters and construct the SQL. Based on the SQL
1580: get the data from cn_comm_lines_api and cn_commission_headers tables. */
1581: cn_mass_adjust_util.search_result(
1582: p_salesrep_id => p_salesrep_id,
1583: p_pr_date_to => p_pr_date_to,
1584: p_pr_date_from => p_pr_date_from,

Line 1815: FROM cn_commission_headers_all ch

1811: AND (api.adjust_status NOT IN ('FROZEN','REVERSAL','SCA_PENDING') )--OR
1812: -- api.adjust_status IS NULL)
1813: UNION ALL
1814: SELECT comm_lines_api_id
1815: FROM cn_commission_headers_all ch
1816: WHERE ch.order_number = l_order_number
1817: AND ch.org_id = l_org_id
1818: AND ch.trx_type = 'ORD'
1819: AND (ch.adjust_status NOT IN ('FROZEN','REVERSAL') );--OR

Line 2125: FROM cn_commission_headers_all

2121: IF (l_order_number IS NOT NULL) THEN -- 8
2122: BEGIN
2123: SELECT count(order_number)
2124: INTO l_deal_count
2125: FROM cn_commission_headers_all
2126: WHERE order_number = l_order_number
2127: AND revenue_type = 'REVENUE'
2128: AND org_id = l_org_id;
2129: IF (l_deal_count > 0) THEN

Line 2157: FROM cn_commission_headers_all

2153: ELSIF (p_invoice_number IS NOT NULL) THEN
2154: BEGIN
2155: SELECT count(invoice_number)
2156: INTO l_deal_count
2157: FROM cn_commission_headers_all
2158: WHERE invoice_number = p_invoice_number
2159: AND revenue_type = 'REVENUE'
2160: AND org_id = l_org_id;
2161: IF (l_deal_count > 0) THEN

Line 2805: FROM cn_commission_headers cch,

2801: s.salesrep_number employee_number,
2802: cch.processed_date,clt.meaning,cch.order_number,cch.booked_date,
2803: cch.invoice_number,cch.invoice_date,cch.quantity,
2804: cch.transaction_amount,cch.transaction_amount_orig
2805: FROM cn_commission_headers cch,
2806: jtf_rs_resource_extns_vl re,
2807: jtf_rs_salesreps s,
2808: cn_lookups clt,
2809: cn_period_statuses cpsp

Line 3054: FROM cn_comm_lines_api a, cn_commission_headers h

3050:
3051: ---- Bug 8882352 ----
3052: SELECT count(a.comm_lines_api_id)
3053: INTO l_comm_line_count
3054: FROM cn_comm_lines_api a, cn_commission_headers h
3055: WHERE a.comm_lines_api_id = p_newtx_rec.comm_lines_api_id
3056: AND a.comm_lines_api_id = h.comm_lines_api_id (+)
3057: AND (a.load_status IN ('FILTERED') OR
3058: a.adjust_status IN ('FROZEN','REVERSAL', 'SCA_PENDING') OR h.adjust_status IN ('FROZEN', 'REVERSAL') OR