APPS.CN_GLOBAL_VAR dependencies on CN_REPOSITORIES

Line 69: ,cn_repositories r

65: ,g_system_start_date
66: ,g_set_of_books_id
67: ,gl_currency_code
68: FROM cn_period_statuses_all p
69: ,cn_repositories r
70: ,gl_sets_of_books s
71: WHERE r.current_period_id = p.period_id(+)
72: AND r.org_id = p.org_id(+)
73: AND r.application_id = 283

Line 95: ,cn_repositories r

91:
92: SELECT s.currency_code
93: INTO l_currency_code
94: FROM gl_sets_of_books s
95: ,cn_repositories r
96: WHERE r.set_of_books_id = s.set_of_books_id
97: AND r.application_id = 283
98: AND r.org_id = p_org_id
99: ;

Line 120: FROM cn_repositories

116: l_srp_batch_size number;
117: BEGIN
118: SELECT srp_batch_size
119: INTO l_srp_batch_size
120: FROM cn_repositories
121: WHERE org_id = p_org_id ;
122: RETURN l_srp_batch_size;
123: EXCEPTION
124: WHEN no_data_found THEN

Line 140: FROM cn_repositories r

136: BEGIN
137:
138: SELECT r.salesrep_batch_size
139: INTO l_salesrep_batch_size
140: FROM cn_repositories r
141: WHERE r.org_id = p_org_id;
142:
143:
144: RETURN l_salesrep_batch_size;