APPS.CN_WEBSERVICE_PUB dependencies on CN_PERIODS

Line 17: FROM cn_periods p

13: */
14: PROCEDURE get_currency_info IS
15: CURSOR c_get_curr_code IS
16: SELECT s.currency_code
17: FROM cn_periods p
18: , cn_repositories r
19: , gl_sets_of_books s
20: WHERE r.current_period_id = p.period_id(+)
21: AND r.application_id = 283

Line 71: FROM cn_periods

67:
68: CURSOR open_period IS
69: SELECT MIN(start_date) AS min_date
70: , MAX(end_date) AS max_date
71: FROM cn_periods
72: WHERE closing_status = 'O';
73:
74: CURSOR recent_transation(p_from_date DATE, p_to_date DATE, p_salesrep_id NUMBER) IS
75: SELECT TO_CHAR(cl.processed_date, 'MM/DD') AS processed_date

Line 168: FROM cn_periods

164:
165: CURSOR open_period IS
166: SELECT MIN(start_date) AS min_date
167: , MAX(end_date) AS max_date
168: FROM cn_periods
169: WHERE closing_status = 'O';
170:
171: CURSOR top_customer(p_from_date DATE, p_to_date DATE, p_salesrep_id NUMBER) IS
172: SELECT customer_name

Line 277: FROM cn_periods

273:
274: CURSOR open_period IS
275: SELECT MIN(start_date) AS min_date
276: , MAX(end_date) AS max_date
277: FROM cn_periods
278: WHERE closing_status = 'O';
279:
280: CURSOR top_product(p_from_date DATE, p_to_date DATE, p_salesrep_id NUMBER) IS
281: SELECT product_name