APPS.CN_SCA_WF_PKG dependencies on CN_SCA_LINES_OUTPUT

Line 32: UPDATE cn_sca_lines_output lines

28: p_login_id IN number)
29: IS
30: BEGIN
31:
32: UPDATE cn_sca_lines_output lines
33: SET allocation_percentage =
34: (SELECT ROUND(lines.allocation_percentage +
35: (100 - SUM(g_lines.allocation_percentage)),4)
36: FROM cn_sca_headers_interface g_headers,

Line 37: cn_sca_lines_output g_lines

33: SET allocation_percentage =
34: (SELECT ROUND(lines.allocation_percentage +
35: (100 - SUM(g_lines.allocation_percentage)),4)
36: FROM cn_sca_headers_interface g_headers,
37: cn_sca_lines_output g_lines
38: WHERE g_headers.sca_headers_interface_id =
39: lines.sca_headers_interface_id
40: AND g_headers.sca_headers_interface_id =
41: g_lines.sca_headers_interface_id

Line 57: FROM cn_sca_lines_output g_lines

53: WHERE headers.process_status = G_REV_NOT_100
54: AND headers.sca_headers_interface_id =
55: lines.sca_headers_interface_id)
56: AND lines.sca_lines_output_id = (SELECT MIN(sca_lines_output_id)
57: FROM cn_sca_lines_output g_lines
58: WHERE lines.sca_headers_interface_id =
59: g_lines.sca_headers_interface_id
60: AND g_lines.revenue_type = G_REVENUE);
61:

Line 85: UPDATE cn_sca_lines_output_gtt lines

81: p_sca_batch_id IN number)
82: IS
83: BEGIN
84:
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,

Line 90: cn_sca_lines_output_gtt g_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 =
94: g_lines.sca_headers_interface_id

Line 106: FROM cn_sca_lines_output_gtt g_lines

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)
106: FROM cn_sca_lines_output_gtt g_lines
107: WHERE lines.sca_headers_interface_id =
108: g_lines.sca_headers_interface_id
109: AND g_lines.revenue_type = G_REVENUE);
110:

Line 144: UPDATE cn_sca_lines_output_gtt lines

140: -- complement_pct
141: -- new rev pct = curr_rev_pct + --------------
142: -- num_of_res
143: -- *******************************************
144: UPDATE cn_sca_lines_output_gtt lines
145: SET allocation_percentage =
146: (SELECT ROUND(lines.allocation_percentage +
147: (100 - SUM(g_lines.allocation_percentage))
148: / COUNT(*),4)

Line 150: cn_sca_lines_output_gtt g_lines

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 =
154: g_lines.sca_headers_interface_id

Line 219: UPDATE cn_sca_lines_output lines

215: -- complement_pct
216: -- new rev pct = curr_rev_pct + --------------
217: -- num_of_res
218: -- *******************************************
219: UPDATE cn_sca_lines_output lines
220: SET allocation_percentage =
221: (SELECT ROUND(lines.allocation_percentage +
222: (100 - SUM(g_lines.allocation_percentage))
223: / COUNT(*),4)

Line 225: cn_sca_lines_output g_lines

221: (SELECT ROUND(lines.allocation_percentage +
222: (100 - SUM(g_lines.allocation_percentage))
223: / COUNT(*),4)
224: FROM cn_sca_headers_interface g_headers,
225: cn_sca_lines_output g_lines
226: WHERE g_headers.sca_headers_interface_id =
227: lines.sca_headers_interface_id
228: AND g_headers.sca_headers_interface_id =
229: g_lines.sca_headers_interface_id

Line 300: UPDATE cn_sca_lines_output_gtt lines

296: -- curr_rev_pct * complement_pct
297: -- new rev pct = curr_rev_pct + -----------------------------
298: -- curr_total_rev_pct
299: -- **********************************************************
300: UPDATE cn_sca_lines_output_gtt lines
301: SET allocation_percentage =
302: (SELECT ROUND(
303: lines.allocation_percentage + lines.allocation_percentage *
304: (100 - SUM(g_lines.allocation_percentage)) /

Line 307: cn_sca_lines_output_gtt g_lines

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 =
311: g_lines.sca_headers_interface_id

Line 375: UPDATE cn_sca_lines_output lines

371: -- curr_rev_pct * complement_pct
372: -- new rev pct = curr_rev_pct + -----------------------------
373: -- curr_total_rev_pct
374: -- **********************************************************
375: UPDATE cn_sca_lines_output lines
376: SET allocation_percentage =
377: (SELECT ROUND(
378: lines.allocation_percentage + lines.allocation_percentage *
379: (100 - SUM(g_lines.allocation_percentage)) /

Line 382: cn_sca_lines_output g_lines

378: lines.allocation_percentage + lines.allocation_percentage *
379: (100 - SUM(g_lines.allocation_percentage)) /
380: SUM(g_lines.allocation_percentage),4)
381: FROM cn_sca_headers_interface g_headers,
382: cn_sca_lines_output g_lines
383: WHERE g_headers.sca_headers_interface_id =
384: lines.sca_headers_interface_id
385: AND g_headers.sca_headers_interface_id =
386: g_lines.sca_headers_interface_id