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 1805: FROM cn_comm_lines_api_all api

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

Line 2133: FROM cn_comm_lines_api_all

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

Line 2165: FROM cn_comm_lines_api_all

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