DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_INTERVAL_TYPES

Line 358: FROM cn_interval_types

354: IF p_plan_element_rec.interval_name IS NOT NULL
355: THEN
356: SELECT interval_type_id
357: INTO l_pe_rec.interval_type_id
358: FROM cn_interval_types
359: WHERE NAME = l_pe_rec.interval_name
360: and org_id = l_pe_rec.ORG_ID;
361: END IF;
362: EXCEPTION

Line 4187: cn_interval_types cit

4183: q.salesreps_enddated_flag
4184: FROM cn_quotas q,
4185: cn_credit_types ct,
4186: cn_calc_formulas cf,
4187: cn_interval_types cit
4188: WHERE q.NAME = pe_name
4189: AND q.org_id = p_org_id
4190: --AND q.credit_type_id = ct.credit_type_id(+)
4191: --AND q.calc_formula_id = cf.calc_formula_id(+)