APPS.CN_GET_TX_DATA_PUB dependencies on CN_COMM_LINES_API_ALL

Line 57: FROM cn_comm_lines_api_all l,

53: x_adj_tbl OUT NOCOPY adj_tbl_type) IS
54: --
55: CURSOR api_cur IS
56: SELECT l.*, s.name
57: FROM cn_comm_lines_api_all l,
58: cn_salesreps s
59: WHERE comm_lines_api_id = p_comm_lines_api_id
60: AND l.salesrep_id = s.salesrep_id;
61: --

Line 1806: FROM cn_comm_lines_api_all api

1802: o_newtx_rec adj_rec_type;
1803: l_deal_data_tbl cn_invoice_changes_pvt.deal_data_tbl;
1804: CURSOR order_cur IS
1805: SELECT comm_lines_api_id
1806: FROM cn_comm_lines_api_all api
1807: WHERE api.order_number = l_order_number
1808: AND api.org_id = l_org_id
1809: AND api.trx_type = 'ORD'
1810: AND api.load_status NOT IN ('LOADED', 'FILTERED') -- vensrini Bug fix 4202682

Line 2134: FROM cn_comm_lines_api_all

2130: l_deal_type := 'REVENUE';
2131: ELSE
2132: SELECT count(order_number)
2133: INTO l_deal_count
2134: FROM cn_comm_lines_api_all
2135: WHERE order_number = l_order_number
2136: AND revenue_type = 'REVENUE'
2137: AND org_id = l_org_id;
2138: IF (l_deal_count > 0) THEN

Line 2166: FROM cn_comm_lines_api_all

2162: l_deal_type := 'REVENUE';
2163: ELSE
2164: SELECT count(invoice_number)
2165: INTO l_deal_count
2166: FROM cn_comm_lines_api_all
2167: WHERE invoice_number = p_invoice_number
2168: AND revenue_type = 'REVENUE'
2169: AND org_id = l_org_id;
2170: IF (l_deal_count > 0) THEN