DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_CREDIT_TYPES

Line 343: FROM cn_credit_types

339: IF p_plan_element_rec.credit_type IS NOT NULL
340: THEN
341: SELECT credit_type_id
342: INTO l_pe_rec.credit_type_id
343: FROM cn_credit_types
344: WHERE NAME = l_pe_rec.credit_type and org_id = p_plan_element_rec.org_id and rownum=1;
345: END IF;
346: EXCEPTION
347: WHEN NO_DATA_FOUND

Line 4185: cn_credit_types ct,

4181: q.org_id,
4182: q.indirect_credit,
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