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_RULESETS

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

Line 292: l_ruleset_id cn_rulesets.ruleset_id%type;

288: and commission_header_id = p_commission_header_id
289: and rs.org_id = ch.org_id
290: and module_type = 'ACCGEN' ;
291:
292: l_ruleset_id cn_rulesets.ruleset_id%type;
293:
294: l_stmt varchar2(4000);
295: l_profile_value varchar2(01);
296: l_payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE;