APPS.CN_SCA_CREDITS_ONLINE_PUB dependencies on CN_SCA_ALLOC_DETAILS

Line 85: cn_sca_alloc_details csad,

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
88: AND w.sca_headers_interface_id = l.sca_headers_interface_id
89: AND w.sca_credit_rule_id = csa.sca_credit_rule_id

Line 105: cn_sca_alloc_details csad,

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
108: AND w.sca_headers_interface_id = l.sca_headers_interface_id
109: AND w.sca_credit_rule_id = csa.sca_credit_rule_id

Line 238: FROM cn_sca_alloc_details csad,

234: ROUND(csad.rev_split_pct/nvl(crc.count_of_resources,1),4) rev_value,
235: DECODE(csad.nrev_credit_split,''Y'',
236: ROUND(csad.nonrev_split_pct/NVL(crc.count_of_resources,1),4),
237: csad.nonrev_split_pct) non_rev_value
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