APPS.CN_GET_TX_DATA_PUB dependencies on CN_COMMISSION_HEADERS_ALL

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 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