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 756: FROM cn_commission_headers h,

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

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

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

Line 1814: FROM cn_commission_headers_all ch

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

Line 2124: FROM cn_commission_headers_all

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

Line 2156: FROM cn_commission_headers_all

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

Line 2804: FROM cn_commission_headers cch,

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