eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_WF_PMT_PKG dependencies on CN_COMMISSION_HEADERS_ALL

Line 40: FROM cn_commission_headers_all cnch

36:
37: -- added new cursor for for bug#2568937 start
38: CURSOR get_revenue_class(l_commission_header_id NUMBER) IS
39: SELECT revenue_class_id revenue_class_id
40: FROM cn_commission_headers_all cnch
41: WHERE cnch.commission_header_id = l_commission_header_id;
42: -- added new cursor for for bug#2568937 end
43:
44: CURSOR get_accgen_type IS

Line 286: from cn_rulesets_all rs, cn_commission_headers_all ch

282: l_rule_id NUMBER;
283:
284: cursor ruleset_cur ( p_commission_header_id number ) is
285: select ruleset_id
286: from cn_rulesets_all rs, cn_commission_headers_all ch
287: where processed_date between start_date and end_date
288: and commission_header_id = p_commission_header_id
289: and rs.org_id = ch.org_id
290: and module_type = 'ACCGEN' ;