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 4185: cn_interval_types cit

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