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