DBA Data[Home] [Help]

APPS.CN_WF_PMT_PKG dependencies on CN_RULESETS_ALL

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