DBA Data[Home] [Help]

APPS.CN_COMMISSION_CALC_PVT dependencies on CN_RULESETS

Line 500: FROM cn_rulesets cr

496: AND cs.org_id = g_cached_org_id
497: )
498: , cpcg.ruleset_id = (
499: SELECT ruleset_id
500: FROM cn_rulesets cr
501: WHERE cpcg.calc_date BETWEEN cr.start_date AND nvl(cr.end_date,cpcg.calc_date)
502: AND cr.module_type = 'PECLS'
503: and cr.org_id = g_cached_org_id
504: )