DBA Data[Home] [Help]

APPS.CN_SCA_WF_PKG dependencies on CN_SCA_LINES_OUTPUT_GTT

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 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