APPS.CN_CALC_CLASSIFY_PVT dependencies on CN_RULESETS_ALL

Line 74: FROM cn_rulesets_all

70: CURSOR ruleset_cr IS
71: SELECT ruleset_id,
72: Greatest(start_date, l_min_start_date) start_date,
73: Least(Nvl(end_date,l_max_end_date), Nvl(l_max_end_date, end_date)) end_date
74: FROM cn_rulesets_all
75: WHERE ((start_date < l_min_start_date AND (end_date IS NULL OR end_date >= l_min_start_date )) OR
76: start_date BETWEEN l_min_start_date AND l_max_end_date)
77: AND module_type = 'REVCLS'
78: AND org_id = g_org_id

Line 438: from cn_rulesets_all

434: ':154,:155,:156,:157,:158,:159,:160,:161,:162,:163,:164,:165,:166,:167,:168,:169,:170,:171,:172,:173); end;';
435:
436: cursor get_ruleset(l_org_id number, l_proc_date date) is
437: select ruleset_id, ruleset_status
438: from cn_rulesets_all
439: where org_id = l_org_id
440: and module_type = 'REVCLS'
441: and l_proc_date between start_date and nvl(end_date,l_proc_date);
442: