APPS.CN_SCA_CREDITS_ONLINE_PUB dependencies on CN_SCA_WINNING_RULES_GTT

Line 73: -- codeCheck: Though cn_sca_winning_rules_gtt has processed_date column,

69: SELECT DISTINCT transaction_source
70: FROM cn_sca_headers_interface_gtt
71: WHERE sca_batch_id = x_batch_id;
72:
73: -- codeCheck: Though cn_sca_winning_rules_gtt has processed_date column,
74: -- dynamic SQL is not populating this column. That is why I had to refer
75: -- cn_sca_headers_interface_gtt table here. In future this table reference
76: -- need to be eliminated.
77:

Line 83: cn_sca_winning_rules_gtt w,

79: SELECT ROUND(MAX(NVL(csad.rev_split_pct,0)) - SUM(NVL(l.allocation_percentage,0)),4),
80: MIN(l.sca_lines_output_id) sca_lines_output_id,
81: w.sca_headers_interface_id
82: FROM cn_sca_headers_interface_gtt cshi,
83: cn_sca_winning_rules_gtt w,
84: cn_sca_lines_output_gtt l,
85: cn_sca_alloc_details csad,
86: cn_sca_allocations csa
87: WHERE cshi.sca_headers_interface_id = w.sca_headers_interface_id

Line 103: cn_sca_winning_rules_gtt w,

99: SELECT ROUND(MAX(NVL(csad.nonrev_split_pct,0)) - SUM(NVL(l.allocation_percentage,0)),4),
100: MIN(l.sca_lines_output_id) sca_lines_output_id,
101: w.sca_headers_interface_id
102: FROM cn_sca_headers_interface_gtt cshi,
103: cn_sca_winning_rules_gtt w,
104: cn_sca_lines_output_gtt l,
105: cn_sca_alloc_details csad,
106: cn_sca_allocations csa
107: WHERE cshi.sca_headers_interface_id = w.sca_headers_interface_id

Line 178: -- inserted into cn_sca_winning_rules_gtt.

174: -- the winning rule
175: l_package_name := 'cn_sca_rodyn_'|| substr(lower(l_trx_source),1,8) || '_' || abs(l_org_id) || '_pkg';
176: l_stmt := 'BEGIN ' || l_package_name ||'.get_winning_rule(:x_batch_id,:p_org_id,:x_return_status,:x_msg_count,:x_msg_data); END;';
177: -- Execute the dyanmic package to get all the winning rules
178: -- inserted into cn_sca_winning_rules_gtt.
179:
180: --dbms_output.put_line('BEFORE CALLING ');
181: --dbms_output.put_line(l_stmt);
182:

Line 242: FROM cn_sca_winning_rules_gtt

238: FROM cn_sca_alloc_details csad,
239: cn_sca_allocations csa,
240: (SELECT min( sca_credit_rule_id) sca_credit_rule_id,
241: sca_headers_interface_id
242: FROM cn_sca_winning_rules_gtt
243: WHERE sca_batch_id = :x_batch_id2
244: GROUP BY SCA_HEADERS_INTERFACE_ID ) cswrg,
245: cn_sca_headers_interface_gtt cshig,
246: (SELECT count(distinct RESOURCE_ID) count_of_resources ,

Line 340: FROM cn_sca_winning_rules_gtt cswr

336: WHERE cslog.sca_headers_interface_id = cshig.sca_headers_interface_id
337: AND sca_batch_id =x_batch_id
338: AND revenue_type = 'REVENUE'),
339: CREDIT_RULE_ID = (SELECT min( sca_credit_rule_id)
340: FROM cn_sca_winning_rules_gtt cswr
341: WHERE sca_batch_id = x_batch_id
342: and cswr.sca_headers_interface_id = cshig.sca_headers_interface_id)
343: WHERE sca_batch_id = x_batch_id ;
344: --AND EXISTS (SELECT 'X'

Line 365: FROM cn_sca_winning_rules_gtt cswr

361: UPDATE cn_sca_headers_interface_gtt cshig set
362: PROCESS_STATUS = 'NO RULE'
363: WHERE sca_batch_id = x_batch_id
364: AND NOT EXISTS (SELECT 'X'
365: FROM cn_sca_winning_rules_gtt cswr
366: WHERE sca_batch_id = x_batch_id
367: AND cswr.sca_headers_interface_id = cshig.sca_headers_interface_id);
368:
369: