APPS.CN_CALC_CLASSIFY_PVT dependencies on CN_PROCESS_BATCHES_ALL

Line 113: FROM cn_process_batches_all

109: END IF;
110:
111: SELECT MIN(start_date), MAX(end_date)
112: INTO l_min_start_date, l_max_end_date
113: FROM cn_process_batches_all
114: WHERE physical_batch_id = p_physical_batch_id;
115:
116: -- cache org_id and org_append
117:

Line 120: from cn_process_batches_all

116: -- cache org_id and org_append
117:
118: select org_id
119: into g_org_id
120: from cn_process_batches_all
121: where physical_batch_id = p_physical_batch_id
122: and rownum = 1;
123:
124: g_org_append := '_' || g_org_id;

Line 147: FROM cn_process_batches_all pb

143: ch.pre_processed_code,
144: ch.revenue_class_id
145: FROM cn_commission_headers_all ch
146: WHERE ch.direct_salesrep_id IN (SELECT salesrep_id
147: FROM cn_process_batches_all pb
148: WHERE pb.physical_batch_id = p_physical_batch_id)
149: AND ch.processed_date BETWEEN l_ruleset.start_date AND l_ruleset.end_date
150: AND ch.org_id = g_org_id
151: AND (( l_calc_type = 'COMMISSION'

Line 163: FROM cn_process_batches_all pb

159: ch.revenue_class_id
160: FROM cn_commission_headers_all ch
161: WHERE ch.direct_salesrep_id
162: IN ( SELECT salesrep_id
163: FROM cn_process_batches_all pb
164: WHERE pb.physical_batch_id = p_physical_batch_id)
165: AND ch.processed_date BETWEEN l_ruleset.start_date AND l_ruleset.end_date
166: AND ch.org_id = g_org_id
167: AND exists (SELECT 1

Line 186: FROM cn_process_batches_all pb

182: ch.pre_processed_code,
183: ch.revenue_class_id
184: FROM cn_commission_headers_all ch
185: WHERE ch.direct_salesrep_id IN (SELECT salesrep_id
186: FROM cn_process_batches_all pb
187: WHERE pb.physical_batch_id = p_physical_batch_id)
188: AND ch.processed_date BETWEEN l_ruleset.start_date AND l_ruleset.end_date
189: AND ch.org_id = g_org_id
190: AND exists (SELECT 1