APPS.CN_SCA_WF_PKG dependencies on CN_SCA_HEADERS_INTERFACE_GTT

Line 89: FROM cn_sca_headers_interface_gtt g_headers,

85: UPDATE cn_sca_lines_output_gtt lines
86: SET allocation_percentage =
87: (SELECT ROUND(lines.allocation_percentage +
88: (100 - SUM(g_lines.allocation_percentage)),4)
89: FROM cn_sca_headers_interface_gtt g_headers,
90: cn_sca_lines_output_gtt g_lines
91: WHERE g_headers.sca_headers_interface_id =
92: lines.sca_headers_interface_id
93: AND g_headers.sca_headers_interface_id =

Line 101: FROM cn_sca_headers_interface_gtt headers

97: GROUP BY g_headers.sca_headers_interface_id)
98: WHERE lines.revenue_type = G_REVENUE
99: AND lines.sca_batch_id = p_sca_batch_id
100: AND EXISTS (SELECT 1
101: FROM cn_sca_headers_interface_gtt headers
102: WHERE headers.process_status = G_REV_NOT_100
103: AND headers.sca_headers_interface_id =
104: lines.sca_headers_interface_id)
105: AND lines.sca_lines_output_id = (SELECT MIN(sca_lines_output_id)

Line 149: FROM cn_sca_headers_interface_gtt g_headers,

145: SET allocation_percentage =
146: (SELECT ROUND(lines.allocation_percentage +
147: (100 - SUM(g_lines.allocation_percentage))
148: / COUNT(*),4)
149: FROM cn_sca_headers_interface_gtt g_headers,
150: cn_sca_lines_output_gtt g_lines
151: WHERE g_headers.sca_headers_interface_id =
152: lines.sca_headers_interface_id
153: AND g_headers.sca_headers_interface_id =

Line 161: FROM cn_sca_headers_interface_gtt headers

157: GROUP BY g_headers.sca_headers_interface_id)
158: WHERE lines.revenue_type = G_REVENUE
159: AND lines.sca_batch_id = p_sca_batch_id
160: AND EXISTS (SELECT 1
161: FROM cn_sca_headers_interface_gtt headers
162: WHERE headers.process_status = G_REV_NOT_100
163: AND headers.sca_headers_interface_id =
164: lines.sca_headers_interface_id);
165:

Line 170: UPDATE cn_sca_headers_interface_gtt headers

166: -- second update to address possible rounding error
167: ONLINE_POST_DIST_UPDATE(p_sca_batch_id => p_sca_batch_id);
168:
169: -- update header status to ALLOCATED
170: UPDATE cn_sca_headers_interface_gtt headers
171: SET process_status = G_ALLOCATED
172: WHERE headers.process_status = G_REV_NOT_100
173: AND headers.sca_batch_id = p_sca_batch_id;
174:

Line 306: FROM cn_sca_headers_interface_gtt g_headers,

302: (SELECT ROUND(
303: lines.allocation_percentage + lines.allocation_percentage *
304: (100 - SUM(g_lines.allocation_percentage)) /
305: SUM(g_lines.allocation_percentage),4)
306: FROM cn_sca_headers_interface_gtt g_headers,
307: cn_sca_lines_output_gtt g_lines
308: WHERE g_headers.sca_headers_interface_id =
309: lines.sca_headers_interface_id
310: AND g_headers.sca_headers_interface_id =

Line 318: FROM cn_sca_headers_interface_gtt headers

314: GROUP BY g_headers.sca_headers_interface_id)
315: WHERE lines.revenue_type = G_REVENUE
316: AND lines.sca_batch_id = p_sca_batch_id
317: AND EXISTS (SELECT 1
318: FROM cn_sca_headers_interface_gtt headers
319: WHERE headers.process_status = G_REV_NOT_100
320: AND headers.sca_headers_interface_id =
321: lines.sca_headers_interface_id);
322:

Line 327: UPDATE cn_sca_headers_interface_gtt headers

323: -- second update to address possible rounding error
324: ONLINE_POST_DIST_UPDATE(p_sca_batch_id => p_sca_batch_id);
325:
326: -- update header status to ALLOCATED
327: UPDATE cn_sca_headers_interface_gtt headers
328: SET process_status = G_ALLOCATED
329: WHERE headers.process_status = G_REV_NOT_100
330: AND headers.sca_batch_id = p_sca_batch_id;
331:

Line 587: FROM cn_sca_headers_interface_gtt shig

583: BEGIN
584: -- get trx_source
585: SELECT shig.transaction_source
586: INTO l_trxSrc
587: FROM cn_sca_headers_interface_gtt shig
588: WHERE shig.sca_batch_id = p_sca_batch_id
589: AND ROWNUM = 1;
590:
591: -- if not found, raise exception